Based in Montreal, PineStone Asset Management Inc. is a specialist global equity manager founded in 2021. PineStone is focused exclusively on helping clients achieve their financial goals by investing in what we believe to be the highest-quality companies worldwide. PineStone currently has approximately C$75 billion in assets under management and is led by Nadim Rizk, a seasoned portfolio manager with over 25 years of experience.
- Our mission: To create extraordinary value for our clients and their beneficiaries over many years.
- Our vision: To be the gold standard for fundamental research, portfolio construction and long-term quality growth investing.
- Our values: We foster a culture of commitment, integrity, drive, diligence, and patience
About the Role
We are looking for a strong Data Engineer to help build the core data infrastructure of a growing investment management firm.
This role is focused on the core data infrastructure of PineStone’s data platform: reliable ingestion, transformation, orchestration, data modeling, quality controls, observability, and trusted datasets that downstream teams and tools can depend on.
The ideal candidate can understand business context, ask precise questions, design durable data models, implement complex transformation logic, and communicate clearly with both technical and non-technical stakeholders.
This is a hands-on role based in Montreal and is primarily in-office.
Job Description
You will help design, build, and operate the production data layer PineStone uses for investment analytics, reporting, operations, and decision-making.
The core of the role is to make data pipelines, transformations, quality checks, data models, and core datasets reliable, well-designed, well-documented, and easy for analysts to use. You will work hands-on with Snowflake, dbt, Matillion, APIs, Azure Functions, SFTP feeds, and related tools to improve how data is ingested, transformed, validated, monitored, and made available across the firm.
This role offers broad exposure to the full data lifecycle, from ingestion and orchestration to modeling, testing, observability, documentation, and downstream consumption.
It is well-suited to someone who wants to deepen their engineering judgment, build durable systems, and play a central role in how PineStone’s data platform supports analytics, reporting, automation, applications, and AI-enabled workflows.
The emphasis is on the infrastructure and engineering discipline behind these use cases: reliable pipelines, thoughtful data modeling, strong quality controls, clear lineage, and systems that can scale as the firm grows.
What You’ll Do
Build trusted data infrastructure:
- Design, build, and maintain production data pipelines, models, and datasets in Snowflake, dbt, and Matillion.
- Manage ingestion patterns across SFTP feeds, APIs, scheduled jobs, Azure Functions, and other integration points.
- Design pipeline schedules, dependencies, retries, alerts, and monitoring so critical data processes run reliably.
- Create core data models with clear data grain, primary keys, data types, schema conventions, lineage, ownership, data tests, versioning logic, and access controls.
- Consolidate fragmented workflows, duplicated logic, manual processes, and disconnected datasets into governed, reusable data assets.
Build rigorous dbt models and transformation logic:
- Build, optimize, test, and document dbt models, macros, dependencies, incremental models, snapshots, and exposures.
- Translate business and operational requirements into clear, tested, and maintainable transformation logic.
- Improve model structure, lineage, performance, testing coverage, documentation, and maintainability.
- Help standardize core business and investment definitions at the data model level so downstream dashboards, reports, applications, automations, and AI-enabled workflows consume reliable governed data.
Support structured and unstructured data ingestion:
- Build ingestion and transformation pipelines for structured and unstructured data sources.
- Design metadata, schema, storage, validation, and access-control patterns that make data easier to govern, search, retrieve, and reuse for downstream analytics, automation, and AI-enabled workflows.
Strengthen data quality through systems-level design:
- Implement robust data versioning patterns, including slowly changing dimensions, point-in-time logic, effective dating, historical restatements, and audit trails.
- Build automated tests, validation checks, reconciliations, alerts, and monitoring around critical data processes.
- Trace lineage and dependencies to identify root causes of data issues and implement durable fixes rather than temporary patches.
- Replace fragile, undocumented, or siloed workflows with governed, maintainable data pipelines and models.
Work closely with the business:
- Partner with investment, operations, performance, client reporting, compliance, and business teams to understand requirements and translate them into durable data solutions.
- Communicate complex technical ideas in simple, practical terms and build trust through quality, judgment, follow-through, and ownership.
- Operate with autonomy while knowing when to escalate, clarify, or challenge assumptions.
You Might Thrive in This Role If You Have:
- Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science, Mathematics, Finance, Business Analytics, or a related field.
- 3+ years of relevant experience and demonstrated ownership of production data pipelines, data models, or data platform infrastructure.
- Are highly proficient in SQL and understand modern data warehouse concepts.
- Have hands-on experience with Snowflake or another cloud data warehouse.
- Have experience with dbt, including model design, testing, documentation, dependencies, incremental models, and performance optimization.
- Have experience with ETL/ELT tools such as Matillion, Airflow, Fivetran, Azure Data Factory, or similar platforms, and understand orchestration, dependencies, scheduling, retries, monitoring, and operational reliability.
- Bring strong discipline around primary keys, data grain, schemas, data types, versioning, lineage, and documentation.
- Can work through ambiguity, ask strong questions, and turn unclear problems into clear implementation plans.
- Communicate clearly, write well, and can explain technical concepts to business stakeholders.
- Think in systems, demonstrate ownership and curiosity, and bring the judgment, humility, attention to detail, and engineering rigor needed to build reliable, maintainable systems.
Additional Experience That Would Be Valuable
The following experience is helpful, but not required:
- Experience in asset management, investment operations, performance measurement, portfolio analytics, or financial services.
- Experience with slowly changing dimensions, dbt snapshots, incremental models, data contracts, observability, APIs, JSON, XML, or Parquet.
- Exposure to RAG systems, embeddings, vector databases, document ingestion, chunking, or LLM-enabled workflows is a plus, but not required.
- Python experience for data engineering, automation, validation, or workflow orchestration
- Certifications in Snowflake, dbt, cloud platforms, data engineering, CFA, or related fields.
What We Offer
- Competitive compensation and benefits package.
- A collaborative, high-standard environment with meaningful ownership, autonomy, and exposure to firmwide data initiatives.
- Broad visibility across investment, operations, performance, reporting, compliance, and business teams.
- The opportunity to work with a modern data stack on problems where reliability, business meaning, and engineering rigor matter.
APPLICATION
Please submit your application by email to [email protected]. Please note that only candidates selected for an interview will be contacted. Thank you for your interest in PineStone!
________________________
Basée à Montréal, Gestion d’actif PineStone Inc. est une société spécialisée en gestion mondiale d’actions fondée en 2021. PineStone se consacre exclusivement à aider ses clients à atteindre leurs objectifs financiers en investissant dans ce que nous considérons comme les entreprises de la plus haute qualité à travers le monde. PineStone gère actuellement environ 75 milliards de dollars canadiens d’actifs et est dirigée par Nadim Rizk, un gestionnaire de portefeuille chevronné ayant plus de 25 ans d’expérience. Visitez notre site web : www.pinestoneam.com/fr
- Notre mission : Créer une valeur exceptionnelle pour nos clients et leurs bénéficiaires sur de nombreuses années.
- Notre vision : Être la référence en matière de recherche fondamentale, de construction de portefeuille et d’investissement de croissance de qualité à long terme.
- Nos valeurs : Nous cultivons une culture d’engagement, d’intégrité, de dynamisme, de rigueur et de patience.
Pay: $70,000.00-$85,000.00 per year
Benefits:
- Company events
- Company pension
- Extended health care
- Wellness program
Work Location: In person
