Role:Senior Data Engineer
Contract Length:Initial 2 months, with potential for extension
Day Rate:Circa £400/day
Location:Fully remote
Engagement:Outside IR35
Client:US-based Consultancy
Note:Candidates must be available to work with US-based teams (Eastern Time) for some crossover hours (UK is +5 hrs).
Project Overview
A US-based consultancy is seeking a seasoned Senior Data Engineer to support a short-term engagement aimed at optimising a client’s data infrastructure. The objective is to consolidate existing manual reports into a unified, automated reporting platform using Power BI, underpinned by modern cloud data technologies.
This is a hands-on role focused on the architecture and implementation of the data platform, reporting workflows, and automation of data refreshes.
Essential Skills & Experience
You should have demonstrable experience in the following:
- Microsoft Azure (Cloud Infrastructure):Hosting and deploying data infrastructure.
- GitHub:Used for repository hosting and CI/CD pipelines.
- Snowflake (Data Warehouse):Designing, building and maintaining scalable, cost-effective data warehouse solutions.
- OpenTofu:(Fork of Terraform) Used for managing Snowflake infrastructure as code.
- DBT (Data Build Tool):For transforming and modelling data within Snowflake to create clean, reportable datasets.
- Power BI:For building dynamic, automated reports.
Desirable (Nice-to-Have) Experience
Experience integrating the following platforms into Snowflake via Azure Function Apps or Zapier is beneficial:
- Sera CRM:Data ingestion from event triggers (e.g. appointment, invoice, quote, membership events).
- Five9 (Contact Centre):API-based report ingestion (inbound/outbound call data).
- QuickBooks Online:Scheduled extraction of financial data for reporting purposes (e.g. Sales by Class Summary).
