Get AI-powered advice on this job and more exclusive features.This range is provided by Harnham. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Base pay rangeDirect message the job poster from HarnhamBuilding Business Intelligence & Analytics Engineering Teams Across the UK | The Talent Driving The Data and AI RevolutionSenior Data Consultant (Analytics Engineering)Company OverviewThey are a rapidly growing data and analytics platform focused on helping businesses centralise and streamline their data. Their ETL-driven platform integrates machine learning and data science tools to support data-driven decision-making. Serving clients across various industries, including B2B SaaS, retail, and charity, they specialise in building scalable data infrastructures and delivering actionable insights.With a strong emphasis on financial data, their team is dedicated to enabling clients to make more informed decisions by creating a single source of truth and optimising their data processes. They're expanding quickly and offer exciting opportunities for individuals passionate about data engineering, analytics, and cloud technologies.Role OverviewWe are seeking a Senior Data Consultant to help companies centralize their data using an ETL-driven decision intelligence platform with integrated machine learning and data science capabilities. This role will be instrumental in developing scalable data infrastructure and enabling clients to make data-driven decisions.Key ResponsibilitiesBuild a single source of truth for clients by structuring and modeling data.Develop scalable data pipelines integrating financial, customer, CRM, ERP, and marketing data.Deliver end-to-end data modelling projects, connecting multiple sources and creating metrics/KPIs.Work primarily with SQL, dbt, and cloud data warehouses (Snowflake, BigQuery, Redshift).Technical RequirementsStrong proficiency in SQL with the ability to write complex queries, optimise performance, and manipulate large datasets efficiently. This includes expertise in database management, data extraction, transformation, and analysis, ensuring seamless data workflows for all stakeholders.Working with modern cloud data warehouses such as Snowflake, BigQuery, or Redshift. You should be comfortable creating robust data models, building scalable pipelines, and ensuring data quality within these cloud environments.Experience with dbt (Data Build Tool), particularly in managing and automating data transformation.Solid understanding of Python, especially in the context of automating data processes, integrating APIs, and implementing machine learning models to enhance data analysis capabilities. Experience with Python libraries like Pandas or NumPy is a plus.Practical experience working with key financial metrics, including revenue, retention, churn, and customer lifetime value, along with a deep understanding of how to extract actionable insights from these data sets to drive business decisions.Demonstrated ability to integrate diverse data sources seamlessly, ensuring smooth data flow across systems, and combining financial, operational, and customer data to create a unified view for accurate reporting and analysis.Seniority levelMid-Senior levelEmployment typeFull-timeJob functionAnalyst and EngineeringIndustriesIT Services and IT Consulting and Data Infrastructure and Analytics #J-18808-Ljbffr