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).