Our Valued Public Sector Client is seeking a Senior BI Developer to create custom reports and develop data warehouse functionalities from business specifications by designing and testing in SAP BI and Bex.

Must Haves: BI Developer (5+ years) SAP Enterprise System (5+ years) DRMIS BI requirements (5+ years) D BI requirements(5+ years) Tasks: Collect, collate, and prioritize client requirements from DRMIS, RDIMS and legacy systems required for BI tools and reporting requirements; Create standards for all SAP Business Objects (BOBJ), Share

Point, Teams, Power Platform, Microsoft (MS) Project, Analysis for Excel, Power BI, Portal and any DND approved application for reports / dashboards in D and ECC version or higher; Make recommendations for application automation for SAP BOBJ, Share

Point, Teams, Power Platform, MS Project, Excel, Power BI, Portal and any DND approved application that will enable BI reports / dashboards in D and ECC version or higher; Develop a data warehouse functionality from business specifications by designing, developing, and testing in SAP BI including Business Explorer (BEx); Identify issues with existing BI reports and provide prompt and accurate solutions in a timely manner; Provide support to users with creation and analysis of the ad hoc reports related to Plant Maintenance (PM), Material Management (MM)



and Cross Application Time Sheet (CATS); Provide training to users on BI related tools, application and reports as needed; Design frameworks for integrating legacy data and processes into DRMIS BI and D BI; Design frameworks and interface for integrating new data into DRMIS BI and D BI; Analyze and recommend alternatives and options for solutions within BOBJ, Share

Point, Teams, Power Platform, MS Project, Power BI, Portal and any DND approved application for reports / dashboards in ECC; Understand the impact of current processes within the organization and work with others to understand how these changes can affect BI within D; Work with the data integration teams to rectify BI related issues found in DRMIS and D; Analyze technical requirements to determine key integration points and detail data flow to automate BI information; Develop workflows and processes for data insertion that will be used to generate BI; Develop an Extract, Transform and Load (ETL) solution for the integration of legacy data into ECC version or higher.

Develop automated procedures of data acquisition from the data sources (PM/MM/CATS) and legacy systems (Plan Expert (PlannEX), Equipment Data Repository (EDR), Guardian and Fleet Management System (FMS)) that will be used to create BI;

📌 Senior BI Developer to create custom reports and develop data warehouse functionalities from business specifications by designing and testing in SAP BI and Bex. (Ottawa)
🏢 S.i. Systems
📍 Ottawa