Manager Data Operations Data & Insights, IMG

CAMH; Toronto; On-site; CAD 103,000 - 154,000; Full time

Benefits offered by this job

HOOPP defined benefit pension

Extended health and dental benefits

4 weeks vacation

Flexible work arrangements

Professional development support

Job summary

CAMH is seeking a Manager, Data Operations to lead the development of data and reporting architecture, including the Enterprise Data Warehouse, Research DW, and ML Ops infrastructure. You will oversee ETL/OLAP teams and ensure integration with visualization systems at CAMH.

The role requires driving scalable data architectures, data governance, and collaboration with stakeholders. Based at 1001 Queen Street West, you will work in a hospital and research environment with competitive compensation.

Qualifications

• Bachelor’s degree in Computer Science or equivalent degree/experience.
• 5+ years of experience with Data Warehousing and leading DW development resources/teams.
• Experience leading all technical aspects of DW solutions, OLAP, and analytical reporting needs.
• Ability to work with business users to understand processes and reporting needs.
• Strong troubleshooting and problem-solving skills with knowledge of DW development methodologies.

Responsibilities

• Provide technical direction for design, enhancement and deployment of data warehouse technologies.
• Develop scalable modern data architecture aligned with best-practice design principles.
• Establish data quality standards to ensure data is Findable, Accessible, Interoperable and Reproducible.
• Support data governance, processes and systems design.
• Oversee ETL solution design, development, testing and optimization.
• Maintain Enterprise Reporting security layer and coordinate data-mart/data-cut production.
• Coordinate upgrades and integration of new data sources (e.g., iCare/CERNER, HIVE, HSP360).
• Develop Machine Learning Operations infrastructure and integration with data systems.
• Lead and manage ETL/OLAP team performance and coaching.

Skills

Data Warehousing

ETL Development

OLAP

Snowflake

ML Ops

Data Modeling

Data Governance

Communication

Project Management

Education

Bachelor’s degree in Computer Science or equivalent

Tools

Snowflake

SQL Server

SharePoint

BI Tools

Job description

Job DescriptionReporting to the Director, Data and Reporting, the full-time, permanent Manager, Data Operations is accountable for the development of technology and processes for CAMH data and reporting architecture, including the Enterprise Data Warehouse, Research Data Warehouse, Machine Learning Operations infrastructure and Visualization/Dashboard systems, as well as integration between these technologies and other related reporting applications.

Job DescriptionReporting to the Director, Data and Reporting, the full-time, permanent Manager, Data Operations is accountable for the development of technology and processes for CAMH data and reporting architecture, including the Enterprise Data Warehouse, Research Data Warehouse, Machine Learning Operations infrastructure and Visualization/Dashboard systems, as well as integration between these technologies and other related reporting applications.In this capacity, the Manager Data Operations leads a dedicated team of designated ETL Developers and OLAP developers in the designing, modeling, developing and implementing data warehouses using tools like Snowflake .The Manager Data Operations is also accountable for the maintenance and enhancement of HSP360 Data Warehouse Model, in collaboration with Business Stakeholders.

ResponsibilitiesLeads Data Operations / System Architecture

• Provide technical direction for the design, enhancement and deployment of data warehouse technologies
• Develop and implement scalable modern data architecture aligned with state-of-the art design principles
• Establish quality control and data standards to ensure data are Findable, Accessible, Interoperable, and Reproducible
• Support data governance principles and best-practices through technologies, processes and systems design
• Oversee the design, development, testing, and optimization of ETL solutions
• Align and support ongoing maintenance of the Enterprise Reporting security layer
• Oversees/coordinates data warehouse related tasks, including data acquisition and data-mart/data-cut production
• Support the integration of new data sources and coordinate alignment with standard data models
• Coordinate upgrades and system improvements, including those as a result of system upgrades and data sources changes including, iCare/CERNER, HIVE and HSP360
• Develop Machine Learning Operations infrastructure and integration with data systems

Leads Enterprise Data Team

