Business Intelligence Developer

Business Intelligence Developer

Location Ottawa, ON
Start Date April 1, 2019
Security Clearance Secret
Duration 1+ year
Date Posted February 27, 2019
Job ID 11422-1

Maplesoft Group is currently seeking a Business Intelligence Developer to join one of our clients located in Ottawa

The Business Intelligence (“BI”) Developer shall adapt existing BI reporting to work with several applications that are undergoing upgrades or replacements.

Tasks include but are not limited to:

- Meet with stakeholders to gather and document requirements;
- Translate user requirements to the corporate BI requirements template;
- Assess data mart and/or subject area, make recommendations for any re-design that may be required and assist in the specification process of the Extract, Transfer, and Load (“ETL”) re-design;
- Source the required data needed to support the requirements or develop alternate methods for sourcing data that is not readily available;
- Design and build and/or change appropriate database objects, warehouse builds, ETL jobs, Online Analytical Processing (“OLAP”) models, and user-friendly reporting that meet specifications;
- Design and build and/or change the appropriate changes to database objects, OLAP models, Cognos Framework Manager models and reports to support the ETL changes;
- Create reusable objects and techniques to support the Data Warehouse bus architecture. e.g. surrogate ID creation, slowly changing dimension, hierarchy creation, standard dimension and fact table creation;
- If feasible, incorporate the Data Management group’s implementation of Master Data into BI projects;
- Update metadata repository with metadata for purposes of data lineage;
- Update Business Glossary with business terms and business rules in the repository;
- Perform unit testing and assist in end user testing and certification of the solution;
- Perform project specific reporting support to the following system under deployment such as but not limited to: MacH, HBS XLB and CTX data;
- Provide weekly progress reports; and
- Complete thorough documentation of the work performed (for example: Report, Framework Manager and ETL documentation and any process documentation) including:
- A document containing all technical specifications, instructions,  and  support related information for all development or configuration work performed; and
- Any other activities or sub-projects, such as dashboard development, assigned at the discretion of the Manager of Business Intelligence.

Maplesoft Group prides itself on its distinct corporate culture and recognizes that success is a direct reflection of our most valuable asset - our people.  Therefore, attitude and ambition are key personality traits we seek out, along with skill and aptitude, in potential employees.

We thank you for your interest in Maplesoft Group and wish to advise that only candidates under consideration will be contacted.

Contact Recruiter: