Manager, Data Operations Jobs

Reports to: Director, Data Strategy and Business Intelligence

Position Summary:

The Manager, Data Operations is responsible for overseeing the development, implementation, and maintenance of data and visualization architecture, including the Enterprise Data Warehouse, Research Data Warehouse, Machine Learning Operations infrastructure, and Visualization/Dashboard systems. This role involves coordinating integration between these technologies and other reporting applications, as well as leading a team of ETL Developers, OLAP developers, and SSRS report developers. The Manager, Data Operations is also accountable for the maintenance and enhancement of the HSP360 Data Warehouse Model in collaboration with business stakeholders.

Key Responsibilities:

1. Lead Data Operations / System Architecture:

• Oversee the design, development, testing, and optimization of SSIS ETL solutions, including data transformations, data cleansing, and SSAS and SSRS components.
• Establish quality control and data standards to ensure data are Findable, Accessible, Interoperable, and Reproducible (FAIR).
• Support data governance principles and best practices through technologies, processes, and systems design.
• Coordinate upgrades and system improvements, including those resulting from system upgrades and data source changes.
• Coordinate data warehouse-related tasks, including data acquisition and data mart/data-cut production.
• Provide technical direction for the design, enhancement, and deployment of data warehouse technologies.
• Develop Machine Learning Operations infrastructure and integration with data systems.
• Align and support ongoing maintenance of the Enterprise Reporting security layer.
• Develop and implement scalable modern data architecture aligned with state-of-the-art design principles.
• Support the integration of new data sources and coordinate alignment with standard data models.

1. Lead Enterprise Data Team:

• Design and develop the meta data dictionary layer.
• Analyze, assess, and interpret databases for OLAP and ETL design.
• Develop data models, including database design, relational integrity constraints, OLAP, cubes, normalization, and denormalization.
• Lead a technical team responsible for maintaining data models, database designs, data flow, and entity relationship diagrams.
• Support the design, development, and implementation of technical solutions, including infrastructure configuration for optimal performance.
• Design and develop SSRS reporting environments.
• Design and develop data marts, including star schema and snowflake schema.

Qualifications:

• Experience with Machine Learning Ops and systems integration.
• 5+ years of experience with Data Warehousing.
• Online Analytical Processing (OLAP) experience.
• Bachelor's degree in Computer Science or equivalent degree/experience.
• Understanding of graph database technologies and interoperable schema development.
• Experience with Apache NiFi or equivalent systems for scalable data routing and transformation.
• Experience working with diverse clients and stakeholders is an asset.
• Demonstrated experience leading all technical aspects of Data Warehousing Solutions.
• Ability to work jointly with business users to understand operational/client business processes and analytical reporting needs.
• Experience in big data and data mining preferred but not mandatory.
• Demonstrated experience leading Data Warehousing Development resources/teams.
• Experience in a hospital or healthcare environment.
• Bilingualism (French/English) and/or proficiency in a second language is an asset.
• Strong troubleshooting and debugging skills with the ability to isolate and resolve problems.
• Good working knowledge of various Data Warehouse development methodologies.
• Proficiency in Microsoft Office, including Project, Word, Excel, Visio, and PowerPoint.