Job Description

Description :
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 Niagara's 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 Niagara's 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 Niagara's 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:

• 3-5+ 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:

• Bachelor's 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 replacement position. Expected annual compensation; $74,000 - $90,000.
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 Day dedicated to 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 Ottawa. We are committed to having a positive and meaningful impact on Canada's 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 teamwork. Health 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 diverse, equitable, and inclusive organization where everyone has access to opportunity, feels a sense of belonging, and can thrive. We 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 industry. We encourage applications from candidates of all backgrounds and lived experiences and are committed to a barrier-free hiring process. If you require accommodation at any stage of the recruitment process, please contact us at careers@modernniagara.com so we can make appropriate arrangements.
We appreciate every applicant's interest in joining Modern Niagara. Only those selected for an interview will be contacted.

Skills Required