Data Engineer

We are Bionic, the UK’s number one business comparison and switching service. It’s our mission to make it radically easier to run a small business and earn the lifetime loyalty of British businesses.

To do this, we combine world-class human service with smart technology and data. This means our tech-enabled experts can quickly match business owners with the best deals on their business essentials – energy, connectivity, insurance, and finance.

We also partner with leading price comparison websites, including Compare the Market, MoneySuperMarket, Uswitch for Business, and Confused.com, who trust us to provide their business energy switching services.

Bionic recently realised significant investment from OMERS (PE investment company) and are now investing heavily in tech and data products and innovation.

As such we are rapidly scaling and are now looking for a Data Engineer to join our Data and Insights team within our wider Tech team.

At Bionic data is core to our business and strategy and this role is part of a team that is critical to delivering on this goal. We define this as ensuring all company users can use data and analysis to make strategic as well as day to day decisions to benefit our customers. To do this, in brief, this role will help lead the transformation of our data and insights function towards real time streaming and hyper-personalisation in our customer interactions.

As part of this transformation, you will help define and enhance our data capabilities as we continue our migration and development of the Data Warehouse in AWS from SQL Server. You will also help manage and develop our data warehouse, ensuring it remains performant, accurate and fit for purpose. You will work closely with the Data & Insights team to refine, improve and build out the database and support the development of performant SQL scripts.

Having a deep understanding of data and how to effectively use it, the Data Engineer will lead a passionate quest of business transformation by optimising our data infrastructure, data model, and the new analytical data warehouse / data store.

The role will be a hands-on role including database design/modelling, database creation, performance optimization and data loads / ETL processing and SSIS packages.

Using the expertise gained from tried and tested experience, you will work closely with key stakeholders to earn trust and deliver a service that will support our high growth plans and helping to realise additional growth potential.

• Support the team in the performance, integrity, design, management and security of our data warehouse.
• Along with the team support ongoing development of the data warehouse, including enhancing our current data sets with additional data sources.
• Support for all ETL processes, from landing through to populating our data warehouse, ensuring the integrity of our data is maintained throughout and that the ETL processes are stable, accurate and performant.
• Ensuring the data warehouse continues to be fit for purpose and meeting our business needs.
• Monitoring database performance and implementing optimisation techniques.
• Ensuring we are continuing to be innovative, utilising the latest technologies and challenging our ways of working to deliver the best data and reporting possible.
• Supporting the BI team with regards to SQL expertise, best practises in reporting and data warehouse design
• Working with the IT Operations Manager, Development Manager and Head of BI in building out a robust and scalable data warehouse platform

This is an amazing opportunity for a strong Data Engineer to really shine in a fast-paced collaborative environment with plenty of opportunity to take on real responsibility and excel your career in the direction you want. If you are a strong dev looking to take on some real responsibility and gain experience in architecture this is the perfect role for you.

Requirements

Desired Skills:

• Strong hands-on experience of enterprise level data solutions projects using the Microsoft BI stack.
• 3+ years’ experience with Microsoft SQL query design & optimisation
• Experience with data warehouse design, data pipeline development and maintenance and data integration
• Experience with on-premises SQL Server solutions and associated BI tool; SSIS.
• Experience with source control tools, e.g. Git, Azure DevOps, TFS
• Experience with working with SDLC e.g. Agile Methodology
• Knowledge of core ETL architectural principles such as modularity, restartability, and table-driven business rules.
• Understanding of information delivery architecture including the creation of abstraction layers, SQL query paths and optimization, report level calculations and end user reporting architecture
• Excellent communication and stakeholder engagement skills

You might also have:

• Experience in database design and data modelling for the purpose of data warehousing & reporting
• Experience with cloud technologies, Azure/AWS/GCP/Snowflake.
• Strong BI knowledge
• Experience with Cozyroc SSIS toolset