Sql analyst Jobs in Ottawa, ON

Who We Are

BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6, 500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over 320 million square feet of client portfolios across 30,000+ locations in North America, Europe, Middle East, Australia and Asia. Further information is available at

SUMMARY

The Business Analyst role will lead / support the identification and development of Innovation Scenarios for the Account in direct support of all LOB across the Client Account. This role will support in the development and implementation of Innovation Scenarios of behalf of the Account Leadership, with a strong focus on continuous improvement of key business process, systems and tools implementation.

KEY DUTIES & RESPONSIBILITIES

• Generates and compiles data from multiple data sources using various business intelligence tools and information management systems.
• Compiles, maintains and analyzes large volume of real estate portfolio data to support various reporting, benchmarking and analytical requirements in pursuit of Innovation Scenarios.
• Prepares various reports including but not limited to performance reports and scorecard reports to assist with business communication and decision making.
• Performs calculations and analysis to fulfill requirements including but not limited to performance reporting, occupancy cost allocation and chargeback, budget to spend variance reporting.
• Supports the development of a measurement system and / or tool to assess awareness, understanding, buy-in and support of change management activities.
• Interface with relevant concerned parties to understand business process related issues and to facilitate innovative solutions to traditional problems. Liaises with information technology system administrators (Computer Maintenance Management System, Annual Building Inspection, and Oracle Financials) to resolve field issues, as required.
• Train field personnel and system users in the correct operation of business tools, processes and procedures.
• Perform ad hoc audits and reporting of key business issues pertaining to client operations.
• Develop and distribute key process metrics and information to internal customers.
• Other duties as assigned.

KNOWLEDGE & SKILLS

Licenses and / or Professional Accreditation

This is a regular, full-time position with a salary range of $75,374 - $94,218 per annum. The starting salary will be based on the successful candidate’s competencies, including but not limited to experience, education and performance related to this role.

BGIS is an equal opportunity employer and we welcome you to apply for a position with us! If you require accommodation during the recruitment process, please contact us at askHR. Upon request for accommodation, we will consult with the applicant in question and provide, or arrange for the provision of, a suitable accommodation in a manner that takes into account the applicant’s accessibility needs due to disability.

BGIS est un employeur qui respecte l'égalité des chances et nous vous invitons à postuler pour un poste chez nous ! Si vous avez besoin d'un accommodement pendant le processus de recrutement, veuillez nous contacter à askHR. En cas de demande d'accommodement, nous discuterons avec le candidat en question et fournirons, ou ferons en sorte de fournir, un accommodement approprié d'une manière qui tiendra compte des besoins d'accessibilité du candidat en fonction de son handicap.