Data Conversion Specialist

Connect Tech+Talent; Austin (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

Connect Tech+Talent is seeking a Data Conversion Developer based in Austin, Texas, offering hybrid or fully remote work. The candidate should have extensive experience in data conversion development for pension administration system modernization.

Key qualifications include proficiency in SSIS, SQL Server, C#, and Azure Data Factory, with a focus on managing large-scale data sets. The position is a contract role with a strong emphasis on ETL processes and data reconciliation.

Qualifications

• 4+ years of data conversion development experience.
• 4+ years of SSIS package development and BIML scripting.
• 4+ years of SQL Server and T-SQL development with complex stored procedures.
• 3+ years of C# and .NET development for automation scripts.
• 3+ years of data migration experience.
• 2+ years of data reconciliation experience.

Skills

Data conversion development

SSIS package development

SQL Server development

C# and .NET development

Legacy data migration

Data reconciliation processes

Azure Data Factory

Power BI

Cloud data warehouse development

Job description

Location

Austin, Texas (Hybrid or fully remote)

Employment Type

Contract

Minimum Qualifications

• 4+ years of data conversion development for large-scale pension administration system modernization programs; source-to-target mapping, ETL execution, exception handling, and validation across multi-billion-record legacy data sets
• 4+ years of SSIS package development and BIML scripting for automated, repeatable data extraction, transformation, and load processes across legacy pension and structured relational data environments
• 4+ years of SQL Server and T-SQL development including complex stored procedures, views, indexing strategies, query optimization, and execution plan analysis to support high-volume ETL and reconciliation workflows
• 3+ years of C# and .NET development for data conversion automation scripts, SSIS custom components, and backend data processing logic within a structured SDLC environment
• 3+ years of legacy system data migration experience including source environments; multi-environment extract and load processes; participation in mock runs, UAT cycles, and production cutover activities
• 2+ years of data reconciliation processes including record count validation, key field comparison, exception reporting, authorization and exclusion logic, and validation within a large-scale pension or benefits modernization platform

Preferred Qualifications

• 3+ years of Azure Data Factory, PySpark, or Apache Airflow pipeline development for ELT/ETL orchestration, incremental loading strategies, and data quality validation in cloud or hybrid data environments
• 2+ years of Power BI or SSRS dashboard and report development including ETL job completion tracking, exception rate reporting, and data quality KPI visualization for program leadership and QA teams
• 2+ years of cloud data warehouse development using dbt Core for staging, intermediate, and reporting layer transformations with incremental load strategies (SnowPro Core or Microsoft Fabric certification a plus)
• 2+ years of defect triage and root cause analysis using SQL scripts and SSIS debugging techniques; cross-functional collaboration with QA, functional testers, and business analysts during mock loads and UAT resolution cycles