Technology Services
Information Services and Technology
Position number: 37995
Date posted: June 30, 2026
Extract, Transform, and Load (ETL) Developer - IT5 (AESES)
New Regular Continuing Full-Time (Budget Funded)
Work schedule:
35 Hours/week (Monday to Friday, 8:30 am to 4:30 pm)
Salary:
$41.59 to $60.02 per hour ($75,693.80 to $109,236.40 per annum)
Expected Start Date
July 27, 2026
For more information please contact: IST Human Resources - [email protected]
MINIMUM FORMAL EDUCATION/TRAINING:
- University degree or college diploma in a related discipline, or an equivalent combination of experience and education is required. Examples include: Computer Science Degree, Computer Engineering Degree, Business Analyst Diploma, Business Information Technology Diploma.
- Azure Data Engineer Associate (Exam DP-203: Data Engineering on Microsoft Azure) or Microsoft Fabric Data Engineer Associate (Exam DP-700) is required.
- Professional designation such as CBAP or equivalent is preferred.
- Data-focused certifications such as CDMP (DAMA), CBIP (TDWI), or IIBA CBDA would be an asset.ITIL certification preferred.
EXPERIENCE:
- Minimum 6 years of experience writing ETL applications, utilities, process enhancements is required.
- Minimum 6 years of SQL development is required.
- Minimum 3 years of experience using Azure Data Factory, Azure Synapse Pipelines or other Microsoft ETL (SSIS) is required.
- Experience developing standard and supportable pipelines is required, with experience in the creation and maintenance of Azure Data Factory pipelines.
- Minimum 2 years experience defining and designing ETL processes is required.
- Minimum 2 years experience using T-SQL is required.
- Minimum 2 years experience using PySpark and / or Python is required.
- Minimum 3 years experience with a focus on data quality and data cleansing is required.
- Experience using Azure DevOps, Azure Synapse, Azure DataLake would be an asset.
- Experience using and developing data pipelines for a Data Warehouse would be an asset.
- Experience using a Data Lake or lakehouses would be an asset.
- Experience using Oracle PL/SQL would be an asset.
- Familiarity with Microsoft Fabric and Fabric notebooks would be an asset.
- Familiarity with Power BI would be an asset.
- Familiarity with Purview would be an asset.
- Experience with Higher-Education data subject areas would be an asset.
- Experience with Banner, Banner Student, Financial aids and Awards, and Admissions data would be an asset.
- Experience with Higher Education software such as Slate and D2L would be an asset.
- Experience in analyzing and documenting complex business processes is required.
- Experience in other IT roles or functions such as data analysis, quality assurance/testing, data modeling, and data/enterprise architecture is required.
- Experience working on a project using Agile or iterative methods is required.
- Analysis Experience is required, such as:
- Requirements Elicitation.
- Creating requirements and system specifications deliverables.
- Familiarity IT frameworks including ITIL, TOGAF, PRINCE2 an asset.
- Data and Analytics Experience is required, such as:
- Data Modeling conceptual, logical, and physical normalized and analytical models
- Knowledge of data analysis and usage requirements
- Strong understanding of data and integration architecture
- Ability to guide solution design and architecture to meet business needs
- Proficiency in technology management
- Understanding of data analysis
- Data Modelling and information classification in an Enterprise context.
- Understanding of metamodels, taxonomies and ontologies,
- Familiarity applying structured techniques (data modelling) to unstructured sources.
- Defining, designing, developing, maintaining, and optimizing ETL processes
- Understanding, communicating, and processes to support Data Quality
- Leadership experience is required, such as:
- Participating in Data Governance.
- Creation of frameworks and processes related to Data Analysis and Data Architecture
- An acceptable equivalent combination of education and experience may be considered.
SKILLS AND ABILITIES:
TECHNICAL SKILLS and ABILITIES
- Skill with Data Modeling conceptual, logical, and physical normalized and analytical models is required.
- System and process analysis skill required.
- Planning and organization skills required.
- Skill with data and information classification at the enterprise level is required.
- Skill with Data Analytics is required.
- Skill with Microsoft Visio is required.
- Skill with SQL queries is required.
- Ability to read and create Entity Relationship Diagrams is required.
- Familiarity with database systems, preferably MSSQL or Oracle is required.
- Familiarity with data science concepts, as well as Master Data Management, business intelligence, and data warehouse structure and use, statistics, and statistical analysis is required.
PERFORMANCE SKILLS and ABILITIES
- Excellent interpersonal skills including teamwork, facilitation required.
- Excellent written and verbal communication skills required.
- Excellent presentation skills including ability to articulate complex concepts to audiences with varying levels of technical expertise required.
- Ability to be highly collaborative is required.
- Creative and practical approach to problem solving required.
- Analytical and problem-solving skills and attention to detail required.
- Ability to adapt and respond to change required.
- Understanding of business context and objectives required.
- Analytical and problem-solving skills required.
- Ability to quantify resource requirements and measure and communicate proposed project benefits is required.
- Risk assessment, negotiation, and problem resolution skills required.
- Influencing skills and demonstrated ability to engage both developers and business partners to achieve target outcomes required.
- Satisfactory work record, including satisfactory attendance and punctuality, is required.
ETL Design, Development, and Operational Support
- Primarily responsible for design and development of Azure Data Factory, Azure Synapse and Microsoft Fabric components, including pipelines, notebooks, lakehouses, activities, datasets, linked services, and data flows
- Responsible for operational management and support of Azure Data Factory, Azure Synapse and Microsoft Fabric components
- Responsible for Azure Dev Ops administration
- Work with business partners to understand requirements for data use, analysis, and quality
- Work with stakeholders to understand and document the use and flow of data
- Interrogate database systems using SQL to understand data components, flow and use
- Map data and data sources to normalized and analytical data models
- Coordinate with data owners to ensure data accessibility and quality
- Identify and aggregate data from internal and external sources
- Identify new opportunities to leverage data and to integrate data or applications to enhance business value
- Guide solution design to meet data and integration requirements
- Designs Azure Data Factory, Azure Synapse, and Microsoft Fabric components using best practice
- Provision, configure and optimization of Azure Data Factory, Azure Synapse, and Microsoft Fabric components
- Define and document the Azure Data Factory, Azure Synapse, and Microsoft Fabric pipelines and notebooks
- Mentor other resources regarding Azure Data Factory, Azure Synapse, and Microsoft Fabric knowledge, expertise, and best practices.
- Contribute to the review of Solution Architecture and Architecture Deliverables and recommend design options.
- Assist in Azure Data Factory, Azure Synapse, and Microsoft Fabric issue investigation and resolution.
- Provide input into Azure Monitoring and reporting.
- Provide expertise and assist in the design of the Data Warehouse Data model.
Business Analysis
- Work with stakeholders and subject matter experts to elicit requirements, use cases, business rules, goals, and needs. Manage requirements elicitation, analysis, and documentation processes to capture business and end user needs
- Produce documentation deliverables – including requirements and specifications – in compliance with IST Methodology standards
- Apply knowledge and expertise to recommend options to stakeholders and decision makers
- Communicate effectively with business and technical audiences
- Communicate solution trade-offs to business partners to frame and influence project decisions
- Engage delivery teams to communicate solution vision and priorities
- Promote architectural standards and consistency
- Proactively monitor industry, functional, and technology trends to guide business partners on emerging opportunities
- Assess the risks of solution options and develop plans to mitigate them
- Support enterprise digital strategy and organizational change management
- Define, set up, and execute test cases to validate that the solution meets functional and non-functional requirements
- Provide consultative support and advice on technology projects led by business partners
- Coach employees to make use of technology and information
Professional Development
- Maintains and updates professional skills and knowledge, and integrates into the work environment new knowledge acquired through continuing education and professional development opportunities
- Maintain currency in relevant certifications and skills
- Develop and enhance relevant knowledge and skills to advance the capabilities of the practice and the Institution
Health and Safety
- Completes all mandatory safety education sessions and re-certifications
- Adheres to all workplace health and safety regulations, policies and safe work practices
Other
- Performs other related duties as required or assigned
The University of Manitoba is committed to the principles of equity, diversity & inclusion and to promoting opportunities in hiring, promotion and tenure (where applicable) for systemically marginalized groups who have been excluded from full participation at the University and the larger community including Indigenous Peoples, women, racialized persons, persons with disabilities and those who identify as 2SLGBTQIA+ (Two Spirit, lesbian, gay, bisexual, trans, questioning, intersex, asexual and other diverse sexual identities).
If you require accommodation supports during the recruitment process, please contact [email protected] or 204-474-7195. Please note this contact information is for accommodation reasons only.
Application materials, including letters of reference, will be handled in accordance with the protection of privacy provisions of "The Freedom of Information and Protection of Privacy Act" (Manitoba). Please note that curriculum vitae will be provided to participating members of the search process.
