Analytics Engineer Contract - Harnham - Data & Analytics Recruitment : Job Details

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.

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.

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