Azure Data Engineer

Role Summary
The Azure Data Engineer plays a key role in building maintaining and optimizing structured SQL data assets that power analytics reporting and downstream integrations. This role supports the transition from adâhoc data sources to governed productionâready Azure and SQL platforms ensuring reliable analytics automation and system integrations. Success in this role means delivering highâquality data solutions partnering effectively with analytics and business teams and contributing to Modern Niagaras data maturity.

Why This Role Matters to Modern Niagara
Azure Data Engineers are essential to enabling accurate scalable analytics and efficient operations across the organization. Their work ensures teams have timely trusted data to make decisions automate processes and enhance operational performance. This role directly impacts data quality system reliability and Modern Niagaras ability to grow its digital and analytics capabilities.

Key Impact / Purpose

• Deliver trusted wellâstructured and performant SQL and Azure data assets that support analytics reporting and integrations.
• Strengthen collaboration with analytics IT and business stakeholders to understand requirements and deliver scalable data solutions.
• Drive Modern Niagaras data maturity by automating manual processes optimizing pipelines and ensuring governance and data integrity.

Duties and Responsibilities:

SQL Development & Data Engineering (Core Focus)

• Design write and optimize SQL queries stored procedures views functions and indexes within Azure SQL environments.
• Build and maintain structured analyticsâready datasets for reporting and downstream consumption.
• Apply best practices in data modeling schema design and ensuring data integrity.
• Troubleshoot and performanceâtune SQL workloads in productionâlike environments.

ETL / ELT & Cloud Data Pipelines

• Design enhance and support ETL/ELT pipelines using Azure Data Factory (ADF).
• Improve existing pipelines for scalability reliability and maintainability.
• Transition manual or spreadsheetâbased processes into automated SQLâbacked pipelines.

Power Platform Enablement

• Build support and maintain Power Platform solutions leveraging structured SQL data.
• Develop and enhance Power Apps and Power Automate flows integrated with SQL/Azure assets.
• Ensure Power Platform solutions are scalable governed and aligned with enterprise data models.
• Support troubleshooting enhancements and optimization activities.

Analytics & Business Collaboration

• Partner with analytics data and business teams to understand data requirements.
• Ensure datasets used for analytics are accurate wellâstructured and performant.
• Provide clear documentation and knowledge transfer throughout the contract.

Integration & Automation

• Support workflow automation and system integrations when required.
• Exposure to RESTâbased integrations Power Automate or Boomi is an asset.
• Collaborate with system owners on integration needs intersecting with SQL and analytics platforms.

Must Haves:

• 35 years of handsâon experience as a SQL Developer Data Engineer or similar role.
• Strong proficiency in SQL (Azure SQL / TâSQL) including query optimization and performance tuning.
• Experience building and supporting ETL/ELT workflows in cloud environments.
• Handsâon experience with Azure Data Factory (pipelines datasets integration runtimes).
• Experience with Microsoft Power Platform (Power Apps Power Automate) using SQL/Azureâbacked data sources.
• Strong understanding of structured data design and data modeling.
• Ability to work independently while collaborating across teams.

Nice to Haves:

• Bachelors degree in Computer Science or a related field.
• Experience with REST API integrations.
• Exposure to Boomi or similar integration platforms.
• Familiarity with C#/.NET in a data or integration context.
• Experience with Azure Logic Apps Azure Functions or related Azure services.
• Knowledge of DevOps/CIâCD or Gitâbased deployment workflows.
• Familiarity with Power BI or other analytics tools.

This is a annual compensation;$74000 - $90000.

Modern Niagara offers a competitive total compensation package including:â

• Performance based bonus opportunitiesâ
• Defined Contribution Pension Plan with a generous employer contributionâ
• Flexible Health and Dental benefits with tiered options to meet the needs of you and your familyâ
• An annual health spending account to support your overall wellnessâ
• 24/7 confidential support through our Employee and Family Assistance Program with access to comprehensive resources and professional servicesâ
• A competitive vacation package withâadditionalâvacation granted throughout your tenure with the organization.â
• Employer Paid Parental Leave Top Upâ
• Annual Community Daydedicatedto volunteering and giving back to the communities where we live and workâ
• Corporate Discounts through various vendors across Canada for programs such as fitness mobile phones travel home and auto insurance and many othersâ

Here at Modern Niagara because we know our people are the best in the industry we pride ourselves on providing a total compensation package that rewards employees for their hard work and supports employees and their families in their overall wellbeing.ââ

About Modern Niagara

Who We Are

Modern Niagara helps building owners managers and general contractors meet the mechanical electrical integrated building technology and building services needs of their buildings across Vancouver Calgary Edmonton Toronto Southwestern Ontario and are committed to having a positive and meaningful impact on Canadas infrastructure and on the communities where we live learn work and heal. We build for life.

Our Culture & Values

We value passion initiative determination professionalism and and safety are embedded in everything we do and our award-winning safety culture consistently performs well above industry standards.

Diversity Equity & Inclusion at Modern Niagara

We are committed to building a diverseequitable and inclusive organization where everyone has access to opportunity feels a sense of belonging and can actively work to remove barriers faced by members of equity-seeking groups (including women Indigenous Black racialized 2SLGBTQIA people people with disabilities and newcomers to Canada) in the construction encourage applications from candidates of all backgrounds and lived experiences and are committed to a barrier-free hiring you require accommodation at any stage of the recruitment process please contact us we can makeappropriate arrangements.

We appreciate every applicants interest in joining Modern Niagara. Only those selected for an interview will be contacted.

Required Experience:

IC