Senior Data Conversion Developer

Peak Performers has partnered with a Texas State Agency to assist in their search for a contract Senior Data Conversion Developer . In this position, you will be responsible for executing the technical data conversion work stream for the RISE program, developing and maintaining ETL pipelines, reconciliation scripts, and conversion monitoring tools across all CDR cycles. Major duties • Develop and maintain packages and scripts for automated, repeatable data extraction, transformation, and load processes across legacy source data and target schema • Implement and optimize stored procedures, views, indexes, and SQL queries to support high-volume ETL operations and data reconciliation workflows • Develop automation scripts for conversion process orchestration, custom components, and backend data processing logic across multiple CDR cycles • Execute source-to-target mapping in alignment with CDR specifications, applying authorization and exclusion logic to filter ineligible, duplicate, or obsolete member and employer records • Participate in data reconciliation activities including record count validation, key field comparison, exception reporting, screen validation within the Ariel platform • Support multiple extract and load processes across development, test, and production environments, ensuring converted data aligns with functional requirements and agency business rules • Collaborate with QA teams, functional testers, and the ML/AI Engineer to verify data migration results, resolve defects, and implement fixes during mock runs and UAT cycles • Generate and maintain conversion monitoring reports tracking ETL job completion, exception handling, and data validation statistics for program leadership visibility What are we looking for? • 4+ years of experience supporting data conversion development for large-scale pension administration system modernization, including source-to-target mapping, ETL execution, exception handling, and validation of very large legacy data sets. • Strong hands-on experience in pension or benefits system data conversion development within a structured, governance-driven program environment. • 4+ years of experience developing SSIS packages and BIML scripts to automate repeatable data extraction, transformation, and load processes. • 4+ years of experience with SQL Server and T-SQL, including stored procedures, views, indexing, query optimization, and execution plan analysis for high-volume ETL and reconciliation. • 3+ years of experience using C# and .NET to build data conversion automation scripts, SSIS custom components, and backend data processing logic. • 3+ years of legacy data migration experience, including multi-environment extract/load processes, mock runs, UAT, and production cutover support. • 2+ years of experience with data reconciliation, including record counts, key field comparisons, exception reporting, and validation logic. • Preferred: 3+ years of experience with Azure Data Factory, PySpark, or Apache Airflow for ETL/ELT orchestration and data quality checks. • Preferred: 2+ years of experience building Power BI or SSRS dashboards for job tracking, exception reporting, and KPI visibility. • Preferred: 2+ years of cloud data warehouse development using dbt Core with incremental load strategies. • Preferred: 2+ years of defect triage and root cause analysis using SQL scripts and SSIS debugging in collaboration with QA and business teams. Exciting Opportunity Details • Rate: $109.00/hour • W2 Contract • Worksite Location: Can be remote or Hybrid in Austin, Tx • 6 month contract with the opportunity for extension The Peak Performers difference • Excellent medical health, dental & vision insurance at 60 days • Our employees may choose to participate in a 403(b) retirement plan • Qualified applicants with chronic medical conditions and/or disabilities receive priority placement • We pay weekly through direct deposit • In business since 1994 and thousands of job placements All employment offers are contingent on the successful completion of a pre-employment criminal background check, in compliance with all applicable federal and state laws. Applicants for employment with Peak Performers must possess work authorization that does not require sponsorship for a visa now or in the future. Peak Performers is an equal opportunity employer and will consider all applicants without regard to race, marital status, sex, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law. Peak Performers does not accept unsolicited resumes from headhunters, recruitment agencies or fee-based recruitment services. Hv265259619