Data Engineer

Data Engineer
Based: Offices in High Wycombe with hybrid / remote options
Term: Full time, permanent
Salary: £50000 - £60000 pa + excellent benefits
Focusrite Group are looking for an experienced Data Engineer with strong SQL and analytical skills to join our Business Intelligence team, to help us better understand and support our customers. You'll be part business analyst, part engineer; working with teams across the group to present their data in ways that make it useful, accurate and timely.
We model data in Snowflake using dbt, making use of Power BI for most (but not all) of our presentation. Code is managed in GitHub using a continuous integration model, with all changes going through peer review within the team. We support a network of "power users" across the business, helping them to turn their domain expertise into high quality reporting by ensuring they have the data, training and tools they need.
Primary activities:

• Working with data owners, power users and other stakeholders across the group to understand their data and reporting practices and needs
  
• Defining and implementing data transformation and presentation to deliver on those needs
  
• Identifying opportunities to standardise and re-use models and patterns for a consistent approach
  
• Implementing testing and documentation at each step of the transformation pipeline to ensure quality
  
• Collaborating with the team to design and review new projects, and maintain existing code
  Focusrite Group makes extensive use of a wide variety of data sources to meet various goals, such as operational improvement and regulatory reporting. These include ERP transactions, product registrations, inventory and bill-of-materials information, sustainability metrics, marketing analytics and many more. Ensuring consistent modelling of these sources from our eight brands and multiple regional business units is challenging from a reporting perspective alone, but increasingly overlaps with operational activities as well. For example, we are working towards a Master Data Management (MDM) approach to unify product data, which will require engagement across all brands.
  You'll be:
  
• Comfortable working with business users, both technical and nontechnical, to understand complex data sources and workflows
  
• Experienced in SQL, ideally using dbt to manage your code
  
• Familiar with reporting tools, and more importantly with the ways users engage with them
  
• Aware of typical processes in a consumer products company - CRM, inventory management, customer data management etc.
  
• Creative and curious, with an eye for detail
  About Us
  Focusrite plc is a global music and audio group that develops and markets music technology products. Used by audio professionals and amateur musicians alike, our solutions facilitate the high-quality production of recorded and live sound. Our audio technology brands stand together, seeking to enrich lives through music by removing barriers to creativity - ‘we make music easy to make'.
  The Focusrite Group trades under a number of established and rapidly growing brands: Focusrite, Focusrite Pro, Novation, ADAM Audio, Sequential, Oberheim, Martin Audio, Optimal Audio, Ampify Music, Linea Research, Sonnox, OutBoard and TiMax. With a high-quality reputation and a rich heritage spanning decades, its brands are category leaders in the music-making industry.
  Music technology is an enriching space to work in and we enjoy a Group-wide open-door culture which encourages innovation. This culture, combined with a passion for the inspirational solutions we create, has led to the group winning numerous accolades, including six Queen's Awards, the AIM Company of the Year Award 2021 and regular appearances in 'The Sunday Times 100 Best Small Companies to Work For'.
  The Focusrite Group is dedicated to building a great place to work and as an equal opportunity employer we are committed to Diversity and Inclusion. The group mission is to cultivate an equitable culture, internally and externally, where all people feel they are welcome, safe and positively represented, because at Focusrite they truly are. Equally, we recognise the major impact that climate change is having on our world and work every day towards being industry leaders in a carbon neutral future.
  Benefits include flexible/hybrid working, company pension, life insurance, private healthcare, health cash plan, enhanced Maternity and Paternity pay, employee purchase scheme, group bonus scheme, company music events, offsite company parties and free lunch in the canteen. We arrange company training sessions and encourage personal development