Business Intelligence (BI) Developer

Stella-Jones is seeking an experienced and highly skilled Business Intelligence Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining SAP Business Warehouse (BW) / Data Warehouse Cloud solutions and Power BI Reports that support data-driven decision-making and drive business growth. If you have a strong background in SAP BW and/or SAP Data Warehouse Cloud and/or Power BI and a passion for leveraging technology to create innovative solutions, we would love to hear from you.

Responsibilities:

  • Collaborate with stakeholders to gather and understand business requirements, translating them into functional and technical specifications for SAP BW / DW Cloud solutions and Power BI.
  • Design, develop, and maintain SAP BW objects, including InfoObjects, InfoCubes, DataStore Objects (DSOs), Process Chains, etc.
  • Design, develop, and maintain SAP Hana Native Objects such as calculation views and SQL Scripts.
  • Design, develop, and maintain SAP DW Cloud 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.

Requirements:

  • Bachelor’s degree in computer science, Information Systems, or a related field; a Master's degree is a plus.
  • Minimum of 3 years of experience in SAP BW/Hana development, with a strong focus on data modeling, ETL, and performance optimization, reporting, and dashboard creation.
  • Understanding of Data Visualization techniques and data storytelling
  • Understanding of data warehouse concepts, such as star schema, snowflake schema, and data modeling.
  • Proficient in SAP BW 7.x and experience with BW/4HANA or SAP DWC is a plus.
  • Proficient in modeling SAP Hana native objects such as calculation views and SQL scripts.
  • Proficient in Power BI/ DAX report development, data modeling, and visualization
  • Solid knowledge of SAP data extraction methods. Experience in CDS views modeling and ABAP Programming is a plus
  • Experience with programming languages like Python or R is a plus.
  • Familiarity with SAP integration technologies, such as SAP Analytics Cloud, or BPC.
  • 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.

 

Apply on this job

3100 Boulevard Cote Vertu Ouest #300, Saint-Laurent, QC H4R 2J8, Canada

Apply on this job

Related job offers

Technical Leader - Automation Manufacturer

Technical Leader – Operational Technology (OT) 📍 Position based in Quebec City, Trois-Rivières, or Montreal (Saint-Laurent district)🕒 Permanent – Full-time Do you have solid technical expertise and want to play a key role in the design and...

Technical leader in automation (OT)

Technical Lead – Operational Technology (OT) 📍 Position based in Quebec City, Trois-Rivières, or Montreal (Saint-Laurent borough)🕒 Permanent – Full-time Do you possess strong technical expertise and want to play a key role in the design and...

Physiothérapeute

VOTRE RÔLEQuel sera votre impact en tant que Physiothérapeute à l’ÉTS?Vous serez responsable de planifier, coordonner, contrôler les programmes et les activités clinico-administratives relatives à la gestion du service de réadaptation, comprenant...

Technology Architect and IT Project Manager

CA$95,000.00 to CA$115,000.00 per year

***You must be a resident of the Quebec City or Montreal area, as this is an on-site position.*** Who are we? With over 15 years of experience and more than 15 clinics regionally, two operating rooms, over 125 physicians, and over 250 employees,...

Network and Systems Support Technician - Laval

CA$62,400.00 to CA$72,800.00 per year

***You must be a resident of Laval (or nearby), as this is an on-site position.*** Who are we? With over 15 years of experience and more than 17 clinics regionally, two operating rooms, over 125 physicians, and over 250 employees, Lacroix Private...

Responsable robotique

JL Leclerc est une entreprise spécialisée dans la conception, la fabrication et l’assemblage de pièces et de produits mécano-soudés dédiés principalement aux industries de l’énergie et du transport. JL Leclerc est en pleine croissance et souhaite...