Data Conversion Specialist

Job Description

🚀 Hiring: Data Conversion Specialist 🚀

📍 Location: Austin, TX (Hybrid)

📅 Duration: 12 Months (Potential Extension)

We are seeking an experienced Data Conversion Specialist with strong expertise in large-scale pension or benefits system modernization programs, ETL development, data migration, and reconciliation activities.

Key Responsibilities:

✅ Design, develop, and maintain ETL pipelines and conversion scripts

✅ Execute source-to-target mapping and data transformation processes

✅ Develop SSIS packages, BIML scripts, and SQL Server/T-SQL solutions

✅ Perform data reconciliation, validation, and exception reporting

✅ Support mock runs, UAT cycles, and production cutovers

✅ Collaborate with Technical Architects, QA teams, Data Stewards, and stakeholders

✅ Monitor ETL job execution and maintain conversion reporting dashboards

Required Skills:

✔ 4+ years of Data Conversion experience in Pension/Benefits Modernization projects

✔ Strong ETL Development, Data Migration & Reconciliation expertise

✔ SSIS, BIML, SQL Server, T-SQL

✔ Stored Procedures, Query Optimization, Indexing & Performance Tuning

✔ C# and .NET development experience

✔ Legacy System Data Migration and Production Cutover support

Preferred Skills:

⭐ Azure Data Factory (ADF)

⭐ PySpark / Apache Airflow

⭐ Power BI / SSRS

⭐ dbt Core, Snowflake, Microsoft Fabric

⭐ ETL Monitoring & Data Quality Reporting

If you have hands-on experience in ETL Development, SSIS, BIML, SQL Server, Data Migration, and Pension/Benefits System Modernization, we'd love to connect!