Data Analyst
Req number:
R5169
Employment type:
Full time
Worksite flexibility:
HybridWho we are
CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Job Summary
We are looking for a Data Analyst to provide data assessment, data extraction and data integration. This position will be full-time and hybrid work setup.
Job Description
Job Description
We are looking for a Data Analyst to provide data assessment, data extraction and data integration. This position will be full-time and hybrid work setup.
What You'll Do
-
Data Assessment and Planning:
-
Evaluate existing data sources, structures, and formats to understand migration requirements.
-
Collaborate with Data Owners to define migration objectives, scope, and timelines.
-
Develop and execute data migration strategies that align with organizational goals.
-
Data Extraction and Transformation:
-
Extract data from legacy systems, identify discrepancies, and prepare data for migration.
-
Use data transformation tools to clean, format, and standardize data according to the target system’s specifications.
-
Perform data mapping to ensure consistency and compatibility with the new environment.
-
Creation of query and load scripts/tool (data migration ETL Tool).
-
Data Loading and Integration:
-
Load data into the target system while ensuring minimal disruption to ongoing operations.
-
Troubleshoot and resolve issues related to data integration and loading processes.
-
Quality Assurance and Validation:
-
Perform rigorous testing of migrated data to ensure accuracy, completeness, and integrity.
-
Conduct post-migration validation and reconciliations, identifying and addressing any discrepancies.
-
Provide ongoing support for data issues that arise post-migration.
-
Documentation and Reporting:
-
Document migration processes and issues for future reference and auditing purposes.
-
Provide regular updates to project team on progress, issues, and risks.
-
Collaboration and Communication:
-
Work closely with IT teams, data analysts, and business data owners to understand requirements and provide solutions.
-
Ensure clear communication of technical and non-technical aspects of data migration activities.
What You'll Need
-
Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
-
Deep knowledge on Material Management (Master Data and Transaction Data). Knowledge on SAP Real Estate module is a plus.
-
Proven experience in data migration, data management, or data integration projects.
-
Fast learner with ETL tools (ex. Precisely, BODS, LSMW) and scripting languages.
-
Solid knowledge of data mapping, data transformation, and data validation processes.
-
Excellent problem-solving, analytical, and troubleshooting skills.
-
Strong attention to detail with the ability to identify and correct errors.
-
Effective communication skills and ability to work collaboratively in cross-functional teams.
Preferred
-
Experience with specific industry tools or platforms (SAP ECC, SAP S4/HANA, Precisely).
-
Knowledge of data governance and data quality best practices.
Physical Demands
-
May require occasional on-site work or client meetings.
-
Flexible working hours depending on project requirements.
-
Extended working hours depending on the project requirements.
Reasonable accommodation statement
If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.
