Data Engineer - Snowflake, dbtCore/Cloud, AWS
Aviva Investors8 days ago
Markham, CanadaSenior
Responsibilities
- Design and implement scalable, maintainable data pipelines using dbt Core/Cloud.
- Write and maintain reusable code in SQL, Python, Shell, and Terraform.
- Champion data quality, governance, cataloging, and data-solution testing practices.
- Perform root-cause analysis and resolve complex data issues.
- Lead delivery activities and agile ceremonies for data initiatives.
- Mentor Data Engineers and project team members.
- Collaborate with architects, designers, QA engineers, and delivery teams on data products.
- Create and maintain comprehensive technical documentation.
- Use orchestration and visualization tools to support enterprise data solutions.
Requirements
- 6+ years of professional experience delivering more than five high-impact data projects from inception through warranty.
- At least 3 years of experience with Snowflake, dbt Core/Cloud, and AWS cloud technologies.
- At least 3 years of coding experience in multiple programming languages, such as Python and Java.
- Expert-level SQL, Python, Shell, and Terraform skills focused on performance, reusability, and maintainability.
- Deep knowledge of Snowflake, PostgreSQL, Amazon Aurora, Hadoop, and MongoDB.
- Experience with Snowsight, Streamlit, Qlik, and SAP BusinessObjects.
- Hands-on experience with Zena and AWS Managed Airflow.
- Strong technical and business presentation, communication, collaboration, and stakeholder-influence skills.
- Ability to work effectively in fast-paced, ambiguous, and high-pressure environments.
- Insurance industry knowledge is an asset.
- Experience operationalizing AI/ML and GenAI models is a plus.
- SnowPRO Core, SnowPro Advanced Data Engineer, SnowPro Advanced Architect, dbt Developer, or AWS Cloud Practitioner certification is an asset.
Benefits
- Salary range of $100,000 to $125,000, plus eligibility for an annual bonus, retirement savings, share plan, and health benefits.
- Personal wellness support, volunteer opportunities, and corporate wellness programs.
- Professional development and education support.
- Competitive vacation package with the option to purchase five additional days off per year.
- Employee programs focused on gender, LGBTQ+, origins, diversity, and inclusion.
- Hybrid flexible work model.
Categories
Data Engineering
About Aviva Investors
Aviva Investors is the global asset management business of Aviva plc, headquartered in London and founded in 2008. It manages fixed income, equity, real assets, multi-asset, and alternative strategies, including ESG-oriented mandates, for institutional, wholesale, and retirement clients worldwide. Its business model centers on management and performance fees from pooled funds and segregated mandates across global markets.