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.