Data Analyst
spruce infotechLake Forest, IL
Data Analyst
spruce infotechLake Forest, IL
2 days ago
Industries
Computer Systems Design ServicesCustom Computer Programming ServicesOther Scientific and Technical Consulting ServicesAbout the role
We are seeking a detail-orientedData Analystwith strong experience indata mapping, data analysis, and data transformation. The ideal candidate will work closely with business stakeholders, data engineers, and application teams to analyze source and target data structures, define mapping requirements, and ensure accurate data migration and integration across systems.
Key Responsibilities:
Gather, analyze, and document business and data requirements.
Perform source-to-target data mapping for data migration, integration, and reporting projects.
Analyze complex datasets to identify data quality issues, inconsistencies, and transformation requirements.
Create and maintain mapping documents, data dictionaries, and metadata repositories.
Work with business users to understand data elements, relationships, and business rules.
Validate data mappings and transformation logic through testing and reconciliation activities.
Collaborate with ETL developers, Data Engineers, and QA teams to ensure accurate implementation of mappings.
Conduct data profiling and data quality assessments.
Support data governance initiatives by documenting data lineage and business definitions.
Prepare reports, dashboards, and analytical insights as required.
Required Skills:
5+ years of experience as a Data Analyst.
Strong experience inData MappingandSource-to-Target Mapping (STM).
Proficiency in SQL for data analysis and validation.
Experience with data migration, data integration, and ETL processes.
Strong understanding of relational databases and data models.
Experience with data profiling and data quality analysis.
Ability to create detailed mapping specifications and functional documentation.
Excellent analytical, problem-solving, and communication skills.
Preferred Skills:
Experience with ETL tools such as Informatica, Talend, SSIS, or DataStage.
Knowledge of cloud data platforms (AWS, Azure, or GCP).
Experience with BI tools such as Power BI, Tableau, or Looker.
Familiarity with data governance and master data management concepts.
Education
Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
Matching similar jobs
JOB OVERVIEW
Experience level
Lead
Location
Lake Forest, IL
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
2 days ago
Tired of running searches?
Rank the roles you'd take once, and matches like these arrive on their own.
CREATE PROFILE (opens in a new tab)