Senior Data & Analytics Engineer (Azure Cloud Transition)

Department: Digital & Technology

Positions Available: 2 (Contract - Renewable)

About the Role

We are seeking an experienced Lead Data & Analytics Engineer to drive our full cloud transformation. Our organization is transitioning to a cloud environment on Azure, and we need a hands‑on technical lead to execute this migration while managing hybrid infrastructure and delivering end‑to‑end analytics.

In this role, you will modernize data pipelines using Azure Data Factory and Microsoft Fabric, optimize Azure SQL Managed Instances, and maintain legacy on‑premise solutions (SSIS, SSAS) migrated to cloud VMs. Beyond engineering, you will build robust semantic models in Power BI to deliver business‑ready insights following strict Agile and SDLC governance.

Key Responsibilities

• Cloud Migration & Data Engineering: Build, orchestrate, and optimize production ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric to support our complete cloud migration by September.

• Database & Infrastructure Management: Develop and maintain schemas, performance, and procedures across Azure SQL Managed Instances.

• Legacy System Support: Maintain and support existing SSIS integration packages and SSAS tabular/multidimensional models hosted on Azure VMs during the transition.

• Analytics & Semantic Modeling: Build scalable, high‑performance semantic models, DAX measures, and reports in Power BI for cross‑functional stakeholders.

• SDLC & Delivery Management: Adhere to structured Agile/Scrum methodologies, producing thorough technical documentation, tracking pipeline deployment, and securing formal business sign‑offs.

• Process Automation: Develop targeted Excel VBA/macro automation tools to streamline manual assessment workflows for internal resolution specialists.

Technical Requirements

• 7+ years of progressive experience in Data Engineering, Business Intelligence, or Cloud Architecture.

• Deep hands‑on experience with Microsoft Azure, specifically Azure Data Factory (ADF), Microsoft Fabric, and Azure SQL Managed Instance.

• Proven track record working with legacy Microsoft SQL Server stacks, including SSIS and SSAS (tabular/multidimensional models).

• Advanced Power BI expertise, including enterprise semantic layer design, DAX, and report optimization.

• Proven ability to operate within an Agile/SDLC environment, including writing technical design docs, standard operating procedures, and managing deployment sign‑offs.

• Strong experience in end‑to‑end cloud migrations and infrastructure transition projects.

Desirable / Advantageous Skills

• Advanced Excel & VBA: Strong capability in writing complex VBA scripts and macros to automate operational assessment spreadsheets for resolution specialists.

Candidate Profile

• Full‑Stack Analytics: Able to build the pipeline, model the data layer, and deliver the final Power BI dashboard independently.

• Process‑Driven: Committed to code quality, documentation, testing, and formal sign‑off processes.

experience

5 years

skills

Azure Data Factory and Microsoft Fabric

qualifications

no additional qualifications required

education

Associate Degree/Diploma