Data Engineer

Mount Royal University; Calgary; On-site; CAD 84,000 - 106,000; Full time

Benefits offered by this job

Recreation centre membership

Health and dental benefits

Pension

Paid vacation

Job summary

Mount Royal University is seeking a Data Engineer to design and optimize Microsoft Fabric data lakes and an enterprise data warehouse. You will architect cloud data infrastructure, manage ELT/ETL workflows, and integrate data from the Ellucian Banner ERP system.

The role focuses on performance, data quality, and scalable pipelines. The ideal candidate will have 5–8 years of data engineering experience, strong SQL, Python, Spark, and a deep familiarity with Fabric and the Azure ecosystem.

Qualifications

• Bachelor degree in computer science, computer engineering, data engineering, AI, or ML.
• 5–8 years of experience as a data engineer.
• Experience with ERP integrations (Banner, PeopleSoft, Workday).
• Experience with data warehousing, ETL/ELT, and cloud lakehouse design.
• Strong SQL, Python, and Spark skills; CI/CD and Git knowledge.

Responsibilities

• Design and develop Microsoft Fabric data lakes and enterprise data warehouse.
• Architect cloud data infrastructure with high availability and security.
• Lead ELT/ETL and BI development; build deployment pipelines from dev/UAT to production.
• Implement data quality checks, monitoring, and fault-tolerant pipelines.
• Collaborate with OIRP, ITS, and other departments to ensure integrated data solutions.

Skills

SQL

DevOps

Git

Python

Spark

Microsoft Fabric

Data pipelines

ETL/ELT

Data governance

Education

Bachelor degree in computer science or related

Tools

Microsoft Fabric

Pipelines

PySpark

SparkSQL

SparkR

Dataflows

DAX

Notebooks

Semantic Models

Power Platform

Job description

Share this job as a link in your status update to LinkedIn.

Job Title

Job Type

Limited Term

Union

MRSA

Position Classification

STA06 Technology Assistant VI

Salary Grade

$83,738.20 - $105,978.60

FT or PT

Full-time

Hybrid Work

This position is ineligible

Position End Date (if applicable)

12/31/2028

Location

About this Position

About the Department

The Office of Institutional Research and Planning (OIRP) has primary responsibility for institutional strategic planning, surveying and institutional data analysis at Mount Royal. The Office collects, analyzes, interprets and reports data and information to support decision making, planning and evaluation across the institution. Academic quality assurance is a function of prime importance in a university, and OIRP supports academic units in conducting cyclical program reviews and developing new programs through data, analysis and coordination. OIRP is responsible for providing quality information and institutional research to inform strategic planning, assessment, development and accountability and for providing leadership in the management of data as a University resource.

About the Role

This position, reporting to the Director, Institutional Research and Planning, will lead the design, development, and optimization of our Microsoft Fabric data lakes and enterprise data warehouse. In this role, you will be the driving force behind our transition to modern data warehousing solutions leveraging Microsoft Fabric and the broader Azure ecosystem. The role will be tasked with architecting complex data pipelines, orchestrating ETL/ELT workflows, and integrating disparate data sources—with a specific focus on extracting and transforming data from our Ellucian Banner ERP system. The ideal candidate brings a deep technical mastery of SQL, DevOps, Git, Spark, Python, dataflows, deployment and data pipelines, a passion for performance optimization, and the ability to turn raw data into a strategic asset.

Collaboration with colleagues in the Office of Institutional Research and Planning (OIRP) Department, ITS, and engaging experts across other departments are critical components of this role to ensure optimized data integration, high data quality, and fault-tolerant pipelines.

This is a full-time limited term position, working 35 hours per week until December 31, 2028.

Responsibilities

Data Engineering

• Design, develop, and implement Microsoft Fabric data lakes, enterprise data warehouse, and BI solutions leveraging various enterprise data warehouse methodologies, models, and technology stack.
• Architect and manage the cloud data infrastructure on Microsoft Fabric, ensuring high availability, security, and performance.
• Execute hands-on ELT/ETL and BI development delivery tasks, specifically; ETL job development, technical data model design, and development of deployment pipelines from dev/UAT environment to production environment.
• Implement robust monitoring, alerting, and data validation checks to ensure data quality, accuracy and reliability of the data pipelines.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.
• Develop data designs, scripts, and code for new projects of moderate to high complexity.
• Design dimensional and relational structures optimized for reporting and analytics.

Data Modelling

• Understand and gather data and business requirements from various departments and division at MRU and transform them into data warehouse solutions and semantic data models.
• Contribute to driving reporting automation and perform quality assurance to support the development of scalable and sustainable data products.
• Build and architect semantic data models, datasets, and self-service analytical solutions.
• Develop strategies for data modeling, design, and implementation to meet requirements for metadata management, operational data stores and ELT/ETL environments.

