"Excellence in Energy Innovation"

Saint John Energy is an award-winning, internationally recognized distribution utility serving the citizens of Saint John New Brunswick since 1922. Our team has been recognized for energy innovation, leadership, and excellence by Electricity Canada, the International Smart Grid Network, and the Smart Energy Project.

Saint John Energy is a community-owned utility that cares, above all, about people. We are relentless in our goal to provide our customers with convenient, reliable energy choices that provide comfort, save money, and help protect the environment. We care about our teams, the communities we serve, and the province where we work and live - we invest in them every day.

Saint John Energy is guided by the principles of: Safety & Wellness, Customer & Community, Integrity, and Bravery. Safety is more than a core value - it's a way of life at Saint John Energy, demonstrated every day through our commitment to the safety of our employees, customers and community.

Applications are invited for the role of "Senior Data Analyst" until 3:00pm on Wednesday, November 6, 2024.

As a Senior Data Analyst with BI Expertise, you will build on our existing data infrastructure while excelling in leveraging data and harnessing the power of BI tools to deliver tangible business value. You will play a key role in supporting, optimizing, and improving the self-service capabilities of our data systems. Collaborating with stakeholders across Saint John Energy, you'll analyze complex datasets, develop insightful dashboards and reports, and ensure that data is accessible and actionable for informed decision-making.

You will be involved in a diverse, high profile and impactful program that will be enable Saint John Energy to meet its vision of reaching Net Zero by 2030, as well as other process improvement and technology modernization initiatives. This role will involve working closely with a wide range of both internal and external stakeholders and requires the ability to work at both a technical and big-picture level.

Responsibilities:

• Support the Vision, Mission, and Guiding Principles of Saint John Energy
• Build strong working relationships with business users and leadership teams
• Understand key business data and data quality. Treating data as an asset
• Lead the development, maintenance, and optimization of BI tools, systems, and dashboards.
• Lead efforts to standardize reporting and analytical tools across the organization to ensure consistency and adoption.
• Collaborate with Analysts to develop, implement, and optimize data architectures that enhance self-service BI capabilities and support accurate reporting.
• Develop ETL/ELT processes to integrate data from multiple sources (databases, APIs, cloud platforms) for reporting, ensuring data quality and reliability.
• Create and manage data models to support efficient querying, analytics, and reporting.
• Improve and maintain data governance practices to ensure data integrity, security, and compliance across systems.
• Develop interactive dashboards, reports, and visualizations using tools like Power BI to provide actionable insights to business teams.
• Partner with business stakeholders to understand reporting and analytics needs, ensuring data is structured properly for use by BI tools.
• Optimize database performance and troubleshoot data-related issues, ensuring fast, efficient querying and reporting processes.
• Mentor and guide junior engineers and analysts, promoting best practices in data management, BI, and analytics.
• Analyze legacy reports, understand data structures, and redesign them using Power BI capabilities.
• Work with IT teams to implement robust security protocols for BI tools and ensure controlled access to sensitive information.

Working Conditions:

• 40 Hours per week (flexible working arrangements available on mutual agreement).
• Inside office environment.
• Sitting and standing for moderate periods.

Employment Requirements:

• Bachelor's degree in a relevant field (e.g. Computer Science, Information Systems, Data Science) or equivalent practical experience
• Excellent problem-solving and communication skills, with the ability to translate complex technical concepts to non-technical audiences.
• 5+ years of experience in Data Engineering, with expertise in SQL for querying and managing databases. Experienced in data warehousing and data modelling
• Proficiency in Power BI
• Familiarity with AWS and Azure cloud platforms
• Knowledge of API, FME, Awesense Energy Data Model and ArcGIS Data would be beneficial
• Knowledge of Utilities & sustainability requirements would be an asset
• Understanding of project management methodologies, including agile