Data Engineer

What will you do? Data Architecture & Data Modelling

• Design and implement scalable data storage solutions using Snowflake architecture

• Support structured and unstructured data across staging, serving, and transformed layers

• Implement data modelling patterns including slowly changing dimensions and surrogate key strategies

• Define and implement data quality checks, validation rules, and data masking using Snowflake DMF functions and data masking rules

ETL / ELT & Data Pipeline Engineering

• Build and maintain end-to-end ETL pipelines within the Snowflake environment

• Set up CI/CD pipelines and deployment automation between AWS CodeCommit and Snowflake, including environment promotion

• Ensure reliable, maintainable, and well-documented data pipelines

Cloud Integration & Security

• Configure and optimize secure integrations between Snowflake and AWS services, including S3

• Ensure data access, storage, and movement comply with security and governance requirements

SQL Performance & Optimization

• Write, optimize, and troubleshoot complex SQL queries

• Tune performance to meet scalability, reliability, and business performance requirements

Delivery & Stakeholder Collaboration

• Work closely with functional leads, developers, partner vendors, and management to gather requirements and provide technical guidance

• Take a proactive and assertive role in chasing dependencies, mitigating risks, and driving projects to on-time completion

Qualifications The ideal candidate should possess

• Strong proficiency in SQL, including complex query development and optimization

• At least 5 years of proven experience in ETL and data pipeline implementation on cloud data warehouse platforms

• Hands-on experience in data modelling and performance tuning

• Strong communication and collaboration skills across technical and non-technical stakeholders

• A results-oriented, proactive, and assertive mindset with a strong drive for delivery

Preferred qualifications:

• SnowPro – Associate certification