Analytics Engineer Contract

THE COMPANY This global business is rapidly scaling its competitions and digital analytics capability, creating a brand-new vertical for revenue management. With reporting still heavily manual in the UK market, the company is investing in building a modern, scalable data infrastructure - and they're looking for a contractor to help lay the foundations. THE ROLE As a Contract Analytics Engineer, you'll play a pivotal role in setting up the data warehouse and enabling self-serve reporting for the business. Your responsibilities will include: • Supporting the design of the data model in Redshift. • Implementing a Medallion architecture (bronze, silver, gold). • Using DBT to model data, configure tables, and set up tests (including unit testing). • Creating a data mart and star schema for financial and revenue reporting. • Advising on orchestration best practices using Airflow. • Optimising data pipelines for downstream BI tools (Power BI / Looker). This role won't require building from scratch, but you'll need a solid understanding of incremental loads and strong problem-solving ability to structure data efficiently. Success will be measured by the delivery of a functioning data mart and reporting models, not dashboarding. YOUR SKILLS & EXPERIENCE The successful candidate will have: • Strong SQL and DBT experience. • Familiarity with Kimball methodology, dimensional modelling, and star schema design. • Proven experience with Redshift or Snowflake. • Strong background in cloud-based data environments (AWS preferred). • Hands-on experience with Airflow for orchestration. • (Nice-to-have) Python for data engineering tasks. • (Nice-to-have) Optimisation for BI tools such as Power BI or Looker. Soft skills: • Strong collaboration with both technical and business stakeholders. • Proactive and structured approach to delivery. • Ability to work in a lean team with multiple source systems