Data Engineer, Finance Data

Job description

Vision and Core Values

OMERS overall vision is to play a leadership role in the pension industry and be first of class, deliver superior services and to grow and attract investment partners. The core values are to be fair, have high integrity, respect for each other, provide superior service and work as a team.

The Corporate Objectives for OMERS is to provide secure pensions for all their constituents by
  • Investing to earn outstanding returns with due regard for risk
  • Partnering with like-minded investment managers
  • Providing high quality service to our members and employers
  • Delivering value for money
  • Building a culture of excellence and pride in OMERS
OMERS Operating Principles are Financial Strength, Accountability, Member Focus, Talent and Reporting.

Value Proposition

We’d be thrilled to have you join our team as we set up our Capital Markets Finance Data team for new and continued success! We’ll focus equally on expertise and excellence, paired with culture and community. We will serve OMERS teams primarily in Capital Markets, Total Portfolio Management, and the Corporate function through understanding their needs, delivering against their expectations, and contributing our proficiencies – to achieve collective wins. This role joins a team on a journey, with much future potential in a global, sophisticated, complex enterprise.

Scope The Data Engineer is responsible for supporting the investment teams by enabling robust and reliable investment data, analytics, and reporting through investment technology and change management at one of Canada’s largest pension funds having assets exceeding $120 Billion.

  • Design, develop, and help maintain data assets to extract, transform, and load data from various data files, APIs, and databases, and to make them accessible to various client-facing applications as well as investment data warehouse and internal tools
  • Implement data strategies that prepare, transform, combine and manage structured and unstructured data (e.g. internal investment accounting systems as well as external third-party investment feeds) to integrate the data into an investment data warehouse and BI solutions
  • Develop and operate highly scalable data pipelines and infrastructure that enable investment analytics, and investment reporting use cases
  • Automate manual processes and optimize data delivery
  • Utilize modern technologies for designing and building data solutions to meet business needs
  • Partner with business analysts and reporting analysts to develop reports and PowerBI dashboards
  • Support and troubleshoot existing investment data applications and BI reporting solutions as needed
  • Work as part of a cross-functional agile team responsible for end-to-end delivery of business needs
  • Collaborate and work effectively with business analysts and reporting analysts team members, and other investment professionals and leaders in solutioning and support
  • Track of record working in a fast-paced environment and multi-faceted role that intersects with business and technical analysts to support existing solutions, solution delivery, and contributions as a project resource for investment system implementations and upgrades
  • Strong experience with data management, investment systems, business intelligence, and other reporting technologies
  • Experience with Microsoft based BI/ETL tools (e.g. SQL Server, SSRS, SSIS, data factory) or similar
  • Experience with Cloud based data and analytics platforms (e.g. Snowflake, DataBricks, Azure Synapse)
  • Deep proficiency in SQL, Python, and similar languages
  • Good understanding of investment products
  • Demonstrated ability to handle multiple projects and tasks at the same time to support daily production issues
  • Critical thinking skills with the ability to independently solve problems with data and/or reference documents
  • Investment data modeling experience using the Kimball method is an asset
  • Experience with BNY Eagle PACE, Calypso, and Charles River is an asset
  • Data governance experience is an asset
  • Bachelor’s or master’s degree in Computer Science, Engineering, Finance, or a related field
And you demonstrate
  • A people-first focus with a desire to develop meaningful, positive relationships across all levels of the organization
  • A teammate mentality coupled with servant leadership
  • A sense of urgency, optimism, and a desire to deliver excellence
  • A desire to drive debate, to speak candidly, and to listen empathetically
  • Strong orientation towards strategy, change, and results
  • A continuous improvement mindset
Our story

Founded in 1962, OMERS is one of Canada’s largest defined benefit pension plans, with $121 billion in net assets as at December 31, 2021. OMERS is a jointly-sponsored pension plan, with 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.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
COCUS Portugal
February 9, 2023
Nordex Group
February 9, 2023
ASTEK Polska
February 9, 2023