Reporting Engineer

Position: Reporting Engineer Department: AS Info System Support - Data Operations Position Status: Temporary (Fixed Term) Time Type: Full time Temporary Contract End Date: 2028-03-31 Non- Union Location: Remote ON Language: English Salary Range: $50.07 - $62.59 per hour THE PRHC DIFFERENCE: Peterborough Regional Health Centre (PRHC) is a regional hospital delivering acute healthcare to a rapidly growing population of more than 300,000 in Peterborough and the surrounding communities, including the First Nations of Curve Lake, Hiawatha and Alderville. With an annual budget of nearly $390 million, and a proud local history extending back over a century, PRHC has nearly 500 inpatient beds and offers a wide range of services, including specialized programs in renal, stroke, cardiac, cancer care, vascular surgery and mental health & addictions. PRHC is located in Peterborough, Ontario, Canada a 90-minute drive north-east of Toronto. We are the region’s largest employer with more than 3,100 staff, 450 physicians with privileges, and a core group of 250 volunteers. As a member of the PRHC team, you will be part of an exceptional working environment – a forum to share knowledge, to lead and learn, to develop talents, relationships and careers, and a culture that recognizes and celebrates the efforts and achievements of its people. PRHC is proud to be recognized as one of the top 20 employers nationwide in the healthcare and social services category, and 199 overall among 300 Canadian employers across all sectors, on the Canada’s Best Employers list released by Forbes in 2025. What We Offer We're committed to supporting our people with meaningful rewards and experiences, which may include: A competitive total rewards package aligned with the position Pension plan with employer contributions for eligible roles Health, wellness, and lifestyle perks, including fitness memberships and travel savings On site gym 24/7 free to all employees Ongoing learning and development opportunities to support your growth HOURS OF WORK: The stated hours of work are approximate as schedules are subject to change with the operational needs of the Health Centre. Changes made to hours of work will follow the terms of the applicable collective agreement, company policy and/or legislation. WHAT YOU’LL DO: Reporting to the Director, Data Operations, the Reporting Engineer is responsible for (a) Creating compelling and highly usable dashboards and reports to support branches across the PRHC (b)Helping set up the BI and reporting standards and facilitate adherence to the same (c) Setting up a highly engaged BI, Data visualization and reporting community at the PRHC (d) Developing, managing and monitoring all organization ETL/ELT processes and procedures The Reporting Engineer Role must be: An expert in PRHCs standard BI/ Reporting tool – Power BI A creative thinker with an ability to see and understand the end users’ vision, even when initial requirements may be vague or non-specific. Able to engineer new data assets (data transformations) to ensure highly responsive products that minimize performance strain and data security risks using various delivery tools. Inspire and motivate the user group and help with extending the usage of BI, reporting and data driven activities at the PRHC A quick learner and a very hands-on individual with adept understanding of not only industry reporting techniques, but a willingness to develop deep contextual and domain knowledge across several functions and data sources WHAT YOU’LL BRING: Strong reporting and dashboard building skills using Power BI. Minimum of 5 years of experience creating dashboards and reports using BI Tools (Tableau, Qlik, Power BI etc.) Operational experience in working with a variety of business data sets, and deriving valuable key performance indicators (KPIs)/Metrics Experience and in Data Warehousing, ETL, Data Management, Cloud Environments Advanced proficiency and experience working with data (structured and unstructured) business intelligence, analytics and reporting tools, such as: Tableau, Power BI, Python, or other SQL platforms. Strong proficiency with SQL, Python, Spark Adept in operating in cloud-based data platform, preferably Microsoft Azure (Azure Data Factory, Synapse, ALDS, Fabric) Familiarity and experience working with Data Lakes, and specifically Lakehouse formations Passion to convey complex business “stories” through data visualization Ability to use data, research, and experience develop engaging and intuitive data products and reports Skilled negotiator and communicator with superior written and verbal communication skills Advanced critical thinking, analytical and decision-making capabilities Self-starter with excellent leadership abilities to self-guide complex work A demonstrable passion for user experience, digital design, and technology Results oriented and deadline driven with an ability to multi-task, set priorities, coordinate and schedule effectively Familiar with Agile Methodologies, ideally having worked in an Agile team setting WHO YOU ARE: Undergraduate degree in STEM programs, including Mathematics, Computer Science, Computer Engineering, Business or other related discipline or 5+ years of relevant experience in Business Intelligence and Reporting Certificates or diplomas in technical areas, such as networking, cybersecurity, or systems administration Completion of training programs or courses related to project management, leadership, or communication Additional technical certifications or training, such as those offered by vendors or industry association Five plus years of experience in the Data & Analytics industry, with increasing levels of responsibility over time. This experience should ideally include technical roles, such as Data Engineering or Data Visualization, as well as leadership or management positions. Able to communicate effectively with various stakeholders Azure/AWS/GCP Certifications an asset Project Management Professional (PMP) an asset Certified ScrumMaster (CSM) an asset This position is for a current vacancy. OUR COMMITMENT: At PRHC, we take great pride in maintaining an inclusive culture of respect and a diverse workforce that reflects the community we serve. We do this because we understand that bringing different perspectives and backgrounds to the fulfillment of our mission, vision and values makes us better. We invite all interested individuals to apply and encourage applications from members of all equity-deserving communities, including those who identify as Indigenous, black, racialized, women, people with disabilities and people with diverse gender identities, expressions, and sexual orientations. Even if your past experience doesn’t quite align with every qualification on this position, we still encourage you to apply as you may be the right candidate for another role within our organization. Peterborough Regional Health Centre is committed to creating and maintaining an inclusive and accessible environment that is in compliance with the Accessibility for Ontarians with Disabilities Act (‘AODA’). Should you require accommodation through the recruitment and selection process, please notify us by indicating this on your application form and upon initial contact by our recruitment team. This will ensure that we can tailor the recruitment process to meet your accommodation needs. Thank you for your interest in the opportunity at PRHC. If you are selected to move forward in the recruitment process, you will be contacted by a member of the Talent Acquisition team.