Job Description

Choose a workplace that empowers your impact.

Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be -- and deliver -- your best.



We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 600,000+ members, placing their best interests at the heart of everything we do.



Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.



Don't just work anywhere -- come build tomorrow together with us.



Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.



The Data Governance Developer will work as part of the Enterprise Data Governance Team to plan and lead the rollout of data governance tool capabilities while focusing on the adoption and process implementation for critical governance aspect related to data quality and metadata management.



This role will operate within Data & Technology to provide technical guidance related to Collibra, Informatica, MS Purview and related application and reporting integrations. They collaborate with the data stewards and technical custodians through data governance projects and initiatives across the organization. This position offers an opportunity to influence and guide data governance adoption across various lines of business at OMERS (Pensions, Investments, Oxford and Corporate) to drive business success and ensure data integrity.

Responsibilities:

Design, develop and monitor technology capabilities for key data governance focus areas of data catalog, metadata management, data quality management, data lineage, workflows, and access management.



Provide ongoing access, maintenance, usage, and technical support for our Data Governance Tool inventory including Collibra, Informatica and Purview



Responsible for being the primary point of contact for business partners to resolve data governance tool related technical issues on Collibra, Information and Purview.



Manage the processes around metadata repositories (data dictionary, business glossary) and data classification process (identification of sensitive data)



Transform business requirements to define data quality management approach for the business partner along with creating the necessary system and platforms integrations to implement data quality rules and build data quality monitoring.



Implement data quality processes including data profiling, data quality analysis, parsing, standardization, enrichment, deploy mappings that will run in a scheduled, batch, or real-time environment and the development of data quality rules to support monitoring (using Informatica Cloud Data Quality (CDQ)) and remediation activities.



Work closely with Data & Technology team during the development of new data governance capabilities and related integration with other applications, including requirements validation and testing.



Create and maintain technical documentation in all aspects of Data Governance work including (not limited to) related to data quality processes, metadata management, data mappings, and data governance processes etc.



Create and maintain appropriate materials for education, onboarding, and training for new and existing employees to educate and drive data governance best practices.

Qualifications:

Expert level skills in Collibra and/or Informatica IICS/CDQ platform as a whole and the integration among different components and services to carry out technical deployment and integration and troubleshoot user issues.



2+ years of experience working with vendors such as Collibra or Informatica vendors to discuss new functionality rollout or technical issue resolution related work.



Experience with SQL, database applications MS SQL/ Oracle, and visualization tools such as Power BI is necessary.



Strong understanding of data modeling concepts and data warehouse design (star schema, snowflake schema, etc.) is required.



Strong functional understanding of performance tuning methods, mapplets, worklets, stored procedures & data mappings Relevant certifications in Informatica or data governance are a plus.



Excellent knowledge of data management, analytics platforms, ETL, data architecture and integration areas of work.



Knowledge and expertise in data governance technology, business process modeling, data classification, data quality and enterprise implementation of data governance tools and solutions.



Excellent verbal and written communication to effectively articulate and communicate with both business and technical development teams.



We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other, our flexible hybrid work guideline requires teams to come in to the office 4 days per week.



As one of Canada's largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work -- and the members we proudly serve.



From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition programs.