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.

Our culture is built on collaboration and passion, with a shared commitment to delivering lasting value to the clients we serve. Located in downtown Toronto, our vision is to be the partner of choice for Ontario’s public sector funds and to build a high-performing, value-driven asset management firm.

This job posting is for an existing vacancy. If you are ready to deliver best-in-class service and join a collaborative, motivated and fun team of professionals, IMCO offers the opportunity to do impactful work and broaden your expertise.

If you’re looking to use your expertise to drive strategic outcomes, we’d love to hear from you.

‎

As a key member of the Core Data technology team, the Senior Data Engineer will work closely with the Sr Manager, Lead Data Engineer, internal data teams, and key application support teams to design, build, and support the cloud-based infrastructure for the data pipeline, including maintenance, improvement, cleansing, and manipulation of data and analytics across IMCO’s data platforms.  The Senior Data Engineer will be a collaborative technical SME that can drive solutions while working closely with Data Leads, Data Architects, business systems analysts, and business stakeholders to analyze, design, and implement data-driven solutions for IMCO.

As a Member of Our Team You Will be Responsible For:

Data Architecture & Engineering

• Design and implement data architecture and technology infrastructure for the enterprise data and analytics platform using Azure data services, Databricks, and Snowflake.
• Build scalable ETL/ELT pipelines for ingesting data into the platform.
• Develop custom services and workflows to complement existing tools (e.g., data format transformation, external API/Web service integrations).
• Create database objects with strong data‑modeling principles.
• Write high‑performance, maintainable SQL for ETL and data extraction needs.
• Automate builds and deployments using cloud-native CI/CD practices.
• Automate manual processes, optimize data delivery, and redesign infrastructure for improved scalability and efficiency.

Analytics, Reporting & Business Collaboration

• Design and develop analytical dashboards and reports in Power BI.
• Work closely with business users to understand requirements, rapidly prototype solutions, and incorporate feedback.
• Partner with business systems analysts and SMEs to support project delivery, investigate issues, recommend enhancements, and maintain accurate documentation.
• Facilitate testing, production rollout planning, and act as a trusted liaison between IT, business stakeholders, and external vendors.

Operations, Governance & Continuous Improvement

• Reverse‑engineer, analyze, and document data flows to support operational processes.
• Evaluate existing data operations; develop processes for maintenance, monitoring, performance tuning, and operational efficiencies.
• Improve platform stability by establishing and maintaining production configurations and continuously enhancing service levels.
• Provide operational health and status reporting for database and ETL processes.
• Incorporate operational risk considerations and performance management into all initiatives.
• Promote knowledge sharing of design, coding, and analysis best practices.

What do you need to succeed?

• Minimum 7 years of experience in data warehousing, designing complex SQL queries, tables, views, and procedures, including performance tuning and query optimization.
• Undergraduate degree in Computer Science or Engineering or other related discipline with experience building and maintaining IT data operations in asset management or investment.
• Expert experience in ETL processing using tools Azure Data Factory and Airflow
• Intermediate to senior-level experience in operationalizing data platforms with Azure data solutions such as Azure Databricks, Azure Analysis Service, and Snowflake
• Solid experience in building and maintaining dimensional data models.
• Hands-on experience with source control management systems and continuous integration/deployment
• Development experience in using .Net C#.
• Development experience in Function App
• Experience with SQL Server.
• Experience with Azure DevOps
• Proficient in Python development
• Track record to work in an exploratory capacity to innovate, benchmark, and make recommendations to improve the efficiency and effectiveness of design and data operations.
• Ability to self-direct, manage priorities, and meet deadlines.
• Superior tactical, analytical, evaluative, and problem-solving abilities to translate business requirements into technical specifications.
• Strong working knowledge of trading lifecycle and investment workflow with experience in investment data flows, operational processing requirements, and management of data assets
• Strong domain knowledge in IT service management, including incident management, change management, configuration management, and operations management.
• Good understanding of agile practices, with demonstrated experience in operating in Kanban or Scrum for delivery.

Desirable:

• Practical experience in building data warehouses and report building in Power BI
• Exposure to data science, machine learning, and LLM is an asset.
• Eagle PACE knowledge is highly desirable.

‎

The base salary range for this position is CAD $105,000.00 - $138,000.00. The placement within the range is determined by the range of market pay for the specific position, as well as the candidate's knowledge, skillset and experience relative to the requirements of the position and to internal peers. In addition to base salary, this position is eligible to participate in IMCO's annual incentive plan. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you with the specific details for this position, as well as the total rewards offering at IMCO including our comprehensive benefits package and defined benefit pension plan.

‎

We thank all applicants for their interest. Only those selected for an interview will be contacted.

Our hybrid work model prioritizes an office-first approach, encouraging employees to make the most of our collaborative workspace at 16 York Street, Suite 2400, Toronto, ON M5J 0E6. This welcoming environment fosters teamwork, connection, and professional growth. While flexibility remains a key component of our model, we believe that regular in-office engagement enhances productivity and strengthens our culture. Our approach supports a fulfilling lifestyle that balances professional ambition with personal wellbeing.

IMCO is committed to providing accommodation for people with disabilities throughout the recruitment process. If you require support, please let us know and we will work with you to meet your needs. Artificial intelligence (AI) tools may be used to support parts of our recruitment process, such as screening and assessments. However, all hiring decisions are made by our recruitment team. Candidates being considered for this position will be required to undergo background screening.