Sr. Data Analyst with Data Bridge -- W2 Profiles -- Hybrid

Role: Sr. Data Analyst with Data Bridge

Location: Austin, TX - Hybrid

Key Responsibilities

• Profile and analyze legacy data to identify gaps, duplicates, invalid values, and data-quality issues.

• Develop and maintain source-to-target mappings, transformation rules, data dictionaries, and code-value crosswalks.

• Build, execute, test, and tune ETL processes supporting mock conversions, testing, and production cutover.

• Support data synchronization between legacy and modern systems through interfaces, APIs, change data capture, or scheduled data exchanges.

• Perform data matching, merging, deduplication, and identity resolution while preserving relationships and historical data.

• Develop reconciliation and validation processes using record counts, control totals, field-level comparisons, and sampled record testing.

• Investigate and resolve data migration, conversion, integration, and quality issues; support UAT, testing, and cutover activities.

• Work with business, program, technical, vendor, and project teams to clarify data requirements and communicate issues and findings.

• Document data lineage, mappings, technical processes, validation procedures, and run books.

• Support applicable federal and program reporting requirements, including AFCARS, NCANDS, NYTD, and CCWIS data-quality requirements.

Required Qualifications

• 8+ years of experience in data analysis, data profiling, data quality, mapping, validation, reconciliation, or related data-focused technology work.

• Demonstrated experience providing technical leadership for a multidisciplinary data migration, integration or synchronization team.

• Experience coordinating technical deliverables across multiple teams or vendors during a complex modernization initiative.

• Experience maintaining data integrity between legacy and replacement systems during extended parallel operations, including troubleshooting synchronization failures and resolving reconciliation discrepancies.

• 5+ years working with business, technical, vendor, and project teams on complex data initiatives.

• 5+ years supporting data migration, integration, synchronization, conversion, or related implementation activities.

• 3+ years supporting public-sector or government organizations.

• Hands-on experience with CCWIS, SACWIS, CWIS, or a comparable state health and human services system such as Medicaid, SNAP, TANF, DHS, or integrated eligibility.

• Advanced SQL experience with Oracle, SQL Server, or similar relational databases.

• Hands-on experience with an ETL/integration tool, such as Informatica, SSIS, Azure Data Factory, Talend, MuleSoft, or similar.

• Experience developing data mappings, transformation rules, data dictionaries, and reconciliation/validation scripts.

• Experience supporting data synchronization or a data bridge between legacy and modern systems operating in parallel

• Bachelor's degree or equivalent work-related experience.

Preferred Qualifications

• Experience with child welfare programs, systems, and data migration.

• Knowledge of AFCARS, NCANDS, NYTD, or other child welfare reporting requirements.

• Experience with Oracle GoldenGate, Qlik Replicate, Debezium, or other change-data-capture technologies.

• Experience integrating with Salesforce, Microsoft Dynamics, or other SaaS/low-code platforms.

• Python or PowerShell experience for data validation and automation.

• Experience with Azure, AWS, master data management, identity resolution, or deduplication.