IT - Database Analyst​/Programmer IV

IT - 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.

Key Responsibilities

• 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.

Required Qualifications

Education & Experience:

• 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.

Preferred Qualifications

• Experience with healthcare payer platforms, especially Facets.
• Experience with cloud data platforms or integration tools within AWS, Azure, or GCP.
• 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.