AI Data Conversion Specialist - Austin, TX (Hybrid/Remote)

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+ SSIS package development and BIML scripting for automated, repeatable data extraction, transformation, and load processes across legacy pension and structured relational data environments. 4+ 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+ C# and .NET development for data conversion automation scripts, SSIS custom components, and backend data processing logic within a structured SDLC environment. 3+ 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+ Data reconciliation including record count validation, key field comparison, exception reporting, authorization and exclusion logic, and validation within a large-scale pension or benefits modernization platform. 1+ Large-scale public pension administration system modernization data conversion experience. 1 Database Administrator experience. Preferred Skills and Experience: Years Skills / Experience 3+ 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+ 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+ 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+ 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.

Years

Hub International

• Austin, TX About Us: HUB is a global insurance and employee benefits broker, providing a broad array of property, casualty, risk management, life and health, employee benefits, investment a…