Business intelligence developer Jobs in Markham, ON

Workforce Intelligence Analyst – Markham, ON. - Full Time – ID# 7200

Are you ready to make an impact in the major Capital Projects Industry? Join PTAG, a leading Project Management Advisory & Services firm, recognized across North America for helping world-class clients deliver major capital projects successfully.

We are seeking a Workforce Intelligence Analyst to support our growing team in Markham, ON. In this role, you’ll play a key part in driving project excellence, collaborating with industry leaders, and ensuring high-quality outcomes across complex initiatives.

About PTAG
At PTAG, we help our clients plan, manage, and execute their most challenging projects with innovation, integrity, and collaboration.
Our mission is to help our clients achieve successful delivery and efficient operation of their capital projects.
Our vision is to support global leaders in the selection, planning, and execution of their major initiatives.
Our values include:

• Safety: The safety of our employees, suppliers, and clients is always the top priority.
• Collaboration: We build true partnerships with clients and service providers.
• Leadership: We elevate project performance through the application of best practices.
• Accountability: We take responsibility for every aspect of our engagements.
• Client Satisfaction: We strive for 100% satisfaction on every project.
• Integrity: We believe in open and transparent communication at all levels.

Role & Responsibilities:

The Workforce Intelligence Analyst reports directly to Senior Director, Workforce Development and works closely with Senior Advisors. The role combines workforce analytics, data management, business intelligence, and statistical analysis to identify workforce trends, skill and competency gaps, talent availability, capacity constraints, and future workforce requirements.

• Design and build the initial data architecture for the labour intelligence data lake, structured around the KSBA framework (Knowledge, Skill, Behaviour, Attitude) and aligned to NCCER, CII, PMI, and AACE credentialing standards.
• Build and maintain data pipelines that ingest, clean, and structure competency and availability data from disparate sources into a consistent, analysis-ready model.
• Apply data science and statistical methods — forecasting, clustering, classification, and other predictive techniques.
• Define and maintain data standards, taxonomies, and definitions across every source feeding the data lake, and document architecture and lineage clearly.
• Embed data capture protocols directly into Pillar 1 advisory engagement templates so every demand profile, gap analysis, sourcing plan, and training outcome is captured systematically from the first client engagement onward.
• Own data quality and completeness against the practice's KSBA-scored records targets.
• Partner directly with Senior Advisors to ensure competency-level data is structured and captured correctly at the source, and translate analytical findings into plain-language input they can use with clients.
• Work with Legal and the COO to implement the four-tier data classification.
• Lay the data-architecture and analytics groundwork workforce intelligence dashboard.
• Track and report data lake growth, quality, and coverage against the practice's milestone gates.
• Train and support Senior Advisors and other internal users on how to query, interpret, and apply the data lake and any early dashboards or models

Required Qualifications

• Bachelor's degree in Data Science, Statistics, Business Analytics, Computer Science, Economics, Human Resources, Mathematics, Industrial Engineering, or a related quantitative discipline.
• Minimum 8 years of experience in workforce analytics, people analytics, business intelligence, data analytics, labour-market intelligence, data science, or a related field.
• Experience analyzing large and complex datasets and translating findings into actionable business recommendations.
• Experience working with workforce, project-resource, competency, or labour-market data is preferred.
• Experience within engineering, construction, infrastructure, utilities, energy, manufacturing, or other project-based industries is considered an asset.

Technical Skills

• Strong proficiency in SQL for data extraction, transformation, and analysis.
• Experience with Python and/or R for data analysis, statistical modeling, automation, and predictive analytics.
• Strong experience with Power BI, Tableau, or comparable business intelligence and visualization platforms.
• Advanced Microsoft Excel skills.
• Understanding of data modeling, relational databases, data warehouses, data lakes, ETL processes, and data integration principles.
• Knowledge of descriptive statistics, forecasting, segmentation, clustering, classification, trend analysis, and predictive analytics.
• Familiarity with HRIS, ATS, ERP, PMIS, workforce management, or related enterprise systems is an asset.

Core Competencies

• Strong analytical and problem-solving capabilities.
• High attention to detail and commitment to data accuracy.
• Ability to interpret complex information and identify meaningful workforce trends.
• Strong written and verbal communication skills.
• Ability to communicate technical findings clearly to non-technical stakeholders.
• Strong business acumen and understanding of how workforce capacity affects organizational and project performance.
• Ability to manage multiple priorities and work independently in a fast-paced environment.
• Strong commitment to confidentiality, responsible data use, and data governance.

Salary Range for Role $ 150 -$155 + bonus
Compensation at PTAG varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set and level of experience.

Why Join PTAG?
At PTAG, you’ll be part of a dynamic, growing consulting firm that values professional development, collaboration, and innovation.
Opportunity to work on major infrastructure and capital projects.

• Exposure to industry-leading clients and partners.
• Competitive compensation and comprehensive benefits package.
• Flexible work environment and opportunities for advancement.
• Employee Share Purchase Plan (ESPP).
• A culture that values safety, accountability, and excellence.

PTAG is proud to be an equal opportunity employer committed to fostering a diverse and inclusive workplace.


PTAG uses AI-enabled tools to support certain aspects of the recruitment process, including reviewing applications against job-related criteria. These tools are used to assist our recruiters. All hiring decisions are made by PTAG recruiters and hiring managers.