Senior Data Engineer
- Oakville, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- 5+ years experience in a relevant field, flexible for the right candidate.
- Posting language
- English
- Posted
Original job description
PROFILE
TriMech is investing in a modern enterprise data platform - built on Microsoft Fabric - to create a trusted, scalable foundation for reporting, analytics, AI, and data-driven decision-making across the group. This role sits at the heart of that programme.
As Senior Data Engineer / Data Scientist, you will design, build, and operate the group's data ecosystem: integrating data from our core business systems, developing robust pipelines, establishing quality and governance standards, and delivering the advanced analytics and AI capabilities that shape strategic and operational decisions.
This is a hands-on, high-visibility role. You will work directly with executive leadership, business teams, and IT to turn raw data from platforms such as Salesforce, NetSuite, marketing systems, and bespoke applications into secure, governed, and genuinely useful insights. You will also help set the engineering standards, deployment practices, and support processes for the platform as it scales.
DUTIES AND RESPONSIBILITIES
Data platform engineering
- Design and build scalable data pipelines, ingestion, transformation, and orchestration processes on Microsoft Fabric.
- Develop the enterprise lakehouse architecture and data models that serve analytics, reporting, and AI use cases.
- Integrate data across multiple applications via APIs and ETL tooling.
- Optimise performance, reliability, and cost, and embed CI/CD and DevOps practices for platform deployments.
Business intelligence & analytics
- Translate business requirements into analytical datasets, semantic models, and Power BI reporting across Sales, Finance, Marketing, Customer Success, Operations and more.
- Build executive and board-level reporting datasets, and champion self-service analytics adoption.
Data science & AI
- Develop forecasting, statistical, and predictive models using enterprise data assets.
- Support AI and machine-learning initiatives and evaluate emerging technologies for practical business value.
Governance & quality
- Implement data quality monitoring, validation, and master data management practices.
- Establish cataloguing, lineage, and metadata management through Microsoft Purview, and support security, privacy, and regulatory compliance.
Stakeholder partnership
- Work with leadership and data owners to improve definitions, consistency, and measurement frameworks.
- Communicate technical concepts clearly to technical and non-technical audiences alike.
SKILLS AND REQUIREMENTS
- A degree in Computer Science, Data Science, Engineering, Mathematics, Statistics, or a related field - or equivalent practical experience.
- 5+ years experience in a relevant field, flexible for the right candidate.
- A strong track record designing and running enterprise-scale data pipelines and integrations across multiple applications.
- Deep SQL expertise, data warehousing, and dimensional modelling, with experience of lakehouse and modern data architecture patterns.
- Hands-on experience with Microsoft Fabric (or equivalent platform), or a strong Azure data estate (e.g. Azure Data Factory, Synapse) with the appetite to specialise in Fabric.
- Power BI development, including semantic models.
- Python and/or R for analytics and automation, plus source control and DevOps practices.
- Applied experience in at least one of: predictive modelling, statistical analysis, forecasting, machine learning, or AI solution development.
- Experience with business platforms such as Salesforce, NetSuite, and CRM/ERP integration patterns.
- Microsoft, Azure, Fabric, or data engineering certifications.
- Highly analytical and naturally curious, with strong attention to detail.
- Ability to translate ambiguous business questions into clear data requirements and solutions
- Comfortable moving between deep technical work and business conversations.
- Able to work independently, manage competing priorities, and communicate with impact.
- Passionate about data quality, governance, and continuous improvement.
COMPENSATION
- OTE $154k - 165k per annum
PERKS AND BENEFITS
- Hybrid Work Arrangements
- Flex PTO
- Competitive Group Benefits Plan
- Perkopolis Membership Access – Employee perk and discount programs.
- Wellness Program
- Social Events
This opportunity is to fill an existing vacancy
TriMech is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including gender identity and sexual orientation), disability, age, national origin, or protect veteran status or any other protected status.
More about this job
Responsibilities
Design, build, and operate the enterprise data platform, including scalable pipelines, integrations, lakehouse architecture, data models, and Power BI analytics. Develop forecasting and AI capabilities, establish data quality and governance practices, and partner with business leaders to deliver trusted insights.
Requirements
Requires at least five years of relevant experience or equivalent practical expertise, with strong SQL, enterprise data pipeline, data warehousing, and modern data architecture experience. Candidates should have experience with Microsoft Fabric or an equivalent Azure platform, Power BI, Python and/or R, applied analytics or AI, and CRM/ERP integrations; a relevant degree or equivalent experience is required.
Skills
- Microsoft Fabric
- Data Engineering
- SQL
- Data Warehousing
- Dimensional Modeling
- Lakehouse Architecture
- Data Pipelines
- ETL
- API Integration
- Power BI
- Python
- R
- Data Science
- Predictive Modeling
- Data Governance
- Microsoft Purview
Benefits
- Hybrid Work Arrangements
- Flexible Paid Time Off
- Competitive Group Benefits Plan
- Perkopolis Membership
- Wellness Program
- Social Events
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Science & Research
Keywords
- Microsoft Fabric
- Azure Data Factory
- Azure Synapse
- Microsoft Purview
- Power BI
- SQL
- Python
- R
- Salesforce
- NetSuite
- Data Engineering
- Data Pipelines
- ETL
- API Integration
- Data Warehousing
- Dimensional Modeling
- Lakehouse Architecture
- Semantic Models
- Business Intelligence
- Data Science
- Predictive Modeling
- Statistical Analysis
- Forecasting
- Machine Learning
- Artificial Intelligence
- Data Quality
- Data Governance
- Master Data Management
- CI/CD
- DevOps