Data & Reporting Analyst
We transform the way people use energy.
We embrace a culture of belonging in the workplace. No matter who you are, where you’re from, how you think, what you believe in, or whom you love, we welcome your application. We all come from different backgrounds and different walks of life, bringing in unique perspectives and experiences. We encourage applications from 2SLGBTQ+, Black, Indigenous, African Nova Scotian, racialized persons, and People of Colour (BIPOC), women, newcomers to Canada, and people with disabilities. Please let us know if you require any accommodation in the application and interview process (including different materials or otherwise).
About EfficiencyOne
Our core values are Integrity, Innovation, and Partnership.
EfficiencyOne is a leading efficiency enterprise. We work with outstanding partners to supply cost-effective energy efficiency and carbon mitigation services in Nova Scotia and beyond.
We transform the way people use energy. Together, we help people achieve their energy goals, save money, conserve resources, improve well-being, and combat climate change.
Investing in energy efficiency has many benefits: lower heating bills, more comfortable spaces, new jobs in your community, and a smaller overall carbon footprint.
Our work achieves over $5.6 billion in energy savings and avoids the release of 12.7 megatonnes of greenhouse gas emissions (CO₂ eq) in the province. If there’s a better way to improve energy efficiency, we find it. Learn more about how we are making an impact here:https://www.efficiencyone.ca/impact/.
Why you’ll love working here:
- A culture that recognizes the importance of a work-life balance and genuinely cares about its employees.
- An engaging, fun, and inclusive work environment
- An awesome benefits package that starts on day one, and a competitive salary
- Wellness initiatives and fitness challenges are hosted throughout the year.
- Corporate gym memberships
- Career growth and professional development opportunities
- Being part of a team and contributing to Nova Scotia’s goal of a 2050 net-zero carbon
The opportunity:
The Data & Reporting Analyst manages and reports on corporate data to support evidence-based decision-making. You will work with multiple data sources and partner with data owners across the organization to combine, standardize, validate, and publish trusted information. The role also supports data management and self-serve reporting within our Databricks and Microsoft Power Platform environment.
Responsibilities:
· Design clear, intuitive, and visually compelling data visualizations and dashboards.
· Prepare datasets for loading into the corporate data warehouse and Customer Information System (CIS), as required.
· Deliver operational and compliance-driven reporting aligned to internal and external stakeholder timelines (e.g., audit and evaluation schedules), including clear written summaries of results and insights.
· Partner with internal and external stakeholders and data owners to define requirements and KPIs, confirm definitions/assumptions, and respond to ad hoc data and report requests (data warehouse, CIS, and other sources); communicate insights, limitations, and data quality considerations.
· Build and maintain recurring Power BI reports and dashboards, including data pipelines and automated refresh; support self-serve reporting through user guidance, dashboard design support, and training.
· Maintain data integrity through validation, reconciliation, and issue resolution with data owners; document key definitions, data sources, and refresh procedures.
· Identify and implement process improvements across the data lifecycle (collection, transformation, and reporting), including automation of data movement and reporting where appropriate.
· Contribute to planning exercises, as required.
· Participate in cross-functional projects by providing data, analysis, and reporting support.
· Perform other related duties as required.
What Will Help You Succeed?
· University degree or college diploma in data/information management (or an equivalent combination of education and experience).
· Experience with Power BI and Power Query.
· Working knowledge of SQL and Python, including experience combining and analyzing data from different sources and formats.
· Self-motivated and able to work independently; comfortable working with non-standardized data to deliver timely insights (without waiting for “production-ready” datasets).
· Strong communication skills (written and verbal), including the ability to translate data into clear summaries for management and external audiences and to work effectively with internal and external stakeholders.
· Excellent time management skills, including the ability to prioritize, multitask, and meet tight deadlines in a fast-paced environment.
· Outstanding attention to detail.
· Willingness to learn new applications and languages as needed.
· Adaptability in a quickly evolving industry (new concepts, tools, and ways of working).
· Proficiency with Microsoft Office (Excel, Word, PowerPoint, Outlook, Teams).
Assets
· Experience with Azure, Salesforce CRM, Generative AI, and/or the Microsoft stack (Copilot, Fabric) is considered an asset.
What to expect in your first several weeks on the job:
In the first week, expect to:
- Meet with the team
- Read through the technical documentation
- Be introduced to internal data structures
- Receive a training walkthrough of relevant datasets and tools
In the first month, expect to:
- Meet with the broader information and analytics team to learn how our roles correlate.
- Gain a broader understanding of our data warehouse and begin to develop content expertise
- Understand the core workflow and processes of the Business Intelligence Team
- Handle ad hoc requests from throughout the organization
- Independently perform assigned tasks
In the first three months, expect to:
- Take ownership of core responsibilities and areas of technical expertise (e.g., evaluation)
- Develop specific content expertise within internal client groups and manage requests independently
- Act as the main contact point for developed internal clients