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.