Data Governance (Collibra and Informatica) Developer
Head Office Toronto
OMERS
OMERS pension income provides peace of mind. With the OMERS defined benefit pension plan you can confidently retire knowing that you will have income for life. The money you set aside from every paycheque is matched by your employer, and we...Are you looking to join a dynamic pension plan that embodies the strong values of its 600,000 members and is an industry leading global investor? If so, we would love to tell you our story.
At OMERS we put our people first and are proud to embrace the diversity of thought and leadership that comes from having locations in Toronto, London, New York, Singapore, Sydney and other major cities across North America and Europe. Our culture is truly one of a kind. We get stuff done, and have fun doing it! We take great pride in contributing to the communities where we live with an ever-constant eye to the global investment markets.
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.
- 3+ years of experience working with vendors such as Collibra and 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 3 days per week.
Our story:Founded in 1962, OMERS is one of Canada’s largest defined benefit pension plans, with $128.6 CAD billion in net assets as of December 31, 2023. OMERS is a jointly-sponsored pension plan, with more than 1,000 participating employers ranging from large cities to local agencies, and over half a million active, deferred and retired members. OMERS members include union and non-union employees of municipalities, school boards, local boards, transit systems, electrical utilities, emergency services and children’s aid societies across Ontario. Contributions to the Plan are funded equally by members and employers. OMERS teams work in Toronto, London, New York, Amsterdam, Luxembourg, Singapore, Sydney and other major cities across North America and Europe – serving members and employers and originating and managing a diversified portfolio of high-quality investments in public markets, private equity, infrastructure and real estate.
OMERS is committed to having a workforce that reflects the communities in which we live and work. We are an equal opportunity employer committed to a barrier-free recruitment and selection process. At OMERS inclusion and diversity means belonging. How we create a sense of belonging is through our employees and our vast network of Employee Resource Groups. Whether you are passionate about gender, pride, or visible minorities, we have groups that are focused on making a difference in all of our lives.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture CAD Classification Data governance Data management Data quality Data warehouse ETL Informatica MS SQL Oracle Power BI Snowflake SQL Testing
Perks/benefits: Flex hours
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.