Senior Azure Data Engineer

About Us
Brompton Bicycle is a leading producer of folding bicycles, renowned for our commitment to quality and innovation. Our mission is to revolutionise urban living and ensure the finest experience for our customers. To aid this, we've assembled a Data & Analytics team and are on the lookout for a skilled Senior Azure Data Engineer to join our ranks.

Job Overview
In this role, you will play a lead role in the conception, planning, and execution of Brompton Bicycle's data infrastructure.

You will be working directly with diverse data sets from multiple systems, orchestrating their seamless integration and optimisation to enable our business to derive valuable insights. This process will encompass everything from the raw development of data pipelines to the management and optimisation of these pipelines using all tools available in the Azure Cloud.

A significant aspect of your role will be the migration of our existing on-premises databases to the Azure Cloud, a complex project requiring a deep understanding of cloud architecture and database management, as well as change management, ensuring the continuation of data as a product to your stakeholders through a smooth data infrastructure transition.

As a vital part of our team, you will collaborate with diverse departments across our organisation (Finance, Planning, Commercial etc.), ensuring that the data solutions you architect is finely attuned to our unique business needs. Your work will directly support the creation of data-driven strategies that will yield pivotal insights, bolstering decision making and strategic planning.

You will have the chance to contribute directly to our mission of revolutionising urban living, by ensuring that our data management and analysis processes are as efficient, reliable, and insightful as possible.

Responsibilities

• Develop, construct, test and maintain data architectures within large-scale data processing systems.
• Migrate existing on-premises databases to the Azure Cloud.
• Develop and manage data pipelines using Azure Data Factory, Delta Lake, and Spark, ensuring all data sets are secure, reliable, and accessible.
• Utilise Azure Cloud architecture knowledge to design and implement scalable data solutions.
• Utilise Spark, SQL, Python, R, and other data frameworks to manipulate data and gain a thorough understanding of the dataset's characteristics. This role requires the ability to comprehend the business logic behind the data's creation, with the aim of enhancing the data modelling process.
• Interact with API systems to query and retrieve data for analysis.
• Work closely with Business Analysts, IT Ops, and other stakeholders to understand data needs and deliver on those needs.
• Ensure understanding and compliance with data governance and data quality principles.
• Design robust data models that enhance data accessibility and facilitate deeper analysis.
• Implement and manage Unity Catalog for centralized data governance and unified access controls across Databricks
• Maintain technical documentation for the entirety of code base.
• End to end ownership of the Data Engineering Lifecycle.
• Implement and manage Fivetran for efficient and reliable ETL processes

Requirements

• Bachelor's degree in computer science, engineering, or equivalent experience.
• Extensive experience as a Senior Data Engineer/Cloud Data Architect, or similar role.
• Deep knowledge of Azure Cloud architecture and Azure Databricks, DevOps and CI/CD
• Extensive experience migrating on-premises data warehouses to the cloud.
• Proficiency with Spark, SQL, Python, R, and other data engineering development tools.
• Experience with metadata driven pipelines and SQL serverless data warehouses.
• Extensive knowledge of querying API systems.
• Excellent problem-solving skills and attention to detail.
• Extensive experience building and optimising ETL pipelines using Databricks.
• Excellent communication and change management skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Understanding of data governance and data quality principles.
• Experience with implementing and managing Unity Catalog for data governance.
• Familiarity with Fivetran ETL tool for seamless data integration.

Desirable Skills

• Master's degree in a relevant field.
• Experience with data visualisation tools such as Power BI, or similar.
• Familiarity with agile methodologies.
• Certifications in Azure or other cloud platforms.