BI & Reporting Analyst

About UsThe Technical Standards and Safety Authority (TSSA) is deeply committed to safety and passionate about making Ontario a safer place to live, work, and play. Our unified team - what we proudly call ONE TSSA – works collaboratively to deliver better safety for our province.TSSA is a not-for-profit regulator that has dedicated over 25 years of expertise and experience to the safety of Ontario. Mandated by the Government of Ontario, TSSA’s team of over 450 professionals works to enhance public safety across multiple sectors we regulate.As an award-winning organization, TSSA firmly embeds safety in our culture and all aspects of our work. Fostering a strong safety culture has earned us the 5-Star Safety Cultures Award from Canadian Occupational Safety magazine for three consecutive years (2022-2024).As ONE TSSA we are guided by the following values in all we do:Safety: Be safety-focused at all timesCollaboration: Work well with othersAccountability: Take responsibility for our actions and deliver on our commitmentsIntegrity: Conduct ourselves transparently using risk-informed evidenceInclusion: Embrace diversity through respectful leadershipInnovation: Be forward-thinking, adaptable, and data-drivenJoining TSSA means becoming part of a team of experts from diverse fields, backgrounds, and cultures. It’s an opportunity to hone your skills, expand your knowledge, build a rewarding career, and realize your full potential.Position SummaryThe Data Analyst supports the organization’s data and analytics by analyzing data, improving data quality, and enabling data-driven decisions. The role translates business needs into actionable insights, develops metrics, and maintains tools and reports that support operational and strategic priorities.Job ResponsibilitiesAnalyzes structured and unstructured data to identify trends and generate insights that support operational and strategic decisions.Documents current state data processes and requirements to inform improvements in reporting and analytics.Collaborates with business teams to define meaningful metrics and develop proof-of-concept models.Designs and builds reports and dashboards using Power BI to support business-critical functions.Writes and maintains SQL scripts to automate data cleansing, transformation, and validation processes.Supports data migration activities by validating data integrity and resolving defects during system transitions.Applies data profiling techniques to assess data quality and support governance and cleansing initiatives.Presents findings and recommendations to stakeholders across all levels of the organization.Works with data transformation tools and ETL processes to support reporting and analytics development.Stays current on AI and advanced analytics trends and applies relevant techniques to improve business intelligence.Job QualificationsA Bachelor’s degree in Computer Science, Mathematics, Statistics, Engineering or a related quantitative field.Minimum 4 years of experience in a data/business analysis, or report developer role.Experience with Power BI, Microsoft Dynamics 365, Azure Data Factory, and Synapse or similar tools.Expert-level proficiency in SQL (T-SQL or PL/SQL) and Excel for data manipulation and analysis.Solid understanding of data modelling, ETL concepts, and query optimization.Demonstrated ability to translate business needs into data solutions and metrics.Knowledge of data hygiene, data cleansing, governance, and transformation practices.Excellent communication and documentation skills to convey complex data insights clearly.Inclusion And Equal Opportunity EmploymentTSSA is an equal opportunity employer committed to diversity and inclusion. We are committed to building and maintaining collaborative, caring and positive work environments so that our employees bring their whole selves to work each and every day. We encourage all qualified applicants to apply without regard to race, national or ethnic origin, colour, religion, age, sex, sexual orientation, marital status, family status or disability. Only those selected for an interview will be contacted.TSSA is pleased to offer accommodations for applicants with disabilities. If you are interested in applying for a job opportunity, or are contacted by us regarding a job opportunity, please advise of any accommodations you may require.This job posting is for an existing vacancy within TSSA. We are actively seeking a qualified candidate to fill the current position. We encourage all interested applicants to apply.TSSA uses AI to support screening of pre-screening question responses. Even if an application is flagged by the system, our team endeavours to review all candidates’ qualifications and experience.