Senior Data Engineer

Senior Data Engineer – HIRING ASAP

Start date: ASAP
Duration: 6 weeks initially
Location: 1-2 days per week in Bristol office, 3-4 days remote per week
Rate: £450 - £550 per day outside IR35
 
Skills:

• Snowflake engineering (hands-on)
  • Advanced SQL and performance troubleshooting (query profiling, workload behaviour)
  • Warehouse utilisation analysis (top warehouses/queries, heavy tasks, large tables)
  • Practical cost optimisation tactics and “cost heatmap” creation
• Ingestion and orchestration deep expertise
  • End-to-end ingestion reviews from core source systems (2–3 systems typical)
  • Orchestration tooling/jobs analysis (dependencies, scheduling, retries, idempotency)
  • ETL vs ELT patterns; reload vs incremental logic; backfill and replay strategies.
• Transformation chain analysis
  • Ability to trace staging → transforms → curated/core layers.
  • Identifying brittle/hard-coded business rules and refactoring opportunities
• Data modelling in core domains
  • Strong modelling capability for Client, Accounts/Holdings, Transactions (or equivalent)
  • Historisation, auditability, lineage awareness, and error handling in core models
• Metric traceability and reconciliation
  • Tracing metrics from Precisely definitions → Snowflake implementations → reports/consumers
  • Identifying mismatches in logic, filters, grain, naming; spotting duplication/missing metrics
• Data distribution & activation flows
  • Mapping and validating data movement to/from channels and tools (Braze, Amplitude, Segment)
  • Understanding of journey/event data patterns and downstream consumption constraints
• Client/household/relationship model discovery
  • Reviewing Client Hub / identity models and party-account linking
  • Identifying modelling gaps for parent–child linking and future relationship requirements
• Data quality & governance collaboration
  • Working with governance/DQ teams to assess controls, checks, and accountability.
  • Translating DQ issues into engineering backlog items and operational monitoring needs
• Evidence-driven remediation planning
  • Producing domain assessment notes, diagrams, traceability tables, and cost/perf findings
  • Estimating effort (S/M/L), dependencies, and technical risk for backlog prioritisation
• Communication and stakeholder working
  • Comfortable interviewing SMEs and translating input into clear technical artefacts.
  • Able to present findings to architecture, engineering, BI/MI reporting teams, and governance stakeholders.