Collaboration and Engagement

• Engage subject matter experts across OIRP, ITS, and various other departments to provide support and solve complex technical problems and deliver data solutions.
• Identify cross-institutional issues or problems related to data quality and system integration and recommend solutions and alternatives toward the effective implementation of data quality standards and governance.
• Collaborate with data specialist, business analysts, management, and other team members to gather requirements and deliver user-centered solutions.
• Ensure compliance with institutional and ITS technology standards, policies, and security requirements.
• Document planned and unplanned changes, and support problem resolution as required.

Qualifications

• A Bachelor degree—preferably in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.
• Direct experience in data warehousing, ETL/ELT processes, database design with strong verbal and written communication.
• Must have 5 - 8 years of experience as a data engineer, integrating ERP systems (e.g., Banner, PeopleSoft, Workday), designing data pipelines and building enterprise data warehouses.
  • A combination of education and work experience is required to perform the necessary data requirements gathering and analysis, integration of on-prem data into the cloud lakehouse, design of the cloud enterprise data warehouse and semantic models, and ongoing optimization of data integration processes.
• Must have experience using Microsoft Fabric technology stack including Pipelines, PySpark, SparkSQL, SparkR, Dataflows, DAX, Notebooks, and Semantic Models - having experience building enterprise data warehouses must be identified in your resume.
• Fluent in creating data processing frameworks using T‑SQL, Python, PySpark, SparkSQL, and Microsoft Fabric technology stack.
• Experience in delivering data solutions with expert knowledge of CI/CD, DevOps, Git, data structures, data quality management, dimensional modelling, and star‑schema design.
• Experience with Power Platform (Power Apps, Power Automate) is an asset.
• Excellent time‑management and organizational skills, with the ability to handle conflicting demands and prioritize effectively.
• Proven abilities to take initiative and be innovative.
• Analytical mind with a problem‑solving aptitude.

Closing Date: Open until a suitable candidate is found

A cover letter and resume should be submitted in one .pdf document. Please title your .pdf document as follows: [Last Name], [Requisition Number], [Document Title].pdf (ex. Smith, 4321, CV.pdf).

We encourage all qualified applicants to apply, however, Canadian citizens, permanent residents and others currently legally authorized to work in Canada will be given priority. Please note only applicants selected for an interview will be contacted. After the close date, you can check on the status of your application through your Career Centre. New career opportunities arise frequently and are posted as they become available. Please check back often to view our latest postings on our Career Opportunities page.

If you require accommodation to participate in the recruitment process, please notify [e-mail] and we will work together on your accommodation request.

About MRU

Founded in 1910 and located in Calgary, Alberta, Canada, Mount Royal University grew into a vibrant college in the 1930s and became a mid-sized university in 2009. A student-focused undergraduate university built on teaching excellence, Mount Royal University is known for our top-calibre programs, high-quality teaching and learning experience, robust delivery of liberal education, scholarly teaching, experiential learning and undergraduate research. MRU serves approximately 15,782 students, including 11,752 full-time and 4,030 part-time learners. MRU offers 13 bachelor's degrees encompassing 37 majors across faculties such as Arts, Business, Communications, Health, Community & Education, and Science & Technology. With over 74% of its student body drawn from the local area, Mount Royal University primarily serves Calgary and its surrounding region. MRU is a diverse yet close community with over 1,800 employees. Mount Royal provides employees the support they need to lead and advance institutional goals. Learn more about MRU’s Academic Plan and Strategic Plan .

What We Offer

Talented and committed employees are the driving force behind student success. We strive to be an employer of choice among Canadian post-secondary institutions. At MRU, we recognize that people are a combination of many intersecting identities; we work to cultivate an environment that welcomes the whole person, and harnesses the strength that is available in our diversity, creating a rich and inclusive workplace.

Investing in the learning and development of our employees benefits the individual and the University. A variety of services, resources and programs encourage a healthy, productive workplace. MRU offers a competitive total compensation package including learning/training paid by employer, paid vacation, winter holiday closure, personal days and a free membership in our fully equipped recreation centre. Positions over six months may also be eligible for health and dental benefits, pension, health and personal spending accounts, and disability benefits.

Our campus offers the convenience of a full medical clinic, dentist and pharmacy, as well as a variety of wellness services such as physiotherapists and massage therapists. Campus Recreation offers many activities, including personal training, fitness classes, climbing, aquatics, sports, tournaments and certifications for students, employees and the public.