19 Nov
|
Infrastructure Health and Safety Association
|
Etobicoke
19 Nov
Infrastructure Health and Safety Association
Etobicoke
JOB OPENING– POSTING #FIN2026-01
Data Architect & Report Analyst
The Infrastructure Health and Safety Association (IHSA) is part of Ontario’s health and safety system, which includes the Ministry of Labour, Immigration, Training and Skills Development (MLITSD), the Workplace Safety and Insurance Board (WSIB), and six health and safety associations. IHSA is a leader in health and safety education. Through skills-based training, auditing, and evaluation, we provide safety solutions to those who perform high-risk activities. Our goal is to support safe and healthy workplaces free from incidents, injuries, illnesses or fatalities.
Interested in learning more about who we are and what we do? Check out our podcast series: IHSA Podcast - IHSA Podcast (ihsasafetypodcast.ca)
Why should you join our team?
- Competitive salary with a defined-benefit pension plan for our employees.
- Comprehensive advantages package including life insurance coverage; dental plan, extended health care, and disability leave coverage.
- Support for personal and professional growth and development, tuition assistance and membership reimbursement, with an opportunity for potential career advancement.
- Start at 3-weeks vacation, paid holiday shutdown, wellness days, and discounted gym membership as well.
- A meaningful, rewarding, and challenging career opportunity to make a positive impact in the health and safety industry.
POSITION SUMMARY:
Reporting to the Manager, Finance, the Data Architect & Report Analyst is responsible for the organization's overall data architecture, integration and reporting services. The Data Architect and Reporting Analyst ensures that data and reports are accurate, providing business groups with key information to support business processes and inform organizational decision making. This is completed by utilizing data design, integration, statistical and analytical techniques and reporting software.
DATE OF POSTING: November 16, 2026
LOCATION: 21 Voyager Court South, Etobicoke, ON M9W 5M7 (Corporate Office)
NUMBER OF VACANCIES: 1 Existing Vacancy
SALARY: $98,320.70– $115,747.99
RESPONSIBILITIES:
Data Architect, Development and Implementation of Databases:
- Collaborates with business departments and IT project teams to design, develop, and implement new/enhanced databases. Extensive analysis needed as department data and integration requirements elicited may need extending to organizational-level needs and business systems.
- Develops data architecture strategies and frameworks to maintain high data quality, security, and availability by collaborating with IT and business teams to understand data requirements and the required data workflows.
- Accountable for setting data standards, defining data architecture, and engaging data flows for IHSA's data.
- Reconciles IHSA data and assists in conducting configuration audits to ensure adherence to governance standards.
- Creates and maintains documentation related to data architectures, flows, and models while researching, evaluating,
and recommending integration tools and technologies to enhance data processing capabilities.
Data Integration Services and Business Intelligence:
- Design, analyze, implement, and maintain data integration solutions that consolidate data from multiple sources, ensuring consistency and quality across various IHSA database systems and WSIB data. Integrated data supports IHSA business systems, processes, and services to members and requires developing and maintaining data definitions, technical methods, and services to extract, transform, and load data from multiple systems.
- Collects, cleans, and preprocesses large datasets from various sources to prepare them for import/ integration. Ensures that business logic/rules and needed business intelligence is applied and consistent across all systems when data is integrated.
- Develops reusable and automated scripts and programs to integrate the data import and export of the IHSA systems.
- Conducts control gap analyses to identify root causes of data inconsistency and identifies remedial actions to maintain data integrity.
- Develop and Document integration processes, data mappings, and data flow diagrams to facilitate knowledge sharing and troubleshooting, enhancing organizational data governance.
Report Building and Analysis:
- Gathers and analyzes business requirements to develop and maintain reports and data exports for business decision-makers to address challenges and improve decision-making.
- Develops end-to-end designs of data reporting, and analytics solutions by translating user business requirements into technical specifications.
- Collects, cleans, and preprocesses large datasets from various sources to prepare them for reporting and analysis (e.g., WSIB injury reports).
- Analyzes data using statistical and analytical methods to uncover patterns and trends, presenting insights that assist business decision-makers in solving challenges and improving decision-making.
- Develops ad hoc reports for business processing and maintains quarterly financial and performance reporting data required to meet IHSA's Transfer Payment Agreement (TPA) requirements.
Maintenance and Issue Resolution:
- Monitors data integration workflows to proactively identify and resolve errors, ensuring data integrity and availability across IHSA systems.
- Monitors database query performance, request and query conflicts, and ensures effective configuration, capacity, and business transaction logic.
- Performs A/B testing and validates analytical model performance to ensure the accuracy of forecasts and business information.
- For identified integration or business logic issues,
track and trace root cause and provide resolution/recovery action steps.
QUALIFICATIONS:
- Undergraduate Computer Science degree with a concentration in statistical/data analytics or equivalent combination of education and experience required.
- Minimum of 6 years related experience, including quantitative analysis experience, such as handling, manipulating and analyzing data, and creating analytical reports.
- Specialized knowledge of SQL, Microsoft SQL Server Integration Services (SSIS), Cognos, Power BI, Azure, Dynamics365, Reporting Services (SSRS) and Analysis Services SSAS environments.
- Certification in analytics, statistics or business intelligence/analysis considered an asset.
- Knowledge of the health and safety industry/network is an asset, including WSIB performance data.
- 75% minimum interview score required for consideration.
REPLY TO: Human Resources
JOB CLOSING DATE: November 30, 2026
IHSA is committed to foster a workforce that reflects the communities we serve and to promote fairness, equity, dignity, and respect. We value diversity and show due consideration for each other’s opinions, perspectives and uniqueness that creates an all-inclusive work environment where everyone can contribute to their full potential.
IHSA is committed to providing equal opportunity to qualified individuals wishing to join the Association. IHSA will provide accommodation to applicants with disabilities throughout the assessment, selection and recruitment process. Applicants requesting accommodation are asked to advise Human Resources of the nature of accommodation that is required.
IHSA is committed to transparency in our hiring practices. Please be advised that we may use artificial intelligence (AI) technology to assist in screening, assessing, or selecting applicants during the recruitment process.
Thank you for your interest in IHSA. To be considered for this competition, applicants must include a resume clearly identifying how they meet the qualifications as outlined in this position and be forwarded to Human Resources no later than the date on the job closing. Applications should also include a cover letter and reference the posting #FIN2026-01. This information will be used as part of the selection process. We appreciate the interest of all applicants, however, only candidates selected for an interview will be contacted.
Job Types: Full-time, Permanent
Pay: $98,320.70-$115,747.99 per year
Benefits:
- Company pension
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- Tuition reimbursement
- Vision care
Application question(s):
- Have you completed a undergraduate Computer Science degree with a concentration in statistical/data analytics?
- Do you have a minimum of 6 years related experience, including quantitative analysis experience, such as handling, manipulating and analyzing data, and creating analytical reports?
Work Location: Hybrid remote in Etobicoke, ON M9W 5M7
📌 Data Architect & Report Analyst (Etobicoke)
🏢 Infrastructure Health and Safety Association
📍 Etobicoke