Data Platform Engineer / Architect (Contractor)

About the role

Devtech is looking for one senior contractor to set up a data warehouse from scratch and take it through to the first working reporting layer, then extend the same platform to support AI. This is a single, broad role rather than a team, and the candidate will make the early architecture decisions that determine whether the AI phase needs a rebuild or just an extension.

Key responsibilities

• Phase one: design and build the data warehouse, including modelling that holds up as new source systems are added
• Build ingestion architecture: pipelines, quality gates and orchestration
• Own data hygiene: cleansing, deduplication, validation rules and reconciliation across sources
• Define the semantic layer: shared metric and entity definitions used by the whole business
• Deliver the first reporting iteration: dashboards, drill-down reporting and operational KPIs in Power BI
• Phase two: prepare data for safe model consumption, with governance and access control
• Enable RAG and agents: embeddings, vector search, document processing and retrieval design
• Define the AI roadmap, from AI-assisted analytics through predictive models to an internal AI assistant

Required profile

• Substantial experience designing and delivering data warehouses end to end across multiple source systems
• Demonstrable data quality and hygiene work, not just moving data
• Comfort working directly with business stakeholders and turning vague requests into a sequenced technical plan

Required skills

• Modern data platforms on AWS (Redshift, Glue, Athena, Lake Formation, S3, QuickSight or equivalent)
• Batch and incremental pipelines, automated quality gates and monitoring
• Semantic layer and dimensional modelling; BI delivery, ideally Power BI
• Data governance basics: lineage, access control, PII handling
• Familiarity with RAG, embeddings and vector databases is a plus
• Migrating workloads from Azure or other clouds to AWS, feature engineering and AI assistant delivery are all listed as pluses