Job Lead Data Engineer in Toronto
At IMCO, our talent is among the best! IMCO offers a uniquely stimulating and rewarding environment where you can help build and drive organizational transformation, all while seeking to challenge yourself, learn, and grow your career.
We offer a culture of collaboration and passion, creating unwavering value for the clients we serve. Our vision is to be the partner of choice for Ontario’s public sector funds and build a high-performing, value-based Asset Management firm in the heart of downtown Toronto.
If you are ready to drive best-in-class service, and join a collaborative, motivated, and fun team of professionals, we’re ready to offer you a great place to work with exciting opportunities for growth and development.
If you want to use your expertise to drive strategic business outcomes, then we want you at IMCO!
A great opportunity to join a team of talented, passionate Data Engineers to architect and build IMCO's data platform using modern cloud technology and provide data solutions for our investment team. As a senior member of our Information Technology team, the Data Engineer Lead will design, build, and support the cloud-based infrastructure for the data pipeline, and analytics across IMCO’s development and data platforms to produce high performance and scalable solutions. The Data Engineer lead is responsible for establishing best practices, new technologies, and architecture and will also act as a mentor and guide within the development team. The role requires the incumbent to be innovative and drive solutions that complement the IT vision and actively advocate technologies that best support IMCO in meeting its current and future business needs within data management. The Data Engineer Lead will report to the Director, Development Services.
Responsibilities:
- Help create and shape the direction of the data platform by leading the adoption of new technologies and processes to advance our capabilities further.
- Integrate with external/internal investment systems leveraging modern cloud technologies and tools on an event-driven architecture
- As a key member of the data platform design committee, set guidelines, standards, and best practices for new project initiatives across development and data management teams.
- Lead design and implementation of data and technology infrastructure for new data and analytics platform with Azure data stack
- Lead design and build data solutions for distributed ETL processing for all data ingestion into the data platform with scalable and usable data pipelines.
- Be the primary liaison and owner for data projects, technical backlog, and managing the delivery solutions with business stakeholders.
- Oversee and build custom web APIs using Azure Function Apps to integrate with external services
- Oversee and develop complex SQL for ETL and data extractions with high performing and easy to manage code.
- Design and develop reports and analytical dashboards in Power BI
- Automate manual processes, optimize data delivery, and design infrastructure for greater efficiency and scalability
- Provide mentorship and coaching to junior members of the team
- Facilitate testing of solutions and production implementation planning
What you need to succeed:
- Minimum 10 years of experience in data warehousing, designing complex SQL queries, tables, views, and procedures, including performance tuning and query optimization
- 2 years’ experience in a leadership role, managing and mentoring data and BI engineers
- Expert experience in ETL processing using tools such as Microsoft SSIS and Azure Data Factory, Data Management fundamentals, and Data Storage principles
- Intermediate to senior-level experience in operationalizing cloud data platforms with Azure data solutions such as Data Factory, Azure Databricks, Azure Analysis Service, Azure Synapse, and Azure Function App
- Solid experience in building and maintaining data models
- Undergraduate degree in Computer Science or Engineering or another related discipline with experience in building and maintaining IT data operations in the asset management or investment industry
- Development experience in using .Net C#
- Track record to work in exploratory capacity to innovate, benchmark, and make recommendations to improve efficiency and effectiveness of design and data operations
- Familiar with system management of monitoring, backup, and maintenance plan
- Practical experience in a building data warehouse, developing complex visualizations and report building in Power BI or Tableau
- Ability to self-direct, manage priorities and meet deadlines
- Superior tactical, analytical, evaluative, and problem-solving abilities to translate business requirements into technical specifications.
- Excellent communication skills, proven success communicating with the user, technical teams, and management
Desirable:
- Proficient in Python and Power Shell scripting is preferred
- Hands-on experience with source control management systems and continuous integration /deployment
- Working knowledge of trading lifecycle and investment workflow with experience in investment data flows, operational processing requirements, and management of data assets
- Knowledge of investment systems Eagle PACE
We thank all applicants, however, only those selected for an interview will be contacted.
Our hybrid work model offers flexibility and provides our employees with the opportunity to lead a well-balanced life. Our Corporation’s offices located at 16 York Street, Suite 2400, Toronto, ON M5J 0E6 provide a welcoming space for employees to gather, work collaboratively, and grow together.
IMCO is committed to providing accommodation for people with disabilities in its recruitment process. Please advise IMCO if you require an accommodation and we will work with you to meet your needs. Candidates being considered for this position will be required to submit to a background screening.
About Investment Management Corporation of Ontario
Revenue: Unknown / Non-Applicable
Size: 201 to 500 Employees
Type: Non-profit Organisation
Website: http://www.imcoinvest.com
Year Founded: 2017
