Full Time Manager, Business Intelligence

Reporting to the Director, Business Intelligence & Analytics, this position provides leadership in the development and implementation of business intelligence strategies and operations. The Manager, Business Intelligence leads a team of professionals in the development and implementation of integrated reporting tools, information analysis and reporting, and an organizational dashboard, adding visibility to key performance indicators, and aiding in driving continuous improvement initiatives within the organization. This position provides input on and helps lead organizational strategies and projects. This role also requires the development and implementation of forecasting models, utilized for a number of purposes including the establishment of the annual organizational budget, as well as the management of key business intelligence projects within the organization.

This position is responsible for maturing and communicating the data management strategy and data standards, execution of projects to realize the data management strategy target state, directing the data governance program and managing day-to-day operations for our data/reporting systems and data stores. The Manager works closely with Patient Services and other stakeholders to identify and exploit opportunities to utilize business intelligence solutions, data visualization, big data, data marts and data warehouse systems to improve business processes, enable / enhance self service capabilities and create predictive analytics.

What will you do?

• Develop, implement, evaluate, and make continuous improvements to a business intelligence infrastructure
• Provide statistical quality management control reports and analysis of performance against established standards and metrics and highlight areas of concern; respond to the needs of various individuals for ad-hoc data
• Develop a plan to increase effectiveness of the organization's use of information and evidence-based decision making
• Build organizational capacity to demonstrate achievement of strategic and operational goals
• Develop solutions to enhance the organization's performance management system through the use of standard qualitative and quantitative measures and reporting tools
• Develop and/or direct the development of timely reports about organizational performance utilizing Home and Community Care Support Service's reporting environment and business intelligence tools
• Investigate, analyze, and present information in a manner that supports business strategies and operations
• Consult with senior management to determine and understand Home and Community Care Support Service's strategic and operational objectives to design and implement key performance indicators
• Lead Home and Community Care Support Services business intelligence strategy, enhancing meaningful use of information, improving quality of information, and increasing the use of evidence-based decision making
• Manage staff through effective leadership within the provisions of contracts and corporate policies and procedures
• Develop, support, and evaluate the performance of staff; assign work and projects and monitor and adjust workloads, as required

What must you have?

• University degree in Computer Science, Information Systems, Business Management, Epidemiology, or specialized training/certification
• 5 - 7 years' direct work experience in business analysis
• 2 - 3 years' experience working in health care
• Demonstrated experience working with a team in a professional environment with tight timelines and highly sensitive material
• Experience leading or participating in complex organizational projects
• Strong problem solving, analytical and critical thinking skills. Demonstrated abilities in data analysis, interpretation, and report generation; the ability to use data and information to 'tell the story'
• Strong communication skills (verbal, written, presentation), with an ability to display and explain complex analyses in an easily understood user-friendly manner geared to the target audience
• Experience in a health care decision support environment and a solid understanding of the health care system
• Demonstrated experience analyzing business intelligence and technical requirements
• Demonstrated experience modeling and mapping business intelligence processes using proven methodologies and models
• Expertise in designing, developing, and implementing re-engineered business intelligence processes and associated software and hardware
• Ability to design and write complex SQL code
• Ability to validate large and complex data sets
• Experience with developing/creating data cubes and/or tabular models
• Demonstrated experience planning, implementing, and maintaining DBMS (installation, configuration, security, performance)
• Able to implement and maintain servers (hardware planning and specifications)
• Able to design, implement, and maintain ETL jobs
• Experience using development tools such as Visual Studio and Azure Data Studio
• Experience working with version control tools such as Git and Team Foundation Version Control
• Direct knowledge of various query languages i.e. SQL, MDX, XML, DDL, JSON and/or DAX
• Knowledge of statistical query languages such as Python, R, and/or SAS
• Experience with business intelligence tools such as SQL Server Management Studio (SSMS) / Azure Data Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Microsoft Fabric, and PowerBI
• We have a mandatory COVID-19 vaccination policy. As a condition of employment, all employees are required to submit proof of COVID-19 vaccination status prior to start date

What would give you the edge?

• Good knowledge of Home and Community Care Support Services strategic direction, business practices, and objectives
• Good knowledge of the healthcare system and direct care/service delivery models used in community agencies
• Ability to speak French or another second language
• Active listening encouraging open communication, clear and concise communication style
• Responsive to change, criticism and ideas
• Ability to make reliable judgments, using common sense, logical and critical thinking and problem evaluation
• Ability to perform under unusual, confusing or difficult work situations to achieve results
• High attention to detail in all aspects of work

Hours of Work

Monday to Friday 8:30am to 4:30pm, subject to change

This is a hybrid position, the successful applicant will be required to be onsite in the office as determined by the Employer.

The successful candidate must be willing to work from one of the HCCSS branch offices within the West region (Burlington, Hamilton, Niagara, Brantford, Waterloo, Cambridge, Guelph, London, Woodstock, Owen Sound, St Thomas, Stratford, Chatham, Windsor, Sarnia).

Salary Range

$108,339.33 to $129,369.92 annually

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.

All applications will be reviewed; however, only those selected for an interview will be contacted.