Data Engineer at The Fedcap Group architecting and leading enterprise data warehouse solutions. Focused on enabling scalable growth and operational excellence across the organization.
Responsibilities
Deliver Reliable, Analytics-Ready Data Models
Build Secure and Compliant Data Infrastructure
Lead development of dbt and transformation workflows
Ensure performance and cost optimization
Enable end to end Data pipeline
Directly Support Business & Analytics Teams
Collaborate with the Head of Data and Analytics to implement the enterprise Medallion Architecture (Bronze → Silver → Gold)
Design, build, and maintain data ingestion pipelines in Azure Data Factory (ADF)
Configure and manage secure integrations between Azure and Snowflake
Develop and optimize Snowflake data models
Implement role-based access control (RBAC), data masking, and row/column-level security in Snowflake
Build and maintain a modular dbt framework
Create and manage CI/CD pipelines for dbt using GitHub Actions or Azure DevOps
Write and optimize complex SQL and Python scripts
Implement data validation, quality checks, and monitoring frameworks
Collaborate directly with BI, Analytics, and Data Science teams
Take end-to-end ownership of assigned data engineering projects: requirements - design - build - deploy - support
Document pipelines, transformations, and models to ensure reproducibility and team-wide adoption
Requirements
Bachelor’s degree in information systems, Computer Science, Engineering, or related field.
Advanced degrees in related fields are plus, however hands-on experience is strongly preferred.
Snowflake Snowpro Advanced Data Engineer / Architect certification (Preferred).
5+ years of proven experience in data engineer roles.
Deep expertise in enterprise system implementations, data lifecycle management, modular framework and data platform architecture.
Strong hands-on experience with dbt, Azure and Snowflake are a must.
Demonstrated ability to design and implement scalable, secure and modular data pipeline.
Experience with data quality frameworks, lineage and governance practice.
Track record of delivering end-to-end data solutions in cloud environments.
Benefits
Professional development opportunities • Flexible work arrangements
Staff Data Engineer building pipelines, models, and infrastructure for exacare ai’s post - acute care AI platform. Turning healthcare data into reliable foundations for product, analytics, and ML workflows.
Senior Data Engineer architecting cloud data platforms and pipelines for Arc’teryx supply chain analytics. Leading migrations, governance, observability, and engineering mentorship.
Senior Data Engineer improving General Motors vehicle data pipelines, monitoring, and observability. Supporting reliable fleet software operations across Oshawa and Markham hybrid offices.
Senior software engineer building General Motors’ vehicle data platform across ECUs and cloud. Developing control, data, logging, and SDK software for connected vehicles.
Senior Data Architect integrating Alberta’s environmental regulatory, Databricks, and geospatial platforms. Designing governed data flows for regulators, decision - makers, and Albertans.
Senior Data Architect leading secure, scalable data architecture for Manulife’s financial services organization. Designing cloud, lakehouse, analytics, machine learning, and generative AI data platforms.
Data engineering advisor developing scalable data platforms and pipelines for Desjardins. Designing, integrating, and improving data systems aligned with business needs.
Senior Data Engineer owning NimbleRx’s compliant healthcare data platform. Building scalable pipelines, warehouse models, and AI tooling for pharmacy and patient engagement operations.
Senior Data Platform Administrator shaping and operating EDC’s secure enterprise data platforms. Supporting Canadian businesses through Export Development Canada’s trade - finance solutions.
Administrateur principal de plateformes de données chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Conception, exploitation et gouvernance de plateformes de données infonuagiques.