ABOUT US

MacEwan University is where caring faculty help people connect their passions to their future paths. Located in the heart of Edmonton’s diverse and dynamic downtown community, and on the traditional lands of Treaty 6 First Nations and homelands of the Métis people, MacEwan is known for exceptional undergraduate learning. With its dedication to teaching excellence, informed by scholarly research, innovation, and creative activity, MacEwan provides an exceptional collaborative and supportive learning environment with a commitment to human rights, environmental sustainability, and opportunities for community engagement. We are committed to creating an equitable, diverse, inclusive, and welcoming community for all peoples, cultures, and identities.
Our comprehensive undergraduate university offers 55 programs to more than 19,000 full- and part-time students in business, communications, community and human services, design, fine and performing arts, health, humanities, natural science, nursing, public safety, and social science. Through a wide array of experiential learning opportunities, and strategic relationships in the community, we partner with others to produce graduates of stature. Along with a robust grounding in their chosen disciplines, MacEwan students are given durable life skills that prepare them to take on the world.

OPPORTUNITY

MacEwan University is seeking an ETL Senior Analyst for a full-time continuing opportunity with the Information Technology Services department.
The ETL Senior Analyst coordinates the development and design of the enterprise data warehouse and BI systems and coordinates system administration, patching, and configuration support. You will serve as a subject matter expert in ETL (Extract, Transform, Load) to support the university’s data warehouse, data integrations, analytics, and business intelligence initiatives. In addition, you will support the migration to Microsoft Fabric and ensure seamless integration with Power BI for advanced data visualization and reporting.

Key responsibilities include:

• Managing development, implementation, documentation, and optimization of enterprise ETL;
• Designing, coding, and testing ETL jobs required to support the enterprise data warehouse;
• Conducting impact assessments of data models and determining the scope of the ETL effort based on requirements;
• Resolving production support issues, including analysis and investigation, problem solving, risk assessment, and implementation of appropriate solutions;
• Translating data model and business mappings into technical mappings required for ETL development;
• Analyzing data model and technical mappings to architect ETL job dependencies and sequencers;
• Coordinating and supporting migration processes by documenting change requirements and testing evidence;
• Configuring, maintaining, troubleshooting, and performing performance optimization of the ETL environment;
• Leading activities related to installs, patching, upgrades and health monitoring as needed and liaises with IT operations regarding infrastructure needs (i.e. servers, disc, network); and
• Maintaining vendor relationships and user accounts for issue tracking and problem resolution.

SKILLS

You will have:

• A strong understanding of data extraction, cleansing, transformation, and loading processes;
• Excellent verbal and written communication skills and the ability to interact professionally with a broad group of technical and business subject matter experts;
• Proficiency in analytic and problem-solving skills, detail-oriented mind set and ability to manage multiple projects and priorities;
• Strong change management and documentation skills;
• A high level of competency with data manipulation and interrogation using SQL;
• A high level of competency with ETL design theory and architecture best practices;
• A high level of competency in developing and maintaining ETL processes;
• Demonstrated expertise in Microsoft Fabric and Azure Data Factory, including migration from legacy ETL tools;
• Advanced knowledge of data warehouse, data mart and database technologies, standards, methodologies and best practices;
• The ability to work with ambiguity; and
• Strong work ethic and be self-driven.

QUALIFICATIONS

• A minimum of a bachelor’s degree in Computer Science, Information Technology or related field.
• A minimum of 7 years of progressively responsible experience in information technology, with at least 5 years ETL experience with BI and data warehouse technologies.
• Experience in the design and development of data marts, data warehouses, and consolidated data repositories.
• Expertise in working closely with business and IT stakeholders to define problems and design large-scale, enterprise class solutions.
• Experience with Power BI for dashboard development and data reporting.
• Hands-on experience with Microsoft Fabric and Azure Data Factory, with working knowledge of Power BI for data visualization and reporting.
• Experience with IBM InfoSphere DataStage is considered an asset.
• Experience working in a postsecondary or other public sector institution is considered an asset.
• Demonstrated knowledge of PeopleSoft is considered an asset.
• An equivalent combination of education and experience may be considered.

• Managing development, implementation, documentation, and optimization of enterprise ETL;
• Designing, coding, and testing ETL jobs required to support the enterprise data warehouse;
• Conducting impact assessments of data models and determining the scope of the ETL effort based on requirements;
• Resolving production support issues, including analysis and investigation, problem solving, risk assessment, and implementation of appropriate solutions;
• Translating data model and business mappings into technical mappings required for ETL development;
• Analyzing data model and technical mappings to architect ETL job dependencies and sequencers;
• Coordinating and supporting migration processes by documenting change requirements and testing evidence;
• Configuring, maintaining, troubleshooting, and performing performance optimization of the ETL environment;
• Leading activities related to installs, patching, upgrades and health monitoring as needed and liaises with IT operations regarding infrastructure needs (i.e. servers, disc, network); and
• Maintaining vendor relationships and user accounts for issue tracking and problem resolution