Data Engineer (Snowflake)

Insight Global; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Insight Global is seeking a Data Engineer with strong Snowflake expertise to organize and govern critical data assets, including PII and confidential data, while building the governance framework and data structures in Snowflake.

You will reverse engineer current models, document data flows and lineage, and collaborate with business and engineering teams to deliver a Wealth Management use case MVP in early next year.

Qualifications

• 5+ years of experience as a Data Engineer or Data Developer.
• Strong Snowflake experience including data modeling and SQL development.
• Experience with data governance, metadata management, quality and lineage.
• Ability to document current/future state architectures clearly.
• Familiarity with interacting with business stakeholders to translate requirements.

Responsibilities

• Assess existing data models and datasets to define current-state architecture.
• Document data assets, data flows, lineage, and governance in Snowflake.
• Partner with stakeholders to implement a scalable data governance model.
• Classify and organize sensitive data per enterprise standards.
• Support buildout and monitoring of governed data assets and products.
• Collaborate with governance, business, and engineering teams on Wealth Management use cases.
• Contribute to MVP delivery targeted for January/February.
• Support ongoing governance post-implementation.

Skills

Snowflake modeling

Data governance

Metadata management

Data lineage

SQL development

Stakeholder communication

Tools

Snowflake

Manta

Job description

Job Description

We are seeking a Data Engineer with strong Snowflake expertise and a solid understanding of Data Governance to support a major Wealth/Asset Management data initiative. This role will focus on organizing and governing critical data assets, including PII and confidential data, while helping build the governance framework, data lineage, and enterprise data structure within Snowflake.

Key Responsibilities

• Assess and reverse engineer existing data models and datasets to establish a current-state data architecture.
• Document data assets, data flows, lineage, and governance processes within Snowflake.
• Partner with business and technical stakeholders to define and implement a scalable data governance model.
• Classify and organize sensitive data, including PII and confidential information, according to enterprise standards.
• Support the buildout and monitoring of governed data assets and data products.
• Work closely with Data Governance, Business, and Engineering teams to adapt existing governance frameworks for Wealth Management use cases.
• Contribute to the delivery of a key MVP targeted for January/February.
• Support ongoing monitoring and maintenance efforts post-implementation.

Skills and Requirements

• 5+ years of experience as a Data Engineer or Data Developer.
• Strong hands‑on Snowflake experience, including data modeling, data architecture, and SQL development.
• Experience with data governance, metadata management, data quality, and data lineage.
• Experience documenting current‑state and future‑state data architectures.
• Proficiency with SQL and modern data management tools.
• Ability to interact directly with business stakeholders and translate requirements into technical solutions.
• Experience with Manta or other data lineage/metadata management tools.
• Background in Wealth Management, Asset Management, or Financial Services.
• Experience governing enterprise-wide data assets containing sensitive customer information.
• Exposure to AI, analytics, research, or competitive intelligence data initiatives.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].