Job Description

  • Tasks
    • The Contractor’s resource will perform tasks that may include, but are not limited to the following:
      1. Collect, collate, and prioritize client requirements from DRMIS, RDIMS and legacy systems required for BI tools and reporting requirements;
      2. Implement the technical specifications in D365 and ERP Central Component (ECC);
      3. Create standards for all SAP® Business Objects (BOBJ), SharePoint, Teams, Power Platform, Microsoft (MS) Project, Analysis for Excel, Power BI, Portal and any DND approved application for reports / dashboards in D365 and ECC version or higher;
      4. Make recommendations for application automation for SAP® BOBJ, SharePoint, Teams, Power Platform, MS Project, Excel, Power BI, Portal and any DND approved application that will enable BI reports / dashboards in D365 and ECC version or higher;
      5. Analyze, validate, and document BI requirements for all D365 tools, SAP® BOBJ, SharePoint, Teams, Power Platform, MS Project, Excel, Power BI, Portal and any DND approved application
      6. Document the BI process for DRMIS and D365;
      7. Develop a data warehouse functionality from business specifications by designing, developing, and testing in SAP® BI including Business Explorer (BEx);
      8. Identify issues with existing BI reports and provide prompt and accurate solutions in a timely manner;
      9. Provide support to the DGLEPM users with creation and analysis of the ad hoc reports related to Plant Maintenance (PM), Material Management (MM) and Cross Application Time Sheet (CATS);
      10. Provide training to DGLEPM users on BI related tools, application and reports as needed;
      11. Design frameworks for integrating legacy data and processes into DRMIS BI and D365 BI;
      12. Design frameworks and interface for integrating new data into DRMIS BI and D365 BI;
      13. Analyze and recommend alternatives and options for solutions within BOBJ, SharePoint, Teams, Power Platform, MS Project, Power BI, Portal and any DND approved application for reports / dashboards in ECC;
      14. Understand the impact of new processes within the organization and work with others to understand how these changes can affect BI within D365;
      15. Work with the data integration teams to rectify BI related issues found in DRMIS and D365;
      16. Analyze technical requirements to determine key integration points and detail data flow to automate BI information;
      17. Develop workflows and processes for data insertion that will be used to generate BI;
      18. Develop an Extract, Transform and Load (ETL) solution for the integration of legacy data into ECC version or higher.
      19. 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;
      20. Advise users on the efficient use of data within DRMIS and D365;
      21. Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in DRMIS and D365 to generate BI;
      22. Ensure tests are conducted that the BI is working properly prior to delivery in accordance to the technical requirements; and
      23. Develop and implement data quality assurance standards.

MT.1

The Bidder must demonstrate that the proposed resource has a minimum of sixty (60) months of experience, within the last one-hundred and twenty (120) months, using Microsoft Power Business Intelligence (BI) as a developer.

· Name and description of client organization and relevant experience;

· Timeframe (from-to dates month/year);

· Description of the roles and responsibilities for each project;

· Detailed example(s) demonstrating the relevant experience; and

· Reference* (Name, phone number and email address) for each project

MT.2

The Bidder must demonstrate that the proposed resource has a minimum of sixty (60) months of experience, within the last one-hundred and twenty (120) months, using SAP Enterprise System as a developer.

· Name and description of client organization and relevant experience;

· Timeframe (from-to dates month/year);

· Description of the roles and responsibilities for each project;

· Detailed example(s) demonstrating the relevant experience; and

· Reference* (Name, phone number and email address) for each project

* Reference checks will only be conducted to confirm the information provided, such as task types, completion verification, and adherence to timeline.



We thank all applicants for their interest; however, only those selected for an interview will be contacted.

In accordance with Ontario's Pay Transparency laws, Turtle Island Staffing is committed to providing clear and accessible information regarding compensation. Actual compensation may vary based on experience and qualifications.

At Turtle Island Staffing, we believe hiring should be human-led. We do not use artificial intelligence to screen out applicants. Every application is reviewed by a real person, because people deserve to be seen as more than keywords.

Details

Employee Type
Contract Full-Time
Location
ON - Ottawa
Language Requirement
English
Date Posted
5/08/2026

Position Id
EB-1826580405