Hybrid Senior Data Analyst - Public Sector Data Migration

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

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.