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. Data Engineer – Responsibilities - Design and develop Star Schema and Snowflake Schema data models to support analytical reporting. - Create and maintain Fact and Dimension Tables in Azure Synapse Analytics. - Build ETL/ELT data pipelines using Azure Data Factory (ADF), Azure Synapse Pipelines, and Databricks. - Integrate data from Azure SQL Database into Azure Synapse, ensuring data accuracy, consistency, and performance. - Collaborate with BI and reporting teams to ensure the data model supports ThoughtSpot BI use cases. - Implement partitioning, indexing, and data optimisation strategies for large datasets. - Apply dimensional modelling best practices to enable effective slicing, dicing, and drill-down reporting in ThoughtSpot. - Ensure data governance, security, and compliance (including RBAC, data masking, and encryption) across the solution. - Implement monitoring and logging using tools such as Azure Monitor and Log Analytics to track pipeline health and performance. - Work with internal stakeholders to refine data requirements and ensure data models meet business needs. Data Engineer – Required Skills - Proven experience in Azure Synapse Analytics including data warehousing and pipeline development. - Strong experience with Azure SQL Database, Azure Data Lake, and Azure Data Factory (ADF). - Expertise in dimensional modelling (Star & Snowflake Schemas), including creation of Fact and Dimension tables. - Hands-on experience building data pipelines (both batch processing and streaming data) in Azure. - Proficiency in SQL (T-SQL) and Python for data transformation and pipeline development. - Experience working with ThoughtSpot (preferred) or similar BI tools with direct integration into Synapse Analytics. - Knowledge of OLTP vs OLAP data structures and optimisation strategies. - Familiarity with CI/CD processes for data pipelines and version control using Git. - Understanding of data governance, security best practices, and performance tuning in an Azure environment. - Strong analytical mindset with excellent communication and documentation skills. - 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.