Analyst, Data

2 weeks 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 modeling tools, and various data sources to provide data visualization solutions for end users. This position will also be responsible for supporting technical training for Power BI Desktop, Power BI Service, and other software tools for data extraction, manipulation, analysis, and visualization.

What you’d be responsible for
- Providing higher-level technical expertise in the creation and maintenance of Power BI products. Including ensuring project data extraction, transformation, analysis, and loading is completed within timelines and aligned to recording rules that maintain data validity, accuracy and referential integrity.
- Supporting projects on behalf of the Situational Awareness group to ensure accurate and future-proofed project planning and implementation.
- Developing, maintaining and executing QA/QC measures to ensure that Power BI products and web based Power BI workspaces are aligned to standards and procedures.
- Using business intelligence tools and data to analyze and manipulate end user data to produce visualizations that support decision making throughout Water Services.
- Accessing, converting, and transforming end user datasets to update existing information, derive new information, or investigate and discover patterns and trends.
- Executing database queries to support decision making across Water Services.
- Developing and implementing a schedule to systematically correct legacy database errors and discrepancies.
- Gathering, documenting and acting on requirements that will support the establishment of Power BI and other BI and Data Analytics tools as enabling technologies to support EWS’ long-term objectives.
- Identifying gaps, errors or inadequacies in existing business process and making recommendations for improvements.
- Designing informative dashboards and data visualizations; using data from internal and external sources to provide creative solutions for end users’ business problems.
- Maintaining a library of procedures to support database recording, analysis, and reporting.
- Supporting backend data troubleshooting tasks, and investigating and resolving data conflicts and inaccuracies as they arise.
- Providing support to external communities, operations and/or stakeholders where required.

What’s required to be successful
- A Post-Secondary Degree related to Data Analytics, Data Science, Statistics, Computer Science, Management Information Systems/Business Technology Management, Computer Engineering/System Technology or equivalent is required.
- 3+ years of experience using Power BI for data cleaning/transformation, data modeling, and dashboard/report creation and publishing.
- 2+ years of project experience as a data analyst, business analyst, or data scientist.
- 2+ years of experience developing and delivering Power BI training to technical and non-technical end users.
- Experience in exploratory data analysis, including data cleaning and manipulation of various types of data.
- Experience working with SQL in Oracle relational databases to extract, manipulate, and write database content.
- Experience communicating data analysis results with technical and non-technical end-users.
- Strong knowledge of the fundamentals of data analytics, data management, and relational database concepts.
- Proficiency in Microsoft Office software.
- Experience with the following is considered an asset:

- Safe Software’s FME,
- Python and R programming languages,
- Advanced data analytics strategies, such as statistical inference, forecasting, geospatial data modelling, and machine learning,
- Experience with public sector or utility sector data.

Other important facts about this job

Jurisdiction: CSU52

Class: P1

Wage: $45.29 (Final Wage and Step will be determined at the time of selection and is based on a combination of factors as outlined in the Collective Agreement that may be found online.)

Hours of work: 75 hours biweekly

**Application deadline: September**
**6**
**, 2023**

Internal EPCOR Employees please ensure that you are using your “

Learn more about Working at EPCOR

Follow us on LinkedIn, Twitter, Glassdoor or Facebook

LI-TA6

Please note the following information:

