Overview
We’re looking for a highly capable and motivated Data Engineer to join a growing data team. This is a pivotal role, leading the migration of a data infrastructure from AWS to Microsoft Azure and shaping the future of their data platform.
This role will play a key role in enabling seamless data integration, transformation, and reporting across diverse sources. This is a strategic, hands on opportunity and perfect for someone who loves innovation, embraces change, and enjoys building robust, future-ready data solutions.
- Lead the migration of data infrastructure from AWS to Azure, defining the roadmap, proposing scalable Azure-native solutions, and collaborating with the Solution Architect and Head of Data.
- Design and build data pipelines into Azure (Data Lake, Synapse, Blob Storage, Azure SQL) to ingest structured, semi-structured, and unstructured data from multiple sources and APIs.
- Develop and optimise ETL/ELT workflows using Azure Data Factory, applying robust transformation logic, validation, and lineage tracking to support analytics and reporting.
- Modernise and manage databases, ensuring performance optimisation, governance standards, and scalable architecture across regions and environments.
- Oversee cloud operations and resilience, including usage optimisation, disaster recovery, and data archiving in line with governance and retention policies.
- Deliver high-quality documentation and collaboration, leading data mapping, model design, and cross-functional workshops to support platform migration and ongoing delivery.
Experience:
- 6–10 years experience with SQL Server (including T-SQL and performance tuning).
- Proven background in ETL/ELT design (ideally using Azure Data Factory).
- Hands on experience with cloud-based data ingestion and transformation (preferably Azure).
- Familiarity with Azure Medallion architecture or similar layered data models.
- Integration experience using APIs, SFTP, and file-based systems.
- Proficient with Power Automate, SharePoint, and Office 365 integrations.
- Basic C# or PowerShell for automation or custom integration tasks.
- Experienced in SQL optimization, troubleshooting, and scalability.
- Cloud certification (Azure Practitioner or similar) is advantageous.
Job Tenure: Permanent
