Senior Azure Data Engineer ABOUT US: Brompton Bicycle is not just a brand; it's a symbol of innovative urban mobility. Founded in London in 1975, we have become a bit of a global icon, with our easily recognisable design and unwavering commitment to making city cycling smarter and more accessible. At the heart of our success is our ingenious foldable bike – a testament to British engineering excellence. Compact, portable bicycles have revolutionised urban transportation, offering a practical, eco-friendly solution for navigating bustling cityscapes. Our dedication to sustainability, quality craftsmanship, and stylish design has earned us a loyal following of cycling enthusiasts and commuters worldwide. We are on a mission to create greener, more efficient cities and are dedicated to our motto – Create Urban Freedom for Happier Lives. If you're ready to pedal your career in a new direction and be a part of something truly special, read on to learn more about this exciting opportunity! JOB OVERVIEW: As the Data and Analytics complete the transition away from on premises to solely on cloud (Azure Databricks), I am looking for Senior Azure Data Engineer to spearhead how Brompton approaches data engineering, bringing stakeholders across the business along the journey. Therefore, this individual will possess a unique mix of deep technical expertise and outstanding stakeholder management, with an ability to explain the technical to the non-technical and to map complex business process onto detailed technical specifications / data requirements. This individual will also work very closely with the Head of Data and Analytics, looking strategically across their team of master data specialists, analytics/BI engineers, reporting developers and data scientists, to ensure business requirements are efficiently turned into end-to-end solutions determine where we would add the most value in a highly engaged organisation. 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. Your work will directly impact the creation and delivery 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. · 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. BENEFITS AT BROMPTON: Brompton offers you an excellent working environment with enthusiastic colleagues who get along, communicate and co-operate well with each other. The working climate is informal, but we work hard. Next to good terms of employment, Brompton offers you the opportunity to work in a responsible and challenging job within a dynamic, international and ambitious environment. We are all proud to be part of Brompton Bicycle Ltd; we all share the same passion and dedication to the company and the product, despite any differences in cultural backgrounds and skills. · Flexible working · 9 Day Fortnight – This is a flexible working pattern which individuals can opt in for where an employee works their contractual hours across 9 days instead of 10 days. (i.e. 80 hours across 9 days instead of 10 days). This means the individual would work an additional hour across Monday to Thursday (across the 2-week period) to gain their Friday off. · Annual Leave – 25 days annual leave, plus all UK bank holidays. · Competitive Salary – Plus workplace pension scheme and profit share bonus. · Brompton Discount - Get ready to bike in style, as all employees receive up to 60% off their very own bike and accessories, plus there are discounts for your friends and family too. · Staff Loan Bike – All employees are eligible to receive a Brompton Bicycle which they can use free of charge for up to 3 months · Onboarding Induction – New starters will enrol on a 3-month onboarding induction programme with a welcome pack goody bag as well as a factory tour, meet & greet with the Chiefs and an afternoon bike ride. There are also opportunities for work experience in the Covent Garden shop floor. · Free Breakfast – Unlimited, all-day access to an array of fruit and cereal · Breakout Areas – Unwind on the mezzanine floor which contains a ping-pong, foosball and pool table and other games like darts and a giant Connect-4! · Social Activities - Throughout the year enjoy time with your colleagues as we host an annual Summer and Christmas party, annual bike rides (both inside and outside the UK), volunteering activities and family fun days just to name a few. · Learning and Development - Access to free LinkedIn Learning and opportunity to devote some of your time at work to personal development. We value professional development and actively promote internal promotions and opportunities. · Benefits - Workplace Pension Scheme, Care and Health Support, Flexible Working, Cycle to Work Scheme and other benefits. · Mental Health – We provide access to a confidential EAP that offers counselling, resources and support for various mental health challenges. · Paid Leave – We offer an enhanced Family, Paternity and Maternity leave pay. Brompton was listed amongst the best UK workplaces in 2020 and was awarded silver investors in People Accreditation and London Living Wage Employer in 2021. DIVERSITY, EQUALITY AND INCLUSION COMMITMENT Regardless of age, disability, race, gender, religion, sexual orientation, culture, educational background, parental status, neurodiversity or disability - whoever you are, if you’re passionate about your work, curious, relentless and customer-obsessed, we want to hear from you.