Job Description
The role:
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.
We’re looking for a superstar that can partner with our Head of Data and Analytics to develop, iterate and articulate an excellent data engineering roadmap across Brompton Bicycles, aligned with the priorities of the business. This individual will primarily be hands on, with experience of working with a range of structured and unstructured datasets, and different types of data pertaining to a number of departments across Brompton (Finance, Planning, Commercial). Experience of working with Azure Databricks, B2B/B2C/D2C business models and FiveTran will stand you in good stead. Our team work in 2-week sprints, so experience of delivering projects iteratively in partnership with technical and non-technical stakeholders is paramount. Prior line management experience may come handy in the future, as the business have a great interest in continuing to invest in the Data and Analytics team, evidenced by this brand new role in the team. We look forward to seeing your application!
Key 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
Desired Experience:
- 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.
- Extensive experience building and optimising ETL pipelines using Databricks.
- 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.
You might not tick all the boxes, and that’s okay, we still encourage you to apply. Here at Brompton we are always looking for people that share the same values and attitudes as we do, as we continue to build diverse teams and a sense of community which is made stronger by each new individual who joins.
Sustainability and Health & Safety Responsibility:
- Encourage your team to use socially and environmentally responsible practices.
- Provide effective leadership and be a role model in setting the direction of the Sustainability and H&S culture, engagement, and performance.
- Maintain and review appropriate risk assessments and any Works Manuals or specific instructions required for the prevention of near misses, incidents, injuries, and ill-health, including monitoring Health & Safety performance.
- Provide information, instruction, training, and supervision to ensure our people have the skills and knowledge necessary to achieve the Sustainability and H&S objectives and act in accordance with the Brompton Policies and Procedures.
- Ensure regular Health & Safety inspections, investigations and self-audits are conducted and that all actions raised are followed up and closed within required timescales.
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 and Hybrid 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 mean 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 employee’s 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
- On-Site Canteen – Staff can enjoy subsidised hot meals, snacks and refreshments at our in-house HandleBar Café
- 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), Birthday breakfast, 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. There’s also Head Space, Brompton’s approved wellness program for employees.
- 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.