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 ever- expanding footprint provides a great prospect for career advancement as we seek to 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 is an excellent career opportunity for an individual 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:
Collaborate with stakeholders to gather and understand business requirements, translating them into functional and technical specifications for SAP Datasphere, HDI solutions and Power BI.
Design, develop, and maintain SAP Hana Native Objects such as calculation views and SQL Scripts.
Design, develop, and maintain SAP Datasphere objects, including SAP BW Bridge Objects / Analytic Models / Views / Consumption Models / Perspectives / etc.
Design, develop, and maintain BI reports and dashboards including DAX development, Power Query, data modelling, and visualizations in Power BI
Extract, transform, and load (ETL) data from various SAP and non-SAP sources using SAP data extraction methods, such as LO Extractors, Generic Extractors, and ABAP routines and CDS Views
Optimize the data warehouse performance by monitoring data loads, query performance, and system resources, implementing appropriate tuning measures when necessary.
Optimize Power BI Reports performance by monitoring Data loads and Dax/M Queries, implementing appropriate tuning measures when necessary.
Integrate SAP BW/DW Cloud with other SAP components, such as SAP Analytics Cloud, HANA, or BPC, to deliver comprehensive reporting and analytics solutions.
Ensure data quality and integrity by implementing and maintaining robust data validation processes, data archiving strategies, and error handling mechanisms.
Provide end-user support, training, and documentation.
Collaborate with other SAP team members, such as functional consultants, data architects, and ABAP developers, to ensure seamless integration of SAP BW solutions into the overall SAP landscape.
Continuously improve BI solutions by staying current with industry trends, evaluating new tools and technologies, and recommending enhancements
Qualifications
Three (3) or more years of experience in SAP BW/Hana development, with a strong focus on data modeling, ETL, and performance optimization, reporting, and dashboard creation.
Bachelor’s degree in computer science, Information Systems, or a related field; a Master's degree is a plus
Understanding of data warehouse concepts, such as star schema, snowflake schema, and data modeling.
Proficient in SAP BW 7.x and modeling SAP HANA native objects (e.g., calculation views and SQL scripts), with experience in BW/4HANA or SAP Datasphere being a plus.
Proficient in Power BI/ DAX report development, data modeling, and visualization, with an understanding of data visualization techniques and data storytelling.
Solid knowledge of SAP data extraction methods, with familiarity in CDS views modeling, ABAP programming, and SAP integration technologies such as SAP Analytics Cloud or BPC.
Experience with programming languages like Python or R is a plus.
Strong analytical, problem-solving, and communication skills, with an ability to explain complex technical concepts to non-technical stakeholders.
Ability to work independently and collaboratively in a fast-paced, dynamic environment.
Strong expertise in navigating and extracting data from SAP systems, including the ability to identify relevant tables, understand data structures, and validate data accuracy. Must be capable of independently querying and analyzing SAP data (e.g., using SE16N, CDS views) to support BI reporting and analytics.
Proficient in SQL query techniques, including writing complex queries for data extraction, transformation, and validation. Must have experience with joins, subqueries, aggregations, and performance optimization in relational databases. Hands-on experience with SQL in SAP environments (such as HANA, BW, or SAP tables) is highly preferred
English required; French is a plus
As a Stella-Jones team member, you will enjoy access to excellent benefits and incentives, including:
Extended health and dental coverage
Life insurance and accidental death & dismemberment (AD&D)
Short-Term and Long-Term disability coverage
Competitive compensation
Annual Profit Share Program
Retirement program (RRSP) with generous Company match (150% of employee's 4% contribution)
Company Share Purchase Program with 10% Company contribution match
Career advancement opportunities
Stella-Jones is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, provincial, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. Stella-Jones makes hiring decisions based solely on qualifications, merit, and business needs at the time.
