Data Engineer

In your role as Data Engineer you will be required to carry out the following key tasks and responsibilities:

• Data Pipeline Management: Design, build, and optimize scalable ETL pipelines using Fivetran to ensure efficient data ingestion from multiple sources into our data warehouse.
• Reverse ETL: Implement and manage reverse ETL processes using Hightouch to ensure data from our warehouse is synced to various operational systems for improved decision-making across the organization.
• Data Warehousing: Architect and maintain the data warehouse infrastructure on Snowflake, ensuring data is organized, accessible, and performant for downstream use.
• Data Modelling: Leverage dbt (data build tool) to create robust, scalable, and reusable data models that empower analytics and reporting across the company.
• Collaboration with Analytics Teams: Partner with data analysts software developers and business stakeholders to understand data needs, optimize data pipelines, and ensure data models meet business requirements.
• Tableau Integration: Work closely with the data analysts to ensure seamless integration of data models with Tableau, enabling impactful visualizations and reporting.
• Data Quality & Governance: Implement and maintain best practices for data quality, governance, and documentation to ensure high trust in the data and processes.
• Continuous Improvement: Identify opportunities to improve data processes, infrastructure, tooling and overall system performance, driving a culture of continuous improvement within the team.
In addition to the tasks and responsibilities listed, you may be required to perform other duties as assigned by your Manager.


• Experience: Minimum of 5+ years of experience in data engineering, with a proven track record of delivering high-quality data pipelines and infrastructure at scale.
• Technical Expertise: Strong expertise in Fivetran for ETL, Hightouch for reverse ETL, Snowflake as a data warehouse platform, dbt for data modelling, and Tableau for analytics and visualization.
• Programming Skills: Proficient in SQL and at least one programming language (e.g., Python) for data manipulation and automation.
• Data Modelling: Deep understanding of data modelling concepts and best practices for building scalable, maintainable models that meet business needs.
• Collaboration & Communication: Excellent interpersonal and communication skills, with a proven ability to collaborate effectively with cross-functional teams, including data scientists, analysts, and business stakeholders.
• Problem Solving: Strong problem-solving abilities with a knack for breaking down complex data challenges and implementing robust solutions.
• Agile Environment: Experience working in an agile environment with a focus on delivering iterative improvements and rapid innovation.
• Web Scraping: Proficient in web scraping solutions to extract data from external websites and integrate this data into our data pipelines, ensuring data quality and consistency.
  
  Bonhams is a global auction house with an 18th century heritage poised for transformative change. Our global operations are based in London, Paris, New York, Los Angeles and Hong Kong, and we sell in over 60 categories, including motor cars, paintings, jewellery, and entertainment memorabilia.
About the Team Our Data Services team is a tight-knit group of passionate professionals driven by a shared goal: to transform data into actionable insights. Leveraging cutting-edge tools like Snowflake, DBT, and FiveTran, we excel at building robust data pipelines and crafting compelling analytics that empower stakeholders to make informed decisions. The team thrives on collaboration, blending diverse skill sets in data engineering, analytics, and business strategy. We pride ourselves on our agility, adapting quickly to changing business needs and continuously refining our processes. Our motivation stems from a passion for leveraging data to drive innovation and growth.