Data Analyst

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 www.bgis.com

 

SUMMARY 

Responsible to support the Construction Program Management Team – Collect, enter, analyze, manipulate, develop customized reports and dashboards, as well as create, maintain, and develop Program Management Tracking Tools, and report on internal and client data. Perform Administrative & Coordination activities to Support the Construction Program Management Team.

 

KEY DUTIES & RESPONSIBILITIES 

Data Management & Analysis

• Data Entry – Obtain from various sources such as design drawings, emails, excel documents etc and enter dates, scope, descriptions, costs, quantities etc. into various Program Management Tracking Tools (Master Trackers)
• Create complex formulas in Excel to facilitate the management and update of Tracking Tools, Budget Estimates, Spend Projections, RFQ Evaluations, Reporting and other documents as requested.
• Identifies opportunities to maximize data usage, applying modeling and optimization methods to develop new strategies and improve Program Management Tools.
• Identifies and troubleshoots any issues or anomalies related to various Program Management Tracking Tools and Reports.
• Responsible for ensuring Program Management Tracking Tools, graphs, pivots and other documents are functional, updated, relevant, customized and available for team use ongoingly.
• With inputs from the Program Management Team, defines data requirements and gathers and validates information, using judgment and statistical tests.
• Develops data structures and pipelines to organize, collect, cleanse, and standardize data in order to generate insights and addresses reporting needs

Administration & Coordination

• Performs administrative and coordination activities throughout the Program Life cycle such as requesting and preparing documents for quotes, PO’s, lien searches, Form 9s, invoices etc. Reviews information obtained, identifies issues, proposes solutions, and works with various stakeholders to rectify.
• Performs other administrative and coordination activities as requested by the Program Management Team.
• Uploads, files, names and organizes documents and information to various company and client systems.
• Works with Program Management Team to identify, document and implement process improvements.
• Prepare & issue client Project Notifications via email

KNOWLEDGE & SKILLS

• College Diploma or University degree in computer science, data engineering, actuarial science or equivalent with a focus on data management and/or Project Management.
• 2+ years strong Data Processing (alpha and numeric) experience using MS Excel
• 2+ years of experience in quantitative analysis, data modeling, reporting, and data-visualization
• Advanced skills in computer technology including Microsoft Office (Word, Excel, PowerPoint, Teams and Outlook)
• Ability to perform ad-hoc, strategic analysis of structured and unstructured data across multiple data sources
• Ability to define data requirements and gathers and validates information, using judgment and statistical tests.
• Well versed in knowledge of creating algorithms, identifying patterns and insights from structured and unstructured data sets utilizing graphs, trees and/or other data representation techniques as required.
• Experience in Corporate Real Estate, Construction or Project, Program Management would be considered an asset
• Process improvement experience (lean sigma, six sigma even at Greenbelt level) would be beneficial
• Experience in Data Governance would be an asset

Licenses and/or Professional Accreditation

• NA

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.