Data and Reporting Analyst - Calgary, Canada - Enmax

Enmax

Verified Company

Calgary, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Posted:
July 12, 2023

Closing Date:
August 2, 2023

Position Type:
Permanent

Union:

CUPE
PEOPLE. That's the power behind ENMAX Corporation.

As one of Alberta's leading energy and utility providers, our employees are the strength and knowledge that continue to drive our success.

At the ENMAX group of companies, we look for energy solutions for today, while knowing we have the power to provide for a better tomorrow.

The Data and Reporting Analyst must be proficient in data and process optimization, have a solid understanding of data analysis, data analytics, ETL development, reporting, dashboarding and data modeling.

Major Responsibilities- Architect and deliver analytical solutions to process complex information from System One data sources (Maximo, Workday, Powerplan, Adaptive Insights) into efficient and robust data models for developing engaging and effective dashboards.- Build and maintain pipelines and data flows in Azure Synapse Analytics workspace to ingest, transform and store data from cloud and on-premise source systems.- Provision multi-sourced data through a data virtualization layer in Denodo and optimize query performance using features like caching and data movement. Perform unit testing, troubleshoot defects, and document solutions as part of the project lifecycle.- Identify processes that can be optimized and automated using Power BI, Power Apps, Denodo, Azure Synapse pipelines and other analytical tools.- Evaluate and advise on best practices for solution design.- Write SQL queries for ad-hoc analysis.- Conduct data literacy workshops and knowledge sharing sessions with business and technical users to promote effective data modeling and utilization of System One data assets.- Participate in the change management efforts related to product and system upgrades and minimize the impact on business users through effective communication, training, and testing.- Stay up to date with industry trends, emerging technologies, and best practices in business intelligence and data analytics.

Education Required:

University degree in Computer Programming, Engineering, or Business with at least five years of progressive experience in business intelligence and data warehousing experience
Related certification in Microsoft Power BI, Azure Data Factory/Synapse Analytics, or programming (such as Python or SQL) is preferred.

Qualifications & Experience:

5 years or more of previous experience in a technology function or/and business 5 years previous experience in developing solutions using standard RDBMS Expertise in data visualization concepts and tools such as Power BI, along with experience in Microsoft Power Platform and Denodo Strong proficiency in SQL and experience with Azure Synapse Analytics, Azure SQL Server, and other cloudbased data platforms Solid understanding of data engineering principles, including data modeling, data warehousing, and data quality Experienced in connecting to and consuming XML, JSON, and CSV data formats Proven experience in change management efforts and delivering effective training sessions

Competencies:

Analytical and critical thinker with experience implementing continuous process improvements
Ability to work independently, prioritize tasks, and adapt to a fastpaced and evolving environment
Strong organizational skills with a keen attention to detail
Ability to develop and maintain positive working relationships both internally and externally
Excellent written and verbal communication skills

Did we mention the ENMAX Advantage?

We offer competitive compensation including a comprehensive flexible benefits program, non-downtown location that includes great building amenities such as free onsite fitness facility with programming geared to employee's needs, onsite childcare centre (upon availability, offered from our ENMAX Place location Ave. SE), free parking and much more.

If you share our values and would like to make a difference with your career, join the team and see where the ENMAX possibilities can take you.

Salary:
Programmer Analyst, Level C (CUPE 2023 rates)

$97, $103, $110, $116, $122,301.27

ENMAX Values - Safety, Integrity, Accountability, Service, Teamwork, Agility, Innovation

Location:

This role will be part of our hybrid (home and office) work force with office workspace located at ENMAX Place th Avenue SE, Calgary, AB).

You will work from home on Mondays and Fridays and in the office on Tuesdays, Wednesdays, and Thursdays.

Note:

Every ENMAX employee is responsible to take reasonable care to protect the health and safety of themselves, of all other workers, and of the public. Each employee must become familiar with safety procedures and rules applicable to their job and are required to follow them while working at ENMAX.
Must be legal to work in Canada and requires the successful completion of a criminal background check. Two pieces of valid Government issued ID will b