Data Analyst

Data Analyst

Req number: R5169

Employment type: Full time

Worksite flexibility: Hybrid

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.

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 of Material Management (Master Data and Transaction Data). Knowledge of SAP Real Estate module is a plus.

• Proven experience in data migration, data management, or data integration projects.

• Fast learner with ETL tools (e.g., 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 application.accommodations@cai.io or (888) 824 – 8111.