DescriptionROLE: Senior Developer, Data EngineeringREPORTS TO: Manager, Digital Analytics LOCATION: Hybrid / Corporate Office in Richmond Hill, Ontario SALARY: $120k-$130k, up to 10% discretionary incentive target* THE OPPORTUNITYWe 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
- Experience with big data technologies (e.g., Hadoop, Spark) is a plus.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
Preferred Qualifications: - Experience with data modeling and schema design.
- Knowledge of data governance and data security best practices.
- Experience with containerization and orchestration tools (e.g., Docker, Kubernetes).
- Familiarity with machine learning and data science concepts.
*The base salary range is intended to reflect the role's base salary rate in locations throughout Canada. Salary ranges are determined through interviews and a review of education, experience, knowledge, skills, abilities of the applicant, equity with other team members, alignment with market data, and geographic location. The base salary range does not include any bonuses or benefits.
Work Authorization Requirement: Applicants must be legally authorized to work in Canada at the time of application and throughout employment. The company does not provide visa sponsorship for this role.
