Manager Data Operations Data & Insights, IMG

Reporting 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.

Leads 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.

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.

If you are interested in this position, please ensure that you apply before 5pm EST of the closing date. If your application is received past 5pm EST of the closing date, your application will not be accepted.

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.