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.

 

Enroll Logo