IT Specialist I-IV (SAP BW Specialist)

Énergie NB Power; Fredericton; On-site; CAD 72,000 - 120,000; Full time

Benefits offered by this job

Health & Dental plans

Health Spending Account

Public Service Pension Plan

Wellness program

Union representation

Job summary

Énergie NB Power is seeking a Data Modeler to support data lifecycle management, governance, reporting and analytics. You will design data models across multiple domains, working with analysts, architects, and data scientists to advance enterprise data capabilities.

Your background includes SAP BW (BW7.x/BW on HANA/BW/4HANA), ETL tools, and BI tools like SAP BI and Power BI. A degree in CS and strong attention to detail are essential.

Qualifications

• Bachelor's degree in Computer Science or a related discipline.
• At least 3 years of hands-on SAP BW data modeling experience (BW7.x, BW on HANA or BW/4HANA).
• Experience with data extractions, process chains and data analysis.
• Familiarity with ETL tools and data ingestion protocols.

Responsibilities

• Support data lifecycle management, governance, reporting and analytics.
• Create data models optimized across data domains for enterprise use.
• Collaborate with analysts, architects, data admins, developers and data scientists.
• Troubleshoot data loads and production issues in SAP BW environments.
• Participate in on-call rotation as required.

Skills

Data modeling

SAP BW

ETL tools

BI tools

MS Office

Requirements translation

Education

Bachelor's Degree in Computer Science

Tools

SAP BW/4HANA

SAP ABAP

SAP HANA Studio

Power BI

Job description

Salary range : $34.70 to $57.72 per hour based on a 40 hours per week

Competition # E22634-2026

At NB Power we are a team, committed to offering the best customer experience, ensuring energy security, and accelerating a sustainable clean energy transition. Why? Because we’re New Brunswickers too, we care about our customers and future generations, and today we are actively looking for a new member to join us.

As a part of the Business Support team, you will support formal data lifecycle management, governance, reporting and analytics, all necessary to advance the capability of data and information management. You will be responsible to create data models optimized across different data domains and for various purposes, working with enterprise requirements from business/data analysts, architects, data administrators, database developers, and data scientists.

Key functions include:

• Perform Data Modeler functions in SAP BW 7.5 on HANA, SAP BW/4HANA and SAP HANA Studio, utilizing data modeling and data warehouse skills. This includes, but not limited to, the expansion and updates to the existing data models, creation of InfoObjects, InfoProviders, DataStore objects, data flows, data views and data sources
• Analyze, troubleshoot and resolve production issues in SAP BW on HANA, SAP BW/4HANA and SAP HANA. Monitor and fix data loads and respond to job failure alerts
• Provide support in the implementation of ETL processes, including data capture, data transformations and validation
• Work with business, application support and architecture teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models for operational and analytical environments
• The successful candidate will be required to participate in an on-call rotation

Our ideal teammate will have:

• Bachelors Degree in Computer Science or a relevant discipline
• Three years hands‑on experience in developing and optimizing data models in SAP BW (BW7.x, BW on HANA or BW/4HANA), including data extractions and process chains as well as experience in data analysis

Combined with:

• Intermediate skill level with ETL tools and data ingestion protocols
• Knowledge and exposure to Business Intelligence tools (SAP BI, MS Power BI)
• Intermediate proficiency in Microsoft Office products (i.e.: Word, Excel, PowerPoint, and Visio)
• Strong ability to translate business requirements into technical specifications
• Strong attention to detail combined with the ability to prioritize tasks
• Knowledge of SAP ABAP and SAP HANA Studio would be considered an asset
• Experience with utility-related data and information would be considered an asset

An equivalent combination of training and experience may be considered. Subject to competition response, the minimum qualifications may be modified.

An Eligibility List generated from this competition may be used to fill future vacancies at the same level within a period of up to 12 months.

We care for our team, and as a member you will have access to:

• Health & Dental plans that provide flexible options to meet your needs
• Health Spending Account, allowing for further flexibility
• New Brunswick Public Service Pension Plan, offering retirement financial security
• Wellness options, including our Employee Family Assistance Program
• Benefits that allow for financial protection in the event it is needed
• Various options for paid or unpaid leaves
• Representation of the IBEW Local 37 Union
• Career development and growth throughout the organization
• Competitive wages

NB Power will accept foreign credentials if they are considered acceptable by a recognized Canadian educational institution. Candidates with foreign education credentials are required to provide proof of Canadian equivalency. Any applicable fees are the responsibility of the candidate. For more information, you may refer to the Canadian Information Centre of International Credentials

To be considered for this employment opportunity you must be eligible to work in Canada.

For questions concerning this job opening please contact Kratika Shinde at [e-mail]

Please note that only candidates selected for an interview will be contacted regarding the next steps.

NB Power is an equal opportunity employer dedicated to workforce diversity.