Data Warehouse Analyst

4 weeks ago


Edmonton, Canada City of Edmonton Full time

**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.

**Qualifications**:

- 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

**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.

**Note**:

- 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.

**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

**Department***: Edmonton Public Library

**Work Location(s)***: Information Technology Services, Stanley A. Milner Library, 4th Floor, 7 Sir Winston Churchill Square Edmonton T5J 2V4


  • Data Warehouse Analyst

    2 months ago


    Edmonton, Canada Edmonton Public Library Full time

    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...


  • Edmonton, Canada Booster Juice Full time

    As Canada’s original juice and smoothie bar, Booster Juice remains committed to providing customers with choices they can feel good about. A leader of providing healthy alternatives in the quick-service food industry, we're consistently looking for new and innovative health products to add to our menu! Today, Booster Juice has expanded to over 400...

  • Data Analyst

    3 weeks ago


    Edmonton, Canada ASEBP Full time

    **DATA ANALYST, BUSINESS INTELLIGENCE SERVICES** Full-Time 14-Month Contract - Competition #23-69 **Position Summary** **Your Key Responsibilities** - Enhanced reporting_ - Develop solutions to reporting and information requirements by analyzing information needs and developing reports for ASEBP's internal and external clients. - Respond accurately and in...

  • Data Analyst

    3 weeks ago


    Edmonton, Canada ASEBP Full time

    **DATA ANALYST, BUSINESS INTELLIGENCE SERVICES** Full-Time 14-Month Contract - Competition #23-69 **Position Summary** **Your Key Responsibilities** - Enhanced reporting_ - Develop solutions to reporting and information requirements by analyzing information needs and developing reports for ASEBP's internal and external clients. - Respond accurately and in...


  • Edmonton, Canada Government of Alberta Full time

    **Job Information** Job Requisition ID: 53317 Ministry: Treasury Board & Finance Location: EDMONTON Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Permanent/Temporary: Ongoing Scope: Open Competition Closing Date: February 12, 2024 Classification: Technologies 5 **Salary**: $2,513.34 to $3,310.25 bi-weekly ($65,598 - $86,397...

  • Data Analyst

    5 days ago


    Edmonton, Alberta, Canada Litco Law Full time

    Business Applications and Technology Services – Data Analytics / At Litco Law, we are known for our extraordinary and unsurpassed firm culture – and for the people behind that culture. We've been recognized as a Canadian Top Employer and as one of Canada's Most Admired Corporate Cultures and know that this kind of success only happens when you have...

  • Data Analyst

    3 weeks ago


    Edmonton, Canada Litco Law Full time

    **Who We Are** At Litco Law, we are known for our extraordinary and unsurpassed firm culture - and for the people behind that culture. We’ve been recognized as a Canadian Top Employer and as one of Canada’s Most Admired Corporate Cultures and know that this kind of success only happens when you have amazing people on your team who are passionate about...

  • Data Analyst

    2 weeks ago


    Edmonton, Canada NAIT Full time

    Reporting to the Manager of Student Information Services (SIS) & Prospect and Applicant Relationship (PAR) Teams, the Data Analyst works closely with the manager, coordinators, team members and ITS, Marketing & Communication, and information asset content owners to develop insights related to the performance of information assets and SIS/PAR business...


  • Edmonton, Canada Government of Alberta Full time

    **Job Information** Job Requisition ID: 53303 Ministry: Treasury Board & Finance Location: EDMONTON Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Permanent/Temporary: Ongoing Scope: Open Competition Closing Date: February 12, 2024 Classification: Program Services 4 **Salary**: $ 2,757.39 to $3,604.16 bi-weekly ($71,967 - $ 94,068...

  • Data Analyst

    4 weeks ago


    Edmonton, Canada Litco Law Full time

    Business Applications and Technology Services – Data Analytics / At Litco Law, we are known for our extraordinary and unsurpassed firm culture – and for the people behind that culture. We’ve been recognized as a Canadian Top Employer and as one of Canada’s Most Admired Corporate Cultures and know that this kind of success only happens when...

  • Data Analyst

    4 weeks ago


    Edmonton, Canada Litco Law Full time

    Business Applications and Technology Services – Data Analytics / At Litco Law, we are known for our extraordinary and unsurpassed firm culture – and for the people behind that culture. We’ve been recognized as a Canadian Top Employer and as one of Canada’s Most Admired Corporate Cultures and know that this kind of success only happens when...


  • Edmonton, Canada SNDL Full time

    Job Title Intermediate Data Analyst Job Description About SNDL SNDL is the largest private sector liquor and cannabis retailer in Canada with retail banners that include Ace Liquor, Wine and Beyond, Liquor Depot, Value Buds, and Spiritleaf. As a licensed cannabis producer, SNDL also has indoor state-of-the-art grow-op facilities to supply wholesale and...


  • Edmonton, Canada City of Edmonton Full time

    **Job Number***: **48047** We are seeking a highly skilled and motivated Strategic Transit Data Analyst to join the Edmonton Transit Service (ETS), Transit Data Management Team. As a key member of our team, you will play a crucial role in addressing data governance and quality challenges by employing cutting-edge techniques in data engineering, machine...

  • Analyst, Data

    6 days ago


    Edmonton, Canada EPCOR Full time

    Highlights of the job - We are hiring up to two (2) full-time permanent Analyst, Data to join the Water Services, Customer Operations team working primarily from the EPCOR Tower located in downtown Edmonton, AB. - In the Analyst, Data role you are responsible for supporting optimal adoption of systems and use of data for decision making across EPCOR Water...

  • Analyst, Data

    4 days ago


    Edmonton, Alberta, Canada EPCOR Full time

    Highlights of the job We are hiring up to two (2) fulltime permanent Analyst, Data to join the Water Services, Customer Operations team working primarily from the EPCOR Tower located in downtown Edmonton, AB. In the Analyst, Data role you are responsible for supporting optimal adoption of systems and use of data for decision making across EPCOR Water...


  • Edmonton, Canada Finning Canada Full time

    Company: Finning Canada Number of Openings: 1 Worker Type: Permanent Position Overview: Join the Finning family! Finning Canada is seeking a Warehouse Support Analyst to join our team in Edmonton’s Regional Distribution Centre. This individual will troubleshoot and respond to incidents (by users), collaborate with Warehouse Operations and assist with...

  • Analyst, Data

    2 months ago


    Edmonton, Canada EPCOR Full time

    Highlights of the job We are hiring a full-time, permanent **Analyst, Data** position working out of Edmonton, AB. The Analyst, Data is responsible for supporting optimal adoption of systems and use of data for decision making across EPCOR Water Services (EWS). The Analyst, Data will utilize business intelligence tools, data pipeline tools, code, data...


  • Edmonton, Canada CWB Financial Group Full time

    At CWB , we strive to build value for the people who choose us every day: our people, our clients and our investors. We do this by holding true to the values that guide us. We put people first and build relationships with intention. We seek out and embrace new ideas, knowing that better is always possible. We believe that how we do things is as important...


  • Edmonton, Canada Government of Alberta Full time

    **About Us** **Job Information** Job Requisition ID: 50191 Ministry: Public Safety and Emergency Services Location: Edmonton Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Regular/Temporary: Permanent Scope: Open competition - 2 Positions available Closing Date: December 6, 2023 Classification: Program Services 2 **Salary**: $2,345.14 to...

  • Cloud Data Specialist

    2 months ago


    Edmonton, Canada Government of Alberta Full time

    **Job Information** Job Requisition ID: 53495 Ministry: Advanced Education Location: Edmonton Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Permanent/Temporary: Ongoing Scope: Open Competition Closing Date: February 26, 2024 Classification: Systems Analyst 3 **Salary**: $3106.31-$4114.41 Biweekly $81,074-$107,386/year) Advanced...