Intermediate Data Engineer

Address:

Position Summary

The Data Engineer is responsible for designing, building, and supporting scalable data solutions that enable analytics, reporting, regulatory, and operational business processes. Working as part of the Data Engineering team, the successful candidate will develop and maintain data pipelines, data integration solutions, data models, and cloud-based data platforms.

The role will participate in the implementation of modern data technologies including Microsoft Fabric, cloud data platforms, data warehousing, and AI-enabled data solutions. The candidate will work closely with business stakeholders, data analysts, architects, and technology teams to deliver reliable, secure, and high-quality data products.

Key Responsibilities

• Design, develop, test, and maintain batch and real-time data pipelines.
• Build and support ETL/ELT solutions using modern cloud-based technologies.
• Develop and optimize data ingestion, transformation, and consumption layers.
• Support data integration across enterprise platforms and source systems.
• Implement data quality, reconciliation, and validation controls.
• Assist with production support activities, root cause analysis, and issue resolution.
• Participate in migration and modernization initiatives involving Microsoft Fabric, cloud data platforms, and enterprise data warehouses.
• Develop reusable frameworks, automation utilities, and monitoring capabilities that improve operational efficiency.
• Collaborate with architects and senior engineers on data modelling, platform design, and solution implementation.
• Contribute to CI/CD implementation, automated testing, and DevOps practices.
• Work with governance and security teams to ensure compliance with enterprise data management standards.
• Participate in Agile ceremonies, technical design discussions, and estimation activities.
• Create technical documentation and support knowledge transfer activities.

Microsoft Fabric & AI Responsibilities

• Design and develop data solutions using Microsoft Fabric including Data Factory, Lakehouse, Data Warehouse, Notebooks, and Real-Time Intelligence capabilities.
• Develop and optimize ELT pipelines within Microsoft Fabric.
• Implement Medallion Architecture patterns (Bronze, Silver, Gold) for enterprise data products.
• Build data models and curated datasets to support analytics and reporting workloads.
• Collaborate with AI and analytics teams to prepare data for machine learning and generative AI use cases.
• Develop AI-assisted operational solutions using Microsoft Copilot, Fabric AI capabilities, and intelligent automation frameworks.
• Support implementation of metadata management, lineage, and data observability capabilities.
• Participate in pilot initiatives involving AI-driven data quality monitoring, impact assessment, operational intelligence, and self-healing data pipelines.

Required Skills

Data Engineering

• SQL
• Python
• Data Warehousing
• Data Modelling
• ETL/ELT Development
• Data Integration
• Cloud Data Platforms
• Performance Optimization
• Data Quality Management
• Source-to-Target Mapping

Microsoft Fabric

• Microsoft Fabric
• Fabric Data Factory
• Fabric Lakehouse
• Fabric Data Warehouse
• Fabric Notebooks
• OneLake
• Medallion Architecture
• Spark Fundamentals

AI & Automation

• Generative AI Concepts
• AI-Assisted Development Tools
• Microsoft Copilot
• Prompt Engineering Fundamentals
• Data Preparation for Machine Learning
• Intelligent Process Automation
• Metadata and Data Lineage Concepts

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en.

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.