Factory jobs in United Kingdom

Job Description

Data Engineer - 3 Month Contract – Day Rate £600 All Inc – Outside IR35

Over the past ten years, Talos360 has firmly established itself as a market leader in talent software solutions and online recruitment media with our innovations in the HR software space, Talos ATS & Talos Engage solving todays talent challenges. 2024 has been an incredible year for our team as our business was recognised as the number 1 ‘Great Place to Work’ overall mid-sized company in the UK, and the number 1 ‘Great Place to Work’ Mid-tech company in Europe!

Talos360 is a company like no other, and we are extremely proud to be recognised in this way. We support over 800 companies UK wide and are growing quickly. We are a SaaS technology business, with massive growth plans and investment.

We are seeking a skilled Data Engineer to join our team on a 3-month contract to design and build a data warehouse solution in Azure Synapse Analytics. The successful candidate will work closely with internal product, technical, and reporting teams to create a dimensional data model (Star and Snowflake schema) that integrates with Azure SQL Database and serves as the foundation for ThoughtSpot BI reporting. The role will focus on developing efficient ETL/ELT pipelines, ensuring data quality, and optimising performance to support advanced analytics and self-service BI capabilities in ThoughtSpot. We are based in Warrington, but this is a remote role and any UK base will be considered.

1. Design and develop Star Schema and Snowflake Schema data models to support analytical reporting.
2. Create and maintain Fact and Dimension Tables in Azure Synapse Analytics.
3. Build ETL/ELT data pipelines using Azure Data Factory (ADF), Azure Synapse Pipelines, and Databricks.
4. Integrate data from Azure SQL Database into Azure Synapse, ensuring data accuracy, consistency, and performance.
5. Collaborate with BI and reporting teams to ensure the data model supports ThoughtSpot BI use cases.
6. Implement partitioning, indexing, and data optimisation strategies for large datasets.
7. Apply dimensional modelling best practices to enable effective slicing, dicing, and drill-down reporting in ThoughtSpot.
8. Ensure data governance, security, and compliance (including RBAC, data masking, and encryption) across the solution.
9. Implement monitoring and logging using tools such as Azure Monitor and Log Analytics to track pipeline health and performance.
10. Work with internal stakeholders to refine data requirements and ensure data models meet business needs.

1. Proven experience in Azure Synapse Analytics including data warehousing and pipeline development.
2. Strong experience with Azure SQL Database, Azure Data Lake, and Azure Data Factory (ADF).
3. Expertise in dimensional modelling (Star & Snowflake Schemas), including creation of Fact and Dimension tables.
4. Hands-on experience building data pipelines (both batch processing and streaming data) in Azure.
5. Proficiency in SQL (T-SQL) and Python for data transformation and pipeline development.
6. Experience working with ThoughtSpot or similar BI tools with direct integration into Synapse Analytics.
7. Knowledge of OLTP vs OLAP data structures and optimisation strategies.
8. Familiarity with CI/CD processes for data pipelines and version control using Git.
9. Understanding of data governance, security best practices, and performance tuning in an Azure environment.
10. Strong analytical mindset with excellent communication and documentation skills.
11. Any previous work in HR Tech or Recruitment platforms is a plus, although not essential.

If you are an experienced Data Engineer Contractor, who can add immediate value with your skillset, then this could be a great next project for you.

Apply now to be considered for our Data Engineer role. You could be working for Talos360 in an exciting growth phase, within the month.