Overview
As a Data Architect, you will play a critical role in a finance transformation project, focusing on designing and implementing a modern Azure-based data platform. Collaborating closely with various teams, you will help shift the organization's reporting methods to a more data-driven, self-service analytics approach, thereby facilitating informed decision-making across the business.
Responsibilities
- Design and build the enterprise data lake using Azure Data Lake Gen2 with a Bronze/Silver/Gold layer model.
- Develop robust ETL/ELT pipelines in Azure Data Factory to integrate data from key systems.
- Shape the near-term batch data integration strategy and prepare for a future API-driven environment.
- Define and implement data governance and security frameworks to ensure data quality and controlled access.
- Lead the migration from legacy tools to a Power BI-based reporting ecosystem.
- Optimise platform performance and maintain technical documentation and best practices.
Requirements
- Hands-on experience with Microsoft Azure Data Lake Gen2, Azure Data Factory, and Azure Active Directory.
- Expert-level SQL and data modelling skills.
- Proven ability to build scalable ETL/ELT pipelines and implement data governance and security controls.
- Experience with batch and real-time integrations, ODBC connectors, and REST APIs.
- Exposure to Databricks or Microsoft Fabric is desirable.
- Experience working in complex ERP environments supporting digital or data transformation programmes.