• Maintain data Models, database designs, data flow and entity relationship diagrams, as well as all installation and configuration documentation
• Support the design, development and implementation of all aspects of technical solutions including;
• Infrastructure configuration to ensure optimal performance (including the configuration between Snowflake, SQL Server and SharePoint)
• Analysis, assessment, and interpretation of databases for OLAP and ETL design
• Development of data models, including database design, relational integrity constraints, OLAP, cubes, normalization and denormalization.
• Design and development of the meta data dictionary layer
• Design and development of data marts (including star schema and snowflake schema)

The managerial accountabilities of this position include leading, managing, monitoring and evaluating ETL and OLAP developer performance; assigning work and managing the technical team; mentoring, coaching, and training direct reports, team development; fostering a healthy work environment model and promoting CAMH values. In this role you will be responsible for providing leadership; managing human resources, including recruitment and performance management. You will be responsible for providing leadership in team planning, development, implementation, and evaluation. You will support a healthy workplace that embraces diversity, encourages teamwork and complies with all applicable and regulatory requirements. This position is based at 1001 Queen Street West.

Qualifications

You will possess a Bachelor’s degree in Computer Science or equivalent degree/experience. You will have 5+ years of experience with Data Warehousing, demonstrated experience leading Data Warehousing Development resources / teams, demonstrated experience leading all technical aspects of Data Warehousing Solutions, online analytical processing (OLAP), ability to work jointly with the business users to understand operational/client business processes and analytical reporting needs, proven trouble shooting/debugging skills with ability to isolate/resolve problems, good working knowledge of a variety of Data Warehouse development methodologies.

• Understanding of graph database technologies and interoperable schema development.
• Experience with Snowflake, (or other equivalent systems) to manage scalable data routing and transformation.
• Experience with Machine Learning Ops and systems integration.
• Proficiency in Microsoft Office including Project, Word, Excel, Visio, PowerPoint.
• You will have excellent communication (written and verbal) and interpersonal skills in English.
• Strong organization and planning skills and experience in a hospital or other healthcare environment are required.
• You possess strong analytical problem-solving ability with the ability to prioritize and manage competing deadlines.
• You are attentive to detail and are able to work under pressure and respond to deadlines in a fast-paced environment.
• Experience working with diverse clients and stakeholders is a definite asset.
• Experience in big data and data mining preferred but not mandatory.
• Bilingualism (French/English) and /or proficiency in a second language would be an asset.
• Vaccines (COVID-19 and others) are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code.

Compensation & Benefits

• Salary is competitive and based on experience, with a hiring range of $102,735.96 – $128,419.95 per year.
• Employees in this role may progress within the full pay range of $102,735.96 – $154,103.94 per year
• CAMH’s Total Rewards: Includes participation in HOOPP defined benefit pension plan, extended health and dental benefits, paid vacation starting at 4 weeks, flexible work arrangements, and ongoing professional development support.

This role allows professionals to apply their expertise in a mission-driven environment dedicated to public health outcomes.

CAMH is a fully affiliated teaching hospital and research institute of the University of Toronto. As a CAMH employee, you will contribute to our mission by supporting teaching, research, and clinical care across the hospital.

CAMH is dedicated to equity, diversity, and inclusion. Our commitment is to foster a workplace, teaching, and learning environment that is inclusive, respectful, and free from discrimination or harassment.

CAMH strongly encourages applications from candidates who reflect the diversity of the communities we serve, including First Nations, Métis, and Inuit Peoples; Black and other racialized communities; LGBTQ2S+ communities; women; and people with disabilities, including those with lived experience of mental health and substance use challenges.

We welcome applicants from all backgrounds. Thank you to all who apply; however, only those selected for an interview will be contacted. If you require accommodations during the application or recruitment process, please let us know.

About Us

Through its core values of Courage, Respect and Excellence, CAMH is implementing its Strategic Plan: Connected CAMH, to transform lives, ignite innovation and discovery, revolutionize education and drive social change. CAMH is more than a hospital, it is a cause. CAMH is on a mission to change the way society thinks about and responds to mental illness. They aim to eliminate prejudice and discrimination and shape a world where mental illness is central to our healthcare system – a world where Mental Health is Health.

To learn more about CAMH, please visit their website at: www.camh.ca .To view our Land Acknowledgment, please click here .