- A requirement of working for EPCOR is that you are at least 18 years of age, successfully attained a high school diploma (GED, or equivalent level of secondary education) and legally entitled to work in Canada. (A copy of a valid work permit may be required.)
- If you are considered for the position, clearance on all applicable background checks (which may include criminal, identity, educational, and/or credit) and professional reference che


  • Data Analyst

    4 weeks ago


    Edmonton, Canada ARC Business Solutions Full time

    ARC Business Solutions Inc. is an established, growing and customer oriented information technology solution provider with proven abilities to incorporate strategy, creativity and technical aspects into business solutions. Core business verticals are: Professional IT Services, Enterprise Content Management, Utility Services and Managed Services. ARC...

  • Data Analyst

    5 days ago


    Edmonton, Canada ATCO Group Full time

    **Division: ATCO Gas & Pipelines** **Location: Edmonton AB** **Position: Data Analyst** **Position Summary**: Reporting to the Senior Engineer, Project Services in ATCO’s Gas & Pipelines division, the Data Analyst is pivotal in leveraging data and analytics to benefit engineering and construction projects. This role focuses on working closely with other...

  • Data Analyst

    7 days ago


    Edmonton, Canada Flair Airlines Ltd. Full time

    **Want to be part of a team that's changing the way Canada travels?** As Canada’s largest independent ultra-low-cost airline, that’s exactly what we’re doing at Flair Airlines. By consistently offering airfares that are a fraction of the ticket prices of “those other airlines”, we are making air travel an affordable option for millions of...

  • Data Analyst

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

  • Data Analyst

    7 days ago


    Edmonton, Canada WIN House, Edmonton's Women Shelter Full time

    **Data Analyst** **Full-Time (Job #11)** **What We Do** WIN House provides individuals and their children fleeing violence crisis response and intervention, safe temporary accommodation, and support for basic needs. Clients are offered trauma-informed, client-centered programming and support, access to resources, information, and referrals to community...


  • Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...


  • Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...


  • Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...


  • Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...


  • Edmonton, Canada Englobe Full time

    We offer A full range of benefits (group insurance with shared costs upon hiring, group RRSP); A telemedicine virtual healthcare service; An annual reimbursement of sports expenses; Opportunities for skills development; Flexible hours and ability to compress working hours; Internal policy to encourage teleworking. Choose the path of impact. Join...

  • Data Analyst

    7 days ago


    Edmonton, Canada City of Edmonton Full time

    **Data Analyst** **Job Number***: **45388** Under the direction of the Manager, Fleet and Facility Analytics, this position provides analytical support for the Fleet & Facility Services branch by building data sources, developing Tableau dashboards and doing analyses in spreadsheets. The position will be responsible for all aspects of research, data...

  • Data Analyst

    1 week ago


    Edmonton, Canada AutoCanada Full time

    Data Analyst Location : Edmonton, Alberta  Why you will love this job: We have an enthusiastic and highly effective team with no end of challenging and interesting work. Our company is a recognized national leader in business innovation and has featured in the top 30 best performing companies on the TSX. The company and our team...

  • Data Analyst

    2 weeks ago


    Edmonton, Canada Vantix Systems Inc. Full time

    Our Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.MUST HAVE - 5+ years experience in the Alberta Public Sector - Government or equivalent. MUST HAVE - 3+ years experience with ERP data migration (PeopleSoft or SAP) Client is in...

  • Data Analyst

    2 weeks ago


    Edmonton, Canada Vantix Systems Inc. Full time

    Our Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.MUST HAVE - 5+ years experience in the Alberta Public Sector - Government or equivalent. MUST HAVE - 3+ years experience with ERP data migration (PeopleSoft or SAP) Client is in...

  • Data Analyst

    2 weeks ago


    Edmonton, Canada Vantix Systems Inc. Full time

    Our Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.MUST HAVE - 5+ years experience in the Alberta Public Sector - Government or equivalent. MUST HAVE - 3+ years experience with ERP data migration (PeopleSoft or SAP) Client is in...

  • Data Analyst

    3 days ago


    Edmonton, Canada CGI Full time

    Are you ready to join an outstanding culture that cares about diversity and inclusion, corporate social responsibility and gives the freedom to innovate, influence decisions, and chart an exciting career? CGI is more than just an IT consulting company; be part of a team that supports the local community with the ability draw on global best-in-class talent....

  • Data Quality

    4 weeks ago


    Edmonton, Canada Effortless Admin Inc. Full time

    **Data Quality & Integration Analyst** **Effortless Admin Profile** **Effortless Admin is Canada’s leading benefits administration software and service company. **Our platform is fully web-based and provides employers an elegant way of managing employee benefits. We are an expanding organization looking for motivated individuals who want to be part of...


  • Edmonton, Canada Government of Alberta Full time

    **Job Information**: Job Requisition ID: 42568 Ministry: Municipal Affairs Location: Edmonton Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Regular/Temporary: Regular Scope: Open Competition Closing Date: June 16, 2023 Classification: Program Services 3 Market Adjustment **About Us**: The Ministry of Municipal Affairs assists...

  • Data Analyst

    5 days ago


    Edmonton, Canada University of Alberta Full time

    **MED Undergraduate Medical Education**: - Competition No. **S104651539** - Posting Date **Jul 20, 2023** - Closing Date **Jul 29, 2023** - Position Type **Full Time - Operating Funded** - Salary Range **$55,212 to $75,685 per year** - Grade **09** - Hours **35** This position is a part of the Non-Academic Staff Association (NASA). This position...


  • Edmonton, AB, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...