Description

Owns end-to-end solution design for migrating legacy MS Access, SSIS, and SQL Server stored procedures to Azure Data Factory and Logic Apps, establishing DQ frameworks and audit layers.

This role is remote.

Responsibilities

• Analyse legacy MS Access and SSIS packages to define target Azure Data Factory (ADF) architecture and migration decisions.
• Act as the primary bridge between customer stakeholders and the offshore team, reviewing all deliverables before client sign-off.
• Drive Snowflake discovery and define Bronze/Silver/Gold layer designs with RBAC implementation.
• Ensure scope, quality, and timelines stay on track while serving as the single point of accountability for customer stakeholders.

Required Skills

• 5+ years of experience in data architecture and migration.
• Deep understanding of SSIS to Azure Data Factory migration patterns.
• Experience replacing MS Access with Logic Apps and ADF.
• Proficiency in Snowflake, including data lake layer design (Bronze/Silver/Gold) and RBAC.
• Strong background in SQL Server and SSRS.
• Experience with Azure services and Data Factory.
• Knowledge of dbt for data transformation.
• Familiarity with Power BI for reporting.

Preferred Skills

• Experience establishing DQ frameworks and audit layers in large-scale migrations.

Key Skills

Education

Any Gradute