Data Analyst

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.