Sr. Systems Developer

Why you'll love working here:

• high-performance, people-focused culture

• our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves

• learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees' career growth

• membership in HOOPP's world class defined benefit pension plan, which can serve as an important part of your retirement security

• competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account).

• optional post-retirement health and dental benefits subsidized at 50%

• yoga classes, meditation workshops, nutritional consultations, and wellness seminars

• the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Job Summary:

The IT Enterprise Architecture team at HOOPP (Healthcare of Ontario Pension Plan) is looking to fill a permanent, full-time Sr. Systems Developer (Data Governance) role to holistically support HOOPP's Enterprise Data Program. 

Reporting to the Sr. Director, Unified Data Governance, the Sr. Systems Developer will support data and data governance initiatives while collaborating with various business stakeholders. The Sr. Systems Developer will also support the implementation and maintenance of the data catalog.

The Unified Data Governance team is focused on delivering true business value in a dynamic and fast-paced environment. They value innovative solutions, team collaboration and delivery. 

What you will do:

Data Catalog Implementation  

• Set up and configure connectors to data systems, workflows, and automations based on use cases  

• Leverage personalization capabilities to ensure the catalog's interface is user-friendly and aligned with user needs 

• Design scalable and secure data architectures to support the catalog (e.g. integration and connectivity methodology between the catalog and data platform systems)  

• Set up integrations with existing tools (Github, Teams) and adhere to established deployment processes.  

• Managing migration of data platform systems with accuracy and minimizing downtime and impact to the catalog (w.r.t metadata completeness and accuracy)  

• Technical curation of data assets for technical meta data, technical data quality and alignment of data products to medallion architecture 

• Ensure the Data Marketplace is up to date with the latest data assets and data products, by troubleshooting any issues in data publication or data pipeline processes 

Data Catalog Technical Maintenance  

• Providing ongoing technical support and platform maintenance (workflows, integrations, automations etc.) post-implementation and managing performance, security, and scalability of the catalog and its integrations 

• Diagnose production issues spanning the Enterprise Data Platform and Data Catalog, and work with the vendors to perform upgrades and/or maintenance 

Working with Business Stakeholders  

• Work closely with business users to review and validate data contracts, understand business data context, and ensure usability of the onboarded data to the data catalog 

• Partner with the business team to ensure alignment on enterprise data governance policies and standards, provide guidance to end users on implementation of best practices 

• Assist business users in maintenance of data catalog technical configurations, including data dictionary, data asset configurations, meta data, data products creation and medallion architecture 

• Work with the internal IT/EDP team to ensure catalog domains/integrations/connectors are configured and maintained 

• Promote data literacy to business and IT teams, and ensure use of data within the Enterprise Data Platform is in alignment with governance processes and architecture standards 

Working with Enterprise Data Platform Team on Enterprise Data Governance  

• Update ETL procedures to ensure Data Quality rules are configured as defined in the data contracts and work with the Enterprise Data Platform Operations team to ensure data quality incidents and concerns are addressed in a timely manner for business users 

• Assist the Enterprise Data Platform team with alignment to governance standards for access management and subscription processes, ensure domain definitions are aligned to governance practices 

Working with Enterprise Data Platform Team on Platform Engineering  

• Participate in design sessions, code reviews, and support the use of End User Compute on the Enterprise Data Platform 

• Develop standards, patterns, and practices to improve Business Intelligence and use of Business Intelligence tools such as Power BI within the Enterprise Data Platform 

• Actively participate in Agile Scrum practices such as providing input to the team product roadmap, daily standups, backlog refinement, planning and sprint retrospectives 

• Design, build, and support new features as implemented in the Enterprise Data Platform 

What you bring:

• 5+ combined years of experience in development and data engineering 

• University degree in Computer Science, Software Engineering or related field 

• Proven track record of leading change initiatives in data-intensive environments or analytics projects, such as data catalogs (For example - SageMaker Unified Studio & Atlan), governance tools, or enterprise data systems (Snowflake).  

• Strong technical expertise in integrating data platforms (e.g., databases, data lakes, BI tools) with cloud environments (AWS or GCP or Azure).  

• Experience with API integrations, ETL data pipelines, data connectors, and managing metadata flow between systems.  

• Familiarity with data cataloging concepts, data governance, metadata management, and analytics tools.  

• Understanding of data governance frameworks, including roles like data stewards, data custodians, and data owners.  

• Exceptional communication and presentation skills, with the ability to convey technical concepts to non-technical audiences 

• Strong interpersonal and communication skills with an ability to lead and take end-to-end ownership. 

• Experience with data for investment & investment finance activities in Public/Private Equities, FX, Cash management, and Collateral management is an asset.