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