Database Analyst/Programmer IV

This position is for a Lead Data Analyst to support large-scale data migration efforts. The role involves leading data analysis activities, including source-to-target mapping, data profiling, and gap analysis between legacy systems and the Facets platform. The objective is to ensure data integrity and accuracy throughout the migration lifecycle for a federal healthcare customer., * Lead data analysis for migration planning, including source-to-target data mapping, data profiling, and gap analysis.

• Define data quality metrics, establish reconciliation criteria, and validate migration results against requirements.
• Conduct detailed data assessments to identify inconsistencies, anomalies, and data-related risks.
• Develop and maintain data mapping specifications, profiling reports, data dictionaries, and lineage documentation.
• Ensure data integrity by collaborating with data architects, ETL/ELT developers, business analysts, and test teams.
• Provide analytical support for the Data Migration Plan, including dependency analysis and sequencing recommendations.
• Lead stakeholder working sessions to refine data requirements and address data issues.
• Support test planning by creating data validation rules, test scenarios, and reconciliation processes.
• Monitor migration execution, perform reconciliation, and coordinate issue resolution.
• Ensure adherence to data governance, security, privacy, and quality standards.

• Minimum of 8 years of experience with a BS/BA degree, 6 years with an MS/MA degree, or 3 years with a PhD.
• Minimum of 8 years of experience in data analysis, data profiling, or data management in large, complex enterprise environments.
• Demonstrated experience supporting large-scale data migration, legacy modernization, or COTS platform integration.

Technical Skills:

• Proficiency with SQL for data discovery, validation, and reconciliation.
• Experience developing data quality rules, reconciliation approaches, and validation criteria.
• Understanding of data models, metadata, data lineage, and the impacts of ETL/ELT transformations.
• Experience producing data migration documentation such as mapping specifications and profiling reports.
• Ability to communicate effectively with technical and non-technical stakeholders., * Experience with healthcare payer platforms, especially Facets.
• Experience with cloud data platforms or integration tools within AWS, Azure, or Google Cloud Platform.
• Knowledge of enterprise data governance tools (e.g., Collibra, Informatica, Alation).
• Experience supporting structured SDLC, Agile, or hybrid project delivery methodologies.
• Familiarity with federal healthcare programs, CMS environments, or regulatory requirements such as HIPAA.
• Relevant data or analytics certifications.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at