Job Description
We are modernising an enterprise data warehouse into a cloud-native analytics platform on AWS and Snowflake.
We are seeking a Senior / Lead Data Engineer to design and deliver reliable ingestion and ELT pipelines, dimensional data models, and production-grade operational controls.
This is a hands-on role with scope to lead technical direction, mentor engineers, and work closely with architects, QA, and platform teams across build, testing, and go-live phases.
Key Responsibilities
* Design and build scalable data pipelines and warehouse layers in Snowflake (RAW / ODS / DW schemas, tables, views).
* Implement ingestion and orchestration using Snowflake capabilities such as Stages, Storage Integrations, Snowpipe, Tasks, Streams, and Stored Procedures (or agreed equivalent patterns).
* Develop and maintain dimensional data models (facts and dimensions), including transformations, aggregates, and performance optimisation.
* Implement data quality checks, reconciliation processes, and validation controls to ensure data accuracy and consistency.
* Build production-ready operational controls including error handling, rerun/recovery patterns, monitoring support, and clear runbooks/documentation.
* Collaborate with cloud/DevOps, QA, and BI/reporting teams; support SIT, UAT, and deployment activities.
Required Qualifications
* 5+ years of experience in data engineering and enterprise data warehousing delivery.
* Strong SQL expertise, including complex joins, window functions, and performance tuning.
* Hands-on experience with Snowflake, or strong cloud data warehouse experience with the ability to ramp up quickly.
* Solid understanding of dimensional modelling (fact and dimension design).
* Experience with cloud data integration patterns (e.g., S3 or similar object storage).
* Familiarity with production pipeline practices such as logging, retries, and operational support.
* Plus Points (Advantage) Experience migrating Oracle or other legacy data warehouses to cloud platforms.
* Handling of semi-structured data (JSON, XML, VARIANT). CI/CD for data platforms (Git-based workflows, automated deployments).
* Exposure to BI tools (e.g., Tableau) and governed dataset publishing. AI / ML / GenAI-related certifications.
* What We Value Strong ownership mindset and practical problem-solving skills.
* Sound engineering fundamentals and clean, maintainable implementations.
* Ability to work effectively in fast-paced, delivery-driven environments.
* Willingness to learn and adapt —a perfect 100% skill match is not required.
* Senior / Lead Expectations Ownership of a data workstream end-to-end.
* Ability to guide technical design decisions and review peer deliverables.
* Comfortable engaging stakeholders to clarify requirements and deliver iteratively.
#J-18808-Ljbffr