Location: Austin, TX (Hybrid or Remote within Texas)

Employment Type: Long-Term Contract

We are seeking a Data Migration AI Engineer to support a large-scale public pension administration system modernization initiative. This role serves as the primary technical resource responsible for executing the data conversion workstream, including ETL development, legacy data migration, reconciliation, and conversion automation. The ideal candidate has extensive experience delivering data migration solutions within structured, governance-driven pension or benefits modernization programs and thrives in highly collaborative environments.

Responsibilities

• Develop and maintain automated ETL packages and scripts for extracting, transforming, and loading legacy data into target systems.
• Build and optimize SQL Server objects, including stored procedures, views, indexes, and complex T-SQL queries to support high-volume ETL processing.
• Develop conversion automation scripts, SSIS custom components, and backend processing logic using C# and .NET.
• Execute source-to-target mapping according to conversion specifications while applying authorization, exclusion, and duplicate filtering logic.
• Perform data reconciliation activities including record count validation, key field comparisons, exception reporting, and screen validation within the Ariel platform.
• Support data extraction and loading across development, testing, and production environments.
• Collaborate with Technical Architects, AI/ML Engineers, QA teams, functional testers, and business stakeholders to validate conversion results and resolve migration defects.
• Participate in mock conversion runs, User Acceptance Testing (UAT), and production cutover activities.
• Develop and maintain conversion monitoring reports that track ETL execution, exception handling, and data validation metrics.
• Troubleshoot ETL failures, optimize performance, and ensure converted data aligns with business rules and functional requirements.
• Follow organizational standards, governance processes, and documentation requirements throughout the project lifecycle.

Required Qualifications

• 4 years of experience with large-scale pension or benefits system data conversion and modernization projects.
• 4 years of hands-on ETL development using SSIS and BIML.
• 4 years of SQL Server and T-SQL development, including:
  • Stored procedures
  • Views
  • Index optimization
  • Query tuning
  • Execution plan analysis
• 3 years of C# and .NET development supporting data conversion automation and backend processing.
• 3 years of legacy system data migration experience, including:
  • Multi-environment data loads
  • Mock conversions
  • UAT support
  • Production cutover
• 2 years of data reconciliation experience, including:
  • Record count validation
  • Key field comparison
  • Exception reporting
  • Authorization and exclusion logic
• Experience developing source-to-target mapping and executing large-scale data migration workflows.
• Strong troubleshooting, debugging, and analytical problem-solving skills.
• Ability to work collaboratively within cross-functional technical teams.

Preferred Qualifications

• 3 years of experience with:
  • Azure Data Factory
  • PySpark
  • Apache Airflow
• 2 years of experience with:
  • Power BI
  • SSRS
• Experience with dbt Core and cloud data warehouse development.
• Microsoft Fabric or SnowPro Core certification is a plus.
• Experience performing SQL-based defect triage and SSIS debugging.
• Experience supporting QA teams during mock loads and User Acceptance Testing.

Professional Expectations

• Attend meetings and meet established delivery deadlines.
• Be available during standard business hours.
• Participate in remote meetings with camera on unless otherwise approved.
• Coordinate scheduled leave with project leadership.
• Maintain a professional business or business casual appearance.
• Communicate respectfully with coworkers, customers, and vendors.
• Deliver exceptional customer service.
• Adapt effectively to changing priorities and multiple concurrent assignments.
• Demonstrate initiative in identifying and resolving technical issues.

What We Offer

• Opportunity to work on a highly innovative AI and data modernization initiative.
• Ability to make a significant impact on a large-scale public sector transformation project.
• Collaborative team environment with ownership of key technology initiatives.
• Competitive compensation and comprehensive benefits, including:
  • Medical
  • Dental
  • Vision
  • Life insurance
  • Accident insurance
  • Short-term disability
  • Additional employee benefits

This is a long-term contract opportunity supporting a public pension modernization program in Austin, Texas, with hybrid or remote work available within Texas. Luna Data Solutions, Inc. (LDS) is an Equal Opportunity Employer and considers all qualified applicants without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, genetics, or any other protected status.