Data Engineer, Finance Data (6 Months Contract)

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.

Responsibilities

• Partner with business analysts and reporting analysts to develop reports and PowerBI dashboards
• Utilize modern technologies for designing and building data solutions to meet business needs
• 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
• Collaborate and work effectively with business analysts and reporting analysts team members, and other investment professionals and leaders in solutioning and support
• 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
• Work as part of a cross-functional agile team responsible for end-to-end delivery of business needs
• 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
• Support and troubleshoot existing investment data applications and BI reporting solutions as needed

Qualifications

• Strong experience with data management, investment systems, business intelligence, and other reporting technologies
• Experience with Cloud based data and analytics platforms (e.g. Snowflake, DataBricks, Azure Synapse)
• Bachelor’s or master’s degree in Computer Science, Engineering, Finance, or a related field
• Deep proficiency in SQL, Python, and similar languages
• Critical thinking skills with the ability to independently solve problems with data and/or reference documents
• Good understanding of investment products
• 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
• 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
• Experience with Microsoft based BI/ETL tools (e.g. SQL Server, SSRS, SSIS, data factoryor similar
• Demonstrated ability to handle multiple projects and tasks at the same time to support daily production issues

And you demonstrate

• A people-first focus with a desire to develop meaningful, positive relationships across all levels of the organization
• A continuous improvement mindset
• Strong orientation towards strategy, change, and results
• A desire to drive debate, to speak candidly, and to listen empathetically
• A sense of urgency, optimism, and a desire to deliver excellence
• A teammate mentality coupled with servant leadership

Our story

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