Have you seen BOMA Edmonton’s new and improved Jobs Board? We feature job openings for all of our members without them having to send them our way. If you are a member and would like us to share your posting on our social media or our newsletter, please contact us for more information. If you are looking for a new opportunity, check out the many exciting openings available to you from BOMA Membership.

Data Warehouse Analyst - IT Services

Job Number

: 47165 

Make your favourite place your workplace!

Is it time for the next challenge? Are you customer service oriented and a dynamic data professional? Then EPL has an exciting opportunity for you! 

As the Data Warehouse Analyst, you will support the operation and ongoing maintenance of the Cloud Data Warehouse service. In this position, you will be responsible for designing, developing and maintaining data warehouse solutions that supports EPL’s data governance framework and advances our strategic plan.

Key responsibilities of this position include:

  • Developing and maintaining the data warehouse:
    • ETL processes to extract, transform, and load data from multiple sources.
    • Data models to support business intelligence and reporting.
    • Pipelines for the movement of data through the data warehouse solution.
  • Documenting data warehouse processes. Contributing to the development of EPL data governance policies and standards (e.g. security, access).
  • Designing and developing queries and reports.
  • Monitoring and optimizing data warehouse performance. Troubleshooting data warehouse issues.
  • Conducting research and providing advice to other information systems professionals regarding the collection, availability and suitability of data. 

As the ideal candidate, you are resourceful and analytical. Your collaborative approach with staff to identify and meet evolving data requirements (e.g. new data sources or extraction opportunities) will be valued.

Job Requirements

  • Degree in computer science, information systems or related field from a recognized post-secondary institution.
  • Minimum of 5 years of related experience, including experience in:
    • Data warehousing design and development using Azure Cloud services
    • Design, development, modification, and maintenance of relational and multidimensional database structures
    • Developing ETL processes and knowledge of ETL (extract, transform, load) tools
    • Data modeling and business intelligence applications

What do you need to bring to this position?

  • A commitment to upholding the Canadian Federation of Library Associations position statements on Intellectual Freedom and Diversity and Inclusion.
  • Ability to provide effective customer service.
  • Proficiency in SQL, ETL, and data modeling techniques.
  • Knowledge of reporting and analytics tools.
  • Demonstrated excellence in interpersonal and communication skills.
  • Effective analytical skills.
  • Creative problem solving and effective trouble shooting abilities.
  • Adaptability.
  • Ability to work effectively both independently and collaboratively in a team environment.
  • Effective organizational and time management skills, with the ability to manage multiple tasks and changing priorities.

Who we are:

The secret ingredient for making EPL a magical place is no secret at all; in fact, it's very simple: We share. We share stories, ideas and experiences. We share with our customers, our communities, and ourselves. We are Edmonton's largest lender of all manner of information and entertainment.

Pay Band:
$38.56 - $49.22 per hour*
*Approximately $70,463 - $89,930 per annum based on a 35 hour work week.
Shift differential may apply in accordance with the terms and conditions of the CSU 52 Collective Agreement.


  • This position will work occasional evening and weekend shifts.
  • Satisfactory background screening is required for this position, which includes a Criminal Record Check/Police Information Check.
  • Candidates who do not meet the job requirements may be considered at a lower developmental classification and pay level.

To apply: Please submit a resume and a cover letter that outlines the reasons why you are interested in working for the Edmonton Public Library and how your education, experience and abilities make you a strong candidate for this career opportunity. Only candidates who are selected for an interview will be contacted

Total Hours per Week: 35
Classification Title: Professional Services 3

Posting Date

: Jun 29, 2023

Closing Date

: Open until suitable

Number of Openings (up to)

: 1 - Permanent Full-time
Union : CSU 52


: Edmonton Public Library

Work Location(s)

Information Technology Services, Stanley A. Milner Library, 4th Floor, 7 Sir Winston Churchill Square 
 Edmonton T5J 2V4


Powered By GrowthZone