Data Analyst Full-time Job
Sep 20th, 2024 at 13:22 IT & Telecoms Toronto 113 views Reference: 9259Job Details
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
Company Description
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.
