Senior Data Analyst

Prepcloud

Prepcloud is looking for a Senior Data Analyst to join their team in Los Angeles to support the IPMS project. This role is essential for managing data transitions and ensuring data integrity during system upgrades and integrations. Candidates will collaborate closely with developers and business analysts to accomplish project goals.

In this role you can expect to have the responsibilities:

• Execute data migration from legacy systems to new platforms.
• Identify and resolve data inconsistencies and quality issues.
• Develop logic for accurate alignment of source and target data structures.
• Perform data validation manually using Excel and automated tools.
• Conduct Excel analysis using pivot tables, VLOOKUP, and macros.
• Write complex SQL queries for data analysis and troubleshooting.
• Create reports and dashboards to track data conversion progress.
• Collaborate with developers, business analysts, and project managers.
• Document data conversion processes, mapping logic, and validation results.

This role comes with the following benefits:

This role requires you to have:

• Enterprise-wide data migration experience, including mapping and validation.
• Advanced proficiency in SQL scripting and large dataset manipulation.
• Strong expertise in advanced Excel functions, pivot tables, and macros.
• Experience in data reconciliation, cleanup, and validation techniques.
• Ability to analyze complex data structures.
• Proficiency in documenting processes and data mapping logic.
• Experience in working with cross-functional teams.
• Effective communication skills for technical concepts.

You would benefit from having: