Data Engineers – Snowflake & Dimensional Modeling
- Location: No Location Set
- Type: Contract
- Job #35222
We are seeking a highly analytical Snowflake Data Engineer / Data Warehouse Engineer with strong SQL, dimensional data modelling, and business analysis capabilities. The ideal candidate will possess deep experience designing and implementing scalable data warehouse solutions, building fact and dimension models, and translating complex business requirements into trusted, reporting-ready datasets.
This role requires a strong foundation in dimensional modelling, star schema design, and data warehousing best practices, combined with the ability to work closely with business stakeholders, analysts, and technical teams. The successful candidate will be comfortable investigating data discrepancies, optimizing SQL performance, and delivering high-quality data solutions that support enterprise reporting, analytics, and decision-making.
Key Skills & Experience
- Snowflake data warehousing experience
- Advanced SQL development and query optimization
- Dimensional modelling and Star Schema design (Kimball methodology)
- Fact and Dimension table design
- Slowly Changing Dimensions (Type 1 and Type 2)
- Data warehousing concepts, architecture, and best practices
- Strong analytical, troubleshooting, and problem-solving skills
- Experience gathering, analyzing, and translating business requirements
- Ability to investigate and reconcile data quality and reporting discrepancies
- Strong communication skills with both technical and business stakeholders
- Ability to work effectively across business, analytics, and engineering teams