Data Engineer
London, England, United Kingdom
Applications have closed
Bionic Services Ltd
Comparison for business, with human experts. Bionic is the one-stop shop for business essentials - energy, insurance, connectivity & finance. Get a quote now.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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture AWS Azure Data warehouse Data Warehousing DevOps ETL Excel Finance GCP Git SDLC Security Snowflake SQL SSIS Streaming
Perks/benefits: Career development Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open MLOps Engineer jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Data Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Principal Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Principal Data Scientist jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Java-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Kubernetes-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs