Senior BI / Data Architect (10+ Years) to design and develop new cubes for a historical database and deploy Power BI reports on the server within the Public Sector

S.i. Systems
Ottawa
$41,24 an hour (estimated)
Full-time

Our Valued Public Sector Client is seeking a Senior BI / Data Architect (10+ Years) to design and develop new cubes for a historical database and deploy Power BI reports on the server

The consolidation and modernization of the various legacy system functions will drive readily actionable efficiencies and reduce the clients dependency on aging legacy system by providing a modern tool integrated with the programs current and future applications (MS dynamics, MS Power BI).

The contractor will analyze the historical database and add historical data and reports to the new reporting solution (Power BI).

The resource will also work with stakeholders of all levels, including DBA’s, program managers, business analysts, developers, and a range of other technical and non-technical partners and clients.

Must Haves :

  • Significant experience creating Power BI reports and dashboards
  • 5+ years experience integrating Power BI reports to SharePoint

Tasks :

  • Design and develop new cube for the historical database and deploy the Power BI reports on the server as per business requirements
  • Develop and maintain a comprehensive data model in support of the program's operations
  • Link Power BI reports to SharePoint document repository.
  • Support the business analysis process to ensure an integrated view and alignment to the objectives of the future business reporting needs
  • Creating a clear picture and help communicate the capability gaps that may impede business areas from maximizing the benefits or impact on other business areas that would migrate the program from achieving the desired business outcomes
  • Develop Cube and reporting products in MS Power BI based on business requirements.
  • Report progress of the project on an ongoing basis and at scheduled points
  • Manage the development of Cube and implement new reports on the reporting server.
  • 30+ days ago
Related jobs
S.i. Systems
Ottawa, Ontario

Senior SharePoint Online Developer to develop custom solution using the Power Platform, Azure functions and SPFx within a D environment. To support the configuration and development of the D environment for SPO (SharePoint Online) and the compliance and security center. The requirement will ensure M...

Promoted
Annex Consulting Group
Ottawa, Ontario

Our client has a requirement for the provision of IT Business, Innovation, Transformation, Project Management, Human resources, and Instructional/Training resources in support of the functional development, maintenance, and production support for legacy systems as well as any new systems that may co...

The Talent Company
Ontario, CA

Adaptability and Awareness: Comfort with ambiguity and fast-paced environments, combined with the ability to "read the room" and address complex situations using proven practices. Deliver Effective Compensation Support: Engage in compensation survey job matching, integrate compensation dat...

S.i. Systems
Ottawa, Ontario
Remote

Senior PMP, PROSCI Certified Project Manager to lead 3rd party vendors and internal resources through the migration of applications, and infrastructure, into a hybrid cloud environment (PM REMOTE). Proof of the certification shall be provided with the response. Proof of the certification shall be pr...

Treasury Board of Canada Secretariat
Ottawa, Ontario

The job opportunity you have selected requires the Public Service Commission (PSC) to transfer you to the hiring organization's Web site or a service provider Web site they have selected to advertise this process. Select the link below to be transferred from the PSC's GC Jobs Web site and be directe...

S.i. Systems
Ottawa, Ontario

Defining and documenting interfaces of manual to automated operations within internal business systems, to external systems, and between new and existing systems including connectivity to third party partners and clients. Performing business analysis of functional and systems requirements to identif...

Promoted
Ernst & Young Advisory Services Sdn Bhd
Ottawa, Ontario

Associated with these opportunities come risks, our clients seek independent advice and assurance over diverse issues which include for example: the design and operation of their internal controls, the security of their business critical systems, the delivery of major IT enabled programmes, their re...

Stafflink
Ottawa, Ontario

This role is perfect for someone passionate about building, developing and nurturing new and existing partnerships and client relationships, and could also be an exciting opportunity for anyone who has completed an education within political science or a related field. This includes the flexibility ...

Brookfield Renewable
Gatineau, Quebec

Develop and manage analytical tools and processes to improve the quality and transparency of financial results and forecasts and to facilitate ad hoc reporting;. Reporting to the Manager, Financial Planning and Analysis, the incumbent will be responsible for providing analysis and insights into the ...

Stevenson & White
Ottawa, Ontario

Job #4664 – An exciting opportunity for a technically strong Senior Financial Analyst to join a dynamic and growing organization! In this role, you will work closely with a great team of analysts as well as the Controller to provide financial support and analysis for senior finance leaders. If you c...