Business Intelligence Analyst (Hybrid)

Stella-Jones; Montreal; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading company in industrial wood products is seeking a Business Intelligence Analyst to leverage SAP and Power BI for data-driven decision-making. This hybrid role involves collaborating with stakeholders to develop innovative BI solutions and optimize performance. Ideal candidates will have a strong background in SAP technologies and data modeling, with opportunities for career advancement in a supportive environment.

Benefits

Extended health and dental coverage

Life insurance and AD&D

Disability coverage

Competitive salary

Profit sharing

Retirement plan (RRSP) with company match

Share purchase program with company contribution

Career advancement opportunities

Qualifications

• 3+ years of experience in SAP BW/Hana development.
• Proficient in Power BI, DAX, data modeling, and visualization techniques.

Responsibilities

• Collaborate with stakeholders to gather business requirements.
• Design, develop, and maintain SAP Datasphere and Power BI reports.
• Optimize data warehouse performance and ensure data quality.

Skills

Analytical

Problem Solving

Communication

Education

Bachelor’s degree in computer science

Master’s preferred

Tools

SAP BW 7.x

SAP HANA

Power BI

SQL

Python

R

Job description

Join to apply for the Business Intelligence Analyst (Hybrid) role at Stella-Jones

Get AI-powered advice on this job and more exclusive features.

Company Overview

Stella-Jones is North America's leading producer of industrial pressure-treated wood products. Responding to the vital infrastructure needs of our economy, we manufacture and distribute railway ties, utility poles, residential lumber, and industrial wood products across the continent. The Company’s common shares are listed on the Toronto Stock Exchange (TSX: SJ).

Stella-Jones recruits team members who embody our core values and desire an environment where growth is inspired, dedication is recognized, and achievement is rewarded. Our expanding footprint provides great prospects for career advancement as we develop our emerging leaders.

Position Overview

The Business Intelligence Analyst at Stella-Jones will be responsible for designing, developing, and maintaining SAP Datasphere & SAP HANA Deployment Infrastructure (HDI) database artifacts and Power BI Reports that support data-driven decision-making and drive business growth. This position offers an excellent career opportunity for someone with a strong background in SAP Datasphere, Hana, and/or Power BI, and a passion for leveraging technology to create innovative solutions.

This role will be hybrid (typically 2 to 3 days a week in office) based at our corporate HQ in Montreal (Saint-Laurent).

Key Responsibilities:

1. Collaborate with stakeholders to gather and understand business requirements, translating them into functional and technical specifications for SAP Datasphere, HDI solutions, and Power BI.
2. Design, develop, and maintain SAP Hana Native Objects such as calculation views and SQL Scripts.
3. Design, develop, and maintain SAP Datasphere objects, including SAP BW Bridge Objects, Analytic Models, Views, Consumption Models, and Perspectives.
4. Design, develop, and maintain BI reports and dashboards, including DAX development, Power Query, data modeling, and visualizations in Power BI.
5. Extract, transform, and load (ETL) data from various SAP and non-SAP sources using SAP data extraction methods such as LO Extractors, Generic Extractors, ABAP routines, and CDS Views.
6. Optimize data warehouse performance by monitoring data loads, query performance, and system resources, implementing tuning measures when necessary.
7. Optimize Power BI Reports performance by monitoring data loads and DAX/M queries, applying tuning measures as needed.
8. Integrate SAP BW/DW Cloud with other SAP components like SAP Analytics Cloud, HANA, or BPC for comprehensive reporting and analytics.
9. Ensure data quality and integrity through robust validation, archiving, and error handling processes.
10. Provide end-user support, training, and documentation.
11. Collaborate with SAP team members such as functional consultants, data architects, and ABAP developers for seamless SAP landscape integration.
12. Continuously improve BI solutions by staying current with industry trends, evaluating new tools, and recommending enhancements.

Qualifications

1. Three or more years of experience in SAP BW/Hana development, focusing on data modeling, ETL, performance optimization, reporting, and dashboards.
2. Bachelor’s degree in computer science, Information Systems, or related; Master’s preferred.
3. Understanding of data warehouse concepts like star schema, snowflake schema, and data modeling.
4. Proficient in SAP BW 7.x, SAP HANA native objects, BW/4HANA, or SAP Datasphere experience is a plus.
5. Proficient in Power BI, DAX, data modeling, and visualization techniques.
6. Solid knowledge of SAP data extraction methods, CDS views, ABAP, and SAP integration technologies such as SAP Analytics Cloud or BPC.
7. Experience with programming languages like Python or R is a plus.
8. Strong analytical, problem-solving, and communication skills, with the ability to explain complex concepts to non-technical stakeholders.
9. Ability to work independently and collaboratively in a fast-paced environment.
10. Expertise in navigating SAP systems for data extraction and validation, including querying and analyzing SAP data (e.g., SE16N, CDS views).
11. Proficiency in SQL query techniques, including complex queries, joins, subqueries, and performance optimization in SAP environments.
12. English required; French is a plus.

As a Stella-Jones team member, you will enjoy excellent benefits and incentives, including:

• Extended health and dental coverage
• Life insurance and AD&D
• Disability coverage
• Competitive salary
• Profit sharing
• Retirement plan (RRSP) with company match
• Share purchase program with company contribution
• Career advancement opportunities

Stella-Jones is an equal opportunity employer committed to diversity and inclusion. We prohibit discrimination and harassment based on race, color, sex, religion, sexual orientation, national origin, disability, or other protected characteristics. We make employment decisions based on qualifications, merit, and business needs.