Senior Data Analyst

Digerati Systems Inc.; Austin (TX); Hybrid; USD 95,000 - 140,000; Full time

Job summary

Digerati Systems Inc. in Austin, TX, seeks a Senior Data Analyst to support data migration, modernization, and data quality initiatives for public-sector systems.

Hybrid work arrangement: 4-days onsite, local candidates only. You will profile legacy data, develop source-to-target mappings, and drive ETL testing, validation, and cutover activities while maintaining data continuity across legacy and new platforms.

Qualifications

• 8+ years of data analysis, profiling, quality, mapping, validation, or related data-focused work.
• 5+ years collaborating with cross-functional teams on complex data initiatives.
• 5+ years supporting data migration, integration, or conversion activities.
• 3+ years in public-sector environments.
• Hands-on with CCWIS, SACWIS, CWIS or similar health and human services systems.
• Advanced SQL with Oracle/SQL Server or equivalent.
• Experience with ETL/integration tools (Informatica, SSIS, ADF, Talend, MuleSoft).
• Experience developing data mappings, dictionaries, and reconciliation scripts.
• Experience enabling data synchronization between legacy and modern systems.
• Bachelor's degree or equivalent work experience.

Responsibilities

• Profile and analyze legacy data to identify gaps and quality issues.
• Develop source-to-target mappings, transformation rules, and data dictionaries.
• Build, test, and tune ETL processes for migrations and conversions.
• Support data synchronization between legacy and modern systems.
• Perform data matching, deduplication, and identity resolution.
• Develop reconciliation and validation processes using counts and cross-checks.
• Investigate data migration and quality issues; support UAT and cutover.
• Collaborate with business, technical, vendor, and project teams on data requirements.
• Document data lineage, mappings, and validation procedures.
• Support AFCARS, NCANDS, NYTD, CCWIS reporting where applicable.

Skills

Advanced SQL

SQL Server

Oracle

ETL tools

Data profiling

Data quality

Data mapping

Data reconciliation

Public sector data

Stakeholder collaboration

Education

Bachelor's degree or equivalent

Tools

Informatica

SSIS

Azure Data Factory

Talend

MuleSoft

Oracle GoldenGate

Qlik Replicate

Debezium

Job description

Senior Data Analyst Child welfare programs

Location: Austin, Texas HYBRID (4-days onsite - ONLY local candidates)

About the Role

The Senior Data Analyst will support data migration, modernization, integration, synchronization, and data quality initiatives for complex public-sector systems. This role will analyze and profile legacy data, develop source-to-target mappings and transformation rules, support ETL and conversion activities, and validate and reconcile data as it moves from legacy to modern platforms. The analyst will also help maintain data continuity while legacy and new systems operate in parallel.

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