Outsourced
About The Role Outsourced is seeking an experienced Data Engineer to design, build, and maintain a scalable, well-structured data warehouse. You will own the end-to-end engineering of our data platform — from ingesting raw source data through to clean, business-ready layers — and manage the infrastructure that underpins it all. This is a hands-on engineering role for someone who takes pride in building things properly. Key Responsibilities Maintain an existing a multi-layer data warehouse (Raw, Conformed, and Business layers) following modern data engineering best practices Develop and maintain robust ELT/ETL pipelines to ingest and transform data from multiple source systems Manage and evolve the data warehouse infrastructure using Terraform, with all configuration version-controlled in GitHub Collaborate with Data Analysts and business stakeholders to understand data requirements and deliver fit-for-purpose data products Enforce data quality standards, testing in appropriate sandbox environments, and monitoring across all warehouse layers Documenting of new data architecture, pipeline logic, and infrastructure decisions to support team knowledge and auditability Contribute to CI/CD practices for infrastructure and pipeline deployments via GitHub Actions or equivalent Proactively identify and resolve performance bottlenecks, data freshness issues, and pipeline failures Required Skills \& Experience Data Warehouse Architecture Strong Experience building a structured data warehouse with clearly defined layers: Raw layer — landing data in its original form, preserving source fidelity Conformed layer — cleansed, standardised, and integrated data across source systems using consistent keys and formats Business layer — aggregated, business-rule-applied data structured for analytics and reporting consumption Proficiency in dimensional modelling concepts: star schema, fact and dimension tables, slowly changing dimensions (SCDs) SQL \& Data Transformation Advanced SQL skills for data transformation, cleansing, and modelling Experience with dbt (data build tool) or equivalent transformation frameworks for layered modelling Strong understanding of ELT patterns and how transformations are applied at each warehouse layer Infrastructure as Code — Terraform Hands-on experience writing and managing Terraform to provision and maintain data infrastructure Ability to structure Terraform codebases cleanly using modules, variables, and environments (dev/staging/prod) Experience managing Terraform state, remote backends, and handling infrastructure changes safely Familiarity with Terraform plan/apply workflows integrated into a pull request review process GitHub \& Version Control Proficient with Git and GitHub for source control of both infrastructure (Terraform) and transformation code Experience working with branch strategies, pull requests, and code review workflows in a team environment Exposure to GitHub Actions or similar CI/CD pipelines for automated testing and deployment of infrastructure and data pipelines Desirable Skills Experience with Snowflake as the cloud data warehouse platform (compute/storage separation, virtual warehouses, RBAC, cost management) Familiarity with Snowflake-specific features: Time Travel, Streams, Tasks, Dynamic Tables, and the Snowflake Terraform provider Exposure to a modern data stack including tools like Fivetran, or similar ingestion platforms Understanding of data governance concepts: lineage, cataloguing, and access control Experience working in Azure, AWS, or GCP cloud environments
Outsourced
