- You flourish in a hybrid work environment, where the team is in the office on Tuesdays, Wednesdays, and Thursdays. Mondays and Fridays are flexible for where you work best.
- You enjoy working in a team of bright professionals, and work and learn in a diverse atmosphere - our team and colleagues have varied backgrounds, experiences, and perspectives.
- You have a strong business acumen, combined with the ability to work with internal and external stakeholders in a professional and constructive manner.
- You have excellent communication and teamwork abilities.
- You have strong analytical and problem-solving skills.
- Collaborate with business stakeholders to understand their business requirements, data needs, objectives, and challenges. Translate these requirements into technical specifications for developing BI solutions.
- Design data models to transform raw data into actionable insights aligned with organizational goals.
- Design, develop, and deploy Power BI scripts for detailed data analysis and transformation.
- Develop SQL queries to retrieve and manipulate data from databases to identify trends, patterns, and outliers within the data, enabling informed decision-making.
- Analyze data and create visually engaging dashboards using BI tools such as Power BI, Tableau, or QlikView to support decision-making processes.
- Analyze existing ETL processes and design new systems for optimized data integration.
- Utilize Data Analysis Expressions (DAX) queries and functions to enhance data analysis and visualization.
- Develop custom connectors for Microsoft Power Automate.
- Optimize BI solutions for performance and scalability, ensuring that reports and dashboards load quickly and efficiently even when dealing with large datasets.
- Collaborate with cross-functional teams, including business analysts, data engineers, and IT professionals, to ensure that BI solutions meet business requirements and technical standards.
- Provide ongoing support and troubleshooting for BI applications.
- Conduct workshops and training sessions on Power BI to empower other teams within the organization.
- Completion of a post-secondary Diploma or Degree in Information Technology (or equivalent).
- Microsoft Power BI certification (Required).
- Knowledge of Python (Required).
- Microsoft Power Platform Fundamentals Certification (Nice to have).
- Power Pages (Nice to have).
- 4-5 Years of related work experience.
- Technical Skills:
- Proficiency in SQL, data modeling, and ETL processes.
- Proficiency in BI tools (e.g., Power BI, Tableau, QlikView).
- Experience with DAX Studio (Recommended).
- Familiarity with the Microsoft BI stack (Power Pivot, SSRS, SSIS, SSAS) is advantageous.
Business Intelligence Developer - Calgary, Canada - Alberta Electric System Operator
Description
The Alberta Electric System Operator (AESO) is responsible for the safe, reliable, and economic planning and operation of the Alberta Interconnected Electric System. We provide open and non-discriminatory access to Alberta's interconnected power grid and also facilitate Alberta's competitive wholesale electricity market. The AESO strives to foster an inclusive, diverse and equitable workplace where people feel respected and welcomed for who they are, together we deliver high performance and innovative results.
Job Description
If you are a current AESO employee or contractor, please view openings and apply through our internal site at Workday.
Reporting to the Manager, Data and Digital Workplace Services, the Business Intelligence (BI) Developer will be accountable for designing interactive visualizations, creating user-friendly dashboards, and extracting insights. This role entails serving as an internal expert in M365 Power BI, Power Automate & Apps, providing support, implementation, and design services for M365 Power Platform and Dynamics. Additionally, the BI Developer will handle day-to-day maintenance, resolve assigned incidents, and change requests, and serve as an escalation point for Power BI support issues. BI Developers play a critical role in transforming raw data into actionable insights that drive business growth, improve operational efficiency, and enhance decision-making processes across the organization.
This full-time opportunity offers a competitive salary, and a variable pay program. We also have paid vacation and flex time, health and dental benefits, mental health support, a defined contribution pension plan, and learning and development opportunities as part of your overall compensation package.
You will enjoy working with us if:
Accountabilities include but are not limited to:
What you'll bring to us:
Application deadline: April 11, 2024
If you are contacted for a pre-screening and/or interview, please advise of any accommodation measures required to enable you to fully participate. Information received relating to accommodation measures will be addressed confidentially.
The Alberta Electric System Operator is unable to accept unsolicited agency resumes.
The Alberta Electric System Operator, and its members, officers, employees and agents (collectively, the "AESO") is committed to protecting personal information provided to it. When you submit your personal information to the AESO for the purpose of pursuing employment with the AESO, the collection, use and disclosure of personal information is in accordance with the provisions of the Freedom of Information and Protection of Privacy Act (FOIP Act) of Alberta.
As noted, the AESO is mandated to maintain the safe and reliable operations of the provincial power grid. As part of meeting its obligations, the AESO may require the successful candidate to undergo a criminal background check for the position. This collection of personal information for the purposes of a check will be conducted in accordance with Section 33 of the FOIP Act.