AI Data Conversion Specialist

Introduction:

Join our team as an AI Data Conversion Specialist to contribute to a public pension modernization project. This role involves handling large-scale data conversion tasks, ensuring data quality, and utilizing various technologies to support the project''s success.

Responsibilities:

• Perform source-to-target mapping for data conversion processes
• Utilize ETL tools, particularly Microsoft SSIS, for data extraction, transformation, and loading
• Write and optimize Transact-SQL queries for data processing and manipulation
• Automate data conversion tasks using C#/.NET
• Conduct data reconciliation and validation to ensure accuracy
• Support legacy system migration, including mock runs and production cutover
• Collaborate with stakeholders to address data quality issues
• Participate in database administration tasks when necessary
• Utilize cloud computing technologies such as Microsoft Azure for data processing
• Create reports and visualizations using tools like Microsoft Power BI and SSRS

Requirements:

Required Skills:

• 4+ years of experience in large-scale data conversion, ETL processes, and validation
• Proficiency in Microsoft SSIS and BIML/BimlScript
• Strong knowledge of SQL Server, T-SQL, and query optimization techniques
• Experience with C#/.NET for automation of data conversion tasks
• Previous involvement in legacy system migration projects and data reconciliation
• Hands-on experience with public pension administration system data conversions
• Basic understanding of database administration principles

Preferred Skills:

• Familiarity with Azure Data Factory (ADF) and PySpark/Airflow for data processing
• Experience with Power BI/SSRS for reporting purposes
• Knowledge of dbt Core for data transformation processes
• Ability to perform defect triage and root-cause analysis

Key Skills:

SSIS | BIML | SQL Server | T-SQL | C# | .NET | Data Conversion | Data Migration | Public Pension | ETL | ADF | Data Reconciliation