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.
