Data Conversion Specialist

We are seeking an experienced Data Conversion Specialist for a hybrid OR remote contract opportunity in Austin, Texas. General Description: This role is for a Data Conversion Specialist with hands-on experience in large-scale public pension administration system modernization programs, specializing in ETL development, data reconciliation, and legacy system data migration. The role is technical in nature and requires the Worker to function as the primary conversion execution resource on Provaliant’s delivery team, responsible for building and maintaining the ETL pipelines, conversion scripts, and reconciliation tooling that drive the RISE data migration workstream. The Worker must demonstrate direct experience developing data conversion programs for pension or benefits system modernization projects, including source-to-target mapping execution, SSIS/BIML type development, SQL Server and T-SQL optimization, and participation in mock run and UAT cycles through production cutover. The Worker will follow all organizational Standard Operating Procedures related to deliverable approvals, reviews, and associated workflows. The Worker will rely on their technical experience to collaboratively develop and maintain conversion assets, troubleshoot ETL exceptions, and collaborate closely with the Technical Architect, ML/AI Engineer, and ERS data stewards to resolve data issues and ensure converted data aligns with functional requirements and business rules. Strong attention to detail, structured debugging discipline, and cross-functional communication skills are expected. Functional Responsibilities: ERS is seeking a Data Conversion Specialist with direct hands-on experience in large-scale pension or benefits system data migration programs. The Worker will execute the technical data conversion workstream for the RISE program, developing and maintaining ETL pipelines, reconciliation scripts, and conversion monitoring tools across all CDR cycles. The worker will be responsible for: • 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 ERS 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 The Worker should have strong hands-on experience in pension or benefits system data conversion development within a structured, governance-driven program environment. WORKER SKILLS AND QUALIFICATIONS Minimum: • 4+ yrs 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+ yrs SSIS package development and BIML scripting for automated, repeatable data extraction, transformation, and load processes across legacy pension and structured relational data environments • 4+ yrs 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+ yrs C# and .NET development for data conversion automation scripts, SSIS custom components, and backend data processing logic within a structured SDLC environment • 3+ yrs 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+ yrs 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: • 3+ yrs 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+ yrs 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+ yrs 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+ yrs 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 Professional Expectations: • Attends all meetings, meets delivery deadlines and is available during ERS office hours. • Logs in and remains on agency Jabber during work hours. • Attends remote meetings with camera on unless prior arranged for camera off. • Coordinates leave and vacation with ERS lead. • Must dress appropriately for a business/business casual environment. • Communicates respectfully and works harmoniously with all co-workers, customers and vendors. • Provides exceptional customer service. • Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks. • Takes initiative to prevent and solve problems. What We Offer: Sistema offers competitive pay and solid benefits, including medical, dental, and vision coverage. We keep things simple, focus on people, and prioritize long-term relationships with our clients and consultants. Apply now if you’re a clear communicator, problem solver, and ready to work in a hybrid or remote environment in Austin, Texas!