Job descriptionAs a key member of the Data & Advanced Analytics team, the role of Senior Data Engineer is instrumental in enhancing data & analytics capabilities by fostering industry standard processes and delivering high quality data assets to support investment decision making.
In this position, you will operationalize and maintain data pipelines deployed to the OMERS investment entities and nurture a business relationship that assists in meeting business demands. You will also support and collaborate with Power BI developers, data scientists and investment professionals and engage in technical support, research and integration through the implementation lifecycle of projects and solutions.
This role is accountable for ensuring that all projects, solutions and platforms align with and support overall enterprise Data & Technology strategy & goals, and enforce to company policies, industry standards and best practices.
As a member of this team, you will be responsible for:
Deploying ETL pipelines to achieve a high level of reliability, scalability and security.
Sourcing, transforming and delivering structured and unstructured assets for use in Azure Databricks, SQL Server, and Power BI.
Operating in an Agile development environment.
Communicating effectively with other engineers in the same team, with other teams and with various other partners such as product managers, data analysts and members of senior management.
Participating in solution build, delivery, support and solving
Leading change and communicating impacts to business partners and fellow team members
Exhibiting ability to work on multiple projects simultaneously and ensure delivery on time, within scope and within budget
Participating in establishing sound data management practices for the team and the organization
Identifying, defining and implementing opportunities for enhancing existing processes
Defining and implementing technical test plans and perform unit and integration testing
To succeed in this role, you have:
Experience. 5+ years solving sophisticated technical data projects using the Microsoft Azure data stack is required
Industry Knowledge. The ability to quickly propose Azure Data Platform solutions by recalling the latest standard processes learned from MVP & Product Team articles, MSFT documentation, whitepapers, and community publications is required
Relationship Building. A proven track record of building deep technical relationships. Experience in setting expectations across various partners.
Problem-Solving. Must be able to trace data lineage / workflows and resolve technical issues with minimal supervision. Demonstrated proficiency in understanding and implementing business workflows is a plus.
Teamwork. Motivated and keen to work in a collaborative environment with a focus on team success over and above individual success.
Enterprise-scale technical experience with cloud and hybrid infrastructures, architecture designs, and technology management is required
Breadth of technical experience and knowledge across the Azure Data Platform, with depth Domain Expertise in two or more of the following Data Platform resources is required:
Azure Databricks using Python
Azure Functions v2/3 using C# or Python
Azure Machine Learning
Experience with on-premise SQL Server Data Tools
Experience developing star schema reporting pipelines using Kimball or Data Vault v2.0 methodologies
Bachelor’s Degree in an appropriate field of study or equivalent work experience
Certifications in Azure Data Engineer and/or Azure DevOps Engineer Expert
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.