BI Developer (Tech IV)
ITS Business Intelligence
MacEwan University inspires students with a powerful combination of academic excellence and personal learning experiences – ours is a connected culture that focuses on learner-centered teaching, and on providing opportunities for students to grow and achieve.
The university provides a transformative education in a creative, collaborative and supportive learning environment. 19,000 full- and part-time students are enrolled in more than 65 programs: four-year undergraduate degrees, applied degrees, university transfer programs and one- and two-year diploma and certificates. Additional offerings include university preparation, English as an Additional Language, professional and personal development courses and workshops, corporate training and the Conservatory of Music.
We are seeking an experienced BI Developer for our MacEwan University ITS business Intelligence department.
The BI Developer is accountable for analysis, design and development of the University’s business intelligence and data warehousing solutions. This position is the primary role responsible for administration and provision of application development and support services for BI technology used to connect to, transform and visualize data. Acts as IT liaison for internal and external contacts related to the solutions within the BI architecture stack (i. e. Microsoft Power BI, Erwin, IBM InfoSphere).
Degree in Computer Science, information technology or related discipline, or diploma in related discipline combined with relevant on-the-job experience.
Minimum of 3 years of progressively responsible experience with BI and DW technologies.
Experience in design and development of data marts, data warehouses and consolidated data repositories.
Experience with Microsoft Power BI (Power BI Services, Power BI Desktop, Power BI Pro, Power BI Premium) including the Data Analysis Expression (DAX) function library.
Experience in dashboard and KPI development.
Previous experience with ETL development, preferably with DataStage.
Work experience with DW architecture and data modeling; experience with Erwin data modeler preferred.
A background of working in a large post secondary institution with demonstrated knowledge of standard business processes is an asset.
Customer-centric, collaborative mind set
Excellent verbal and written English 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
High level of competency with data manipulation and interrogation using SQL
Knowledge of data warehouse, data mart and database technologies, standards, and methodologies
Good understanding of database and data warehouse design theory (logical and physical)
Expertise with BI and analytical UX development using Microsoft BI toolset.
Strong understanding of Power BI application security layer models
Strong knowledge of Data Analysis Expression (DAX) query language
Knowledge of IaaS, PaaS or SaaS Cloud services
Good understanding of ETL design theory
Ability to develop and maintain Extract, Transform and Loading (ETL) processes. Experience with DataStage an asset.
- Microsoft Power BI certification(s) an asset.
Equivalents and work experience will be considered.
When you become part of the MacEwan team, you will enjoy a competitive salary. Our total compensation package includes:
Competitive base pay
Generous vacation time
Secure pension plan
Excellent benefits package
Effective recognition and retention programs
Continuous learning culture
Opportunities for career growth
How to Apply
Only applications received electronically will be considered. To apply, go to http://www.macewan.ca/careers and select the job posting.
Thank you for your interest in employment with MacEwan University. We will be reviewing all applications to select the candidates whose qualifications and experience most closely meet our needs. Only applicants selected for interviews will be contacted.
This position is included under the MacEwan Staff Association Collective Agreement. Please note; initial salary placement for external candidates is limited to the first five steps of the salary grid.
MacEwan University is committed to diversity, equity, and inclusion. We encourage Indigenous people, persons living with a disability, sexual and gender minorities, women, and members of all minority groups to apply and to self-identify. All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.
|Salary||$59,514 - $73,728|
|Closing Date||September 20, 2019|
Personal Information Collection Notification
Personal information is being collected to determine your qualifications for employment. This information is collected, used and protected under the authority of and in accordance with the provisions of the Freedom of Information and Protection of Privacy Act. It may be provided to non-HR members of a hiring and interview panel if your application advances to that stage of the hiring process. If you have any questions about these arrangements, please contact: Human Resources, University Services Centre, Rm. 10-600, 10700-104 Avenue, Edmonton, Alberta, T5J 4S2 or phone (780) 497-5434.