Senior Developer, Data Engineering

ROLE: Senior Developer, Data EngineeringREPORTS TO: Manager, Digital Analytics LOCATION:Hybrid / Corporate Office in Richmond Hill, OntarioSALARY: $120k-$130k, up to 10% discretionary incentive target* THE OPPORTUNITY

We are seeking a highly skilled and experienced Senior Developer to join our Data Engineering team. The ideal candidate will have a strong background in data engineering, with a focus on building and maintaining scalable data pipelines, optimizing data storage, and ensuring data quality. You will work closely with data scientists, analysts, and other stakeholders to support data-driven decision-making across the organization.

Venterra is currently pursuing a data stack modernization effort to migrate our SQL Server reporting database to a cloud-native ELT stack built on AWS, Python, Airflow, DBT and Snowflake.

KEY JOB RESPONSIBILITIES

• Design, develop, and maintain scalable data pipelines and ETL processes to support data integration and analytics.
• Optimize and manage data storage solutions, ensuring data is stored efficiently and securely.
• Implement data quality checks and monitoring to ensure the accuracy and reliability of data.
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions that meet their needs.
• Develop and maintain documentation for data engineering processes and systems.
• Stay up to date with the latest industry trends and technologies in data engineering and recommend improvements to existing systems.
• Mentor and provide guidance to members of the data engineering, business intelligence and data science teams

CANDIDATE PROFILE

• Bachelor’s or master’s degree in computer science, Engineering, a related field or equivalent experience
• 7+ years of experience in data engineering or a related field.
• Strong expertise in SQL and experience with relational databases, preferably Snowflake and/or Microsoft SQL Server with an emphasis on analytical and ETL use cases.
• Strong experience building cloud-native solutions using AWS Lambda, ECS and EMR and deploying these services using infrastructure as code tools. Preference given to candidates with experience with Terraform
• Strong programming skills in Python or another programming language commonly used in data engineering.
• Experience with data pipeline and workflow management tools, preferably Apache Airflow or other dependency graph-based orchestration tools
• Familiarity with cloud-based data storage and processing solutions, preferably AWS
• Knowledge of dimensional modelling techniques and data warehouse schema design
• Experience working with Git, CI/CD pipelines for database schema evolution and environment management