CARE AND BE CARED FOR – THIS IS YOUR HOME
Are you a collaborative Business Intelligence professional with expertise in multiple business intelligence tools and methodologies? Do you enjoy analyzing and refining operational processes to improve efficiency? Are you passionate about exceptional health care and driven by a desire to help others?
Reporting to the Manager, Business Intelligence, the Business Intelligence Senior Analyst is responsible for designing, validating, and supporting implementation of decision support products including complex reports, cubes and ETL processes across a suite of Business Intelligence tools and environments. This role will also support the organization through improving existing reporting, aggregating common data, and developing data structures that make existing processes and analysis more efficient.
What will you do?
- Analyze current and future data reporting, analysis and dissemination needs, and identify the best tools and technology within the MH HCCSS Business Intelligence tool set to achieve high performing, easily maintainable data delivery
- Design, develop, troubleshoot, debug, test and support implementation of efficient, high performing, and maintainable ETL processes, cubes, dashboards, ongoing and ad-hoc reports from multiple datasets.
- Review existing Decision Support operational reporting processes, to prioritize processes for redevelopment to improve quality, efficiency and maintainability of the processes to improve the reliability and timeliness of operational reporting
- Improve the speed, reliability, and maintainability of Decision Support operational processes
- Work with other Business Intelligence team members to improve overall team use of best practice in decision of ongoing operational processes, reports and data structures
- Develop tools and data structures that simplify access to data and analysis of data from a variety of data sources
What do you need?
- University degree in health information management, management information systems, engineering, statistics or computer science (or equivalent combination of education and experience)
- Four (4) to six (6) years related work experience with at least two (2) years' experience in a complex decision support environment, including designing and building data structures and ETLs that bring together data from multiple data sources
- Experience with multiple BI tools and methodologies, and familiarity with relational and dimensional data models, including reporting (using SQL queries, stored procedures, etc.), relational database management techniques, applications and tools (SQL Management Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), PerformancePoint etc.)
- Knowledge of workbook, report and dashboard design in Tableau a plus
- Solid MS Office skills (Word, Excel, Outlook, PowerPoint, etc.)
- Excellent written and verbal communication skills
- Self-directed with the ability to handle concurrent tasks and organize daily workload in the presence of frequent interruptions
- Strong interpersonal skills with the ability to establish and maintain effective partnerships
What do we offer?
We know wellness is supported with work-life balance. In an inclusive culture committed to support your passion for continuous learning, growth and innovation, we offer:
- Attractive comprehensive compensation packages and benefits
- Valuable development opportunities
- Membership in a world class defined benefit pension plan
- Hybrid work environment
Who are we?
We are Home and Community Care Support Services, ready to serve every person in Ontario. We partner with patients and caregivers, family physicians, hospitals, long-term care and retirement homes, service providers and Ontario Health Teams, to deliver responsive, accessible, integrated, patient-centred care.
Why join us?
If you’re interested in driving excellence in care and service delivery, and seeking an unparalleled opportunity to lead and learn, partner and connect, care and be cared for, this is your home.
Equity, Inclusion, Diversity and Anti-Racism Commitment
Home and Community Care Support Services is committed to a culture of equity, inclusion, diversity and anti-racism. We are committed to attracting, engaging and developing a workforce that reflects the diverse communities we serve. We welcome and encourage applications from all qualified applicants. Accommodations for persons with disabilities required during the recruitment process are available upon request.
We thank all applicants for their interest; however, only those selected for an interview will be contacted.
