Data Analyst
Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Title: Data Analyst
Location: Saint Louis MO
Job Type: Contract
Job Overview:
We are seeking a Data Analyst with expertise in SQL databases ETL processes and data validation to support our data migration and integration initiatives. This role requires a strong understanding of database structures data mapping and transformation processes particularly with SAGE CRE 300 and CMiC systems. The ideal candidate will have a keen eye for detail and the ability to analyze large datasets compare old vs. new data and provide insights to ensure accurate data migration.
Key Responsibilities:
- Analyze and understand database structures key fields and relationships between data tables.
- Extract and query data from SQL tables replicated from SAGE CRE 300 for validation and analysis.
- Work with complex mapping tables to track data movement from SAGE CRE 300 to CMiC via ETL processes.
- Extract preformatted data from CMiC software client for validation and reporting.
- Perform detailed data comparisons (old vs. new datasets) and provide feedback to the ETL team regarding errors inconsistencies and anomalies.
- Handle large datasets (hundreds of thousands of rows) efficiently using SQL Excel or other data comparison tools.
Qualifications & Skills:
- Bachelors degree in Data Analytics Computer Science Information Systems or a related field.
- Proficiency in SQL ability to write queries for data extraction and validation.
- Experience with SAGE CRE 300 and CMiC software is highly preferred.
- Strong understanding of ETL processes and data mapping techniques.
- Advanced skills in Excel (VLOOKUPs Pivot Tables Power Query) and data comparison tools.
- Strong analytical skills with attention to detail and problemsolving abilities.
- Ability to work collaboratively with ETL teams and stakeholders to ensure data integrity.
Preferred Qualifications:
- Experience working with construction or enterprise resource planning (ERP) systems.
- Knowledge of data transformation cleansing and reporting best practices.
- Familiarity with business intelligence (BI) tools for data visualization and reporting.
SQL DATABASES , SQL , DATA MAPPING
Employment Type
Full Time
