Senior Data Analyst – Public Sector
Core
Lead data migration, integration, and synchronization between legacy and modern public-sector systems (CCWIS, Medicaid, etc.) to ensure data integrity during modernization.
Role type
Senior IC data analyst / technical lead (data migration & integration)
Builds
Production data bridges, ETL processes, and synchronized data environments for public sector agencies
Domain
Public sector / Government / Health and Human Services
Required skills
Advanced SQL, ETL tooling, data mapping, data profiling, record matching, identity resolution, reconciliation, technical leadership, project coordination
Preferred skills
Child welfare domain knowledge, Change Data Capture (CDC), SaaS integration, Python, PowerShell, Cloud platforms (AWS/Azure), Master Data Management
Technologies
AWS, Azure, Informatica, MuleSoft, Oracle, SSIS, Talend, Qlik, Salesforce, PowerShell, Python, SQL Server
Responsibilities
Profile and analyze legacy data for quality issues; Create and maintain source-to-target mappings and transformation rules; Build, run, test, and tune ETL processes for production cutover; Support synchronization between legacy and modern systems; Match, merge, and deduplicate records while resolving identities; Develop reconciliation and validation procedures; Investigate and resolve migration and data-quality issues; Coordinate with business, technical, vendor, and project teams; Document data lineage and technical processes; Oversee a multidisciplinary technical team during modernization initiatives
Seniority
Senior, hands-on IC with technical leadership (via careerplan.io/jobs/g509e60a-senior-data-analyst-public-sector-at-estaffllc)
