Senior Data Engineer

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!
 

As a key member of our IT – Investment Applications for Private Markets, the Senior Data Engineer will work closely with Senior Business Analyst, Private Markets Technology, internal data teams and key application support teams to design, build and provide production support to the infrastructure for data pipeline, including maintenance, improvement, cleansing and manipulation of data and analytics across IMCO’s data platforms as well as private market applications.  The Data Engineer will be a collaborative technical lead that can drive solutions while working closely with data architects, business systems analysts, data management teams 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 and ETL Development 

• Contribute to design and implementation of data architecture and technology infrastructure to feed data into various front office applications leveraging Azure data stack (Data factory, Data bricks, ADLS, Synapse) 
• Develop and maintain warehousing leveraging Azure native services and Snowflake 
• Design and build scalable ETL workflows using data bricks and data factory for all data ingestion and retrieval from the data platform 
• Write complex Python, SQL for ETL and data extractions with high performance and easy to manage code 
• Build custom services and workflows to provide functionality when required to complement existing tools, i.e. convert to ingestible formats, call external web services and third-party APIs 
• Create database objects with strong understanding of data modeling 
• Develop and maintain automated build and deployment process for all solutions using cloud tools 

Production Support and Maintenance 

• Work closely with business systems analysts, SMEs on project and operations to deliver effective support, investigate root causes, recommend changes, and maintain accurate documentation 
• Develop functional specifications and systems configurations documentations to support solution roll out 
• Reverse-engineer, investigate and document data flow for operational procedures and support 
• Evaluate existing data flow and operations, develop process for effective maintenance, monitoring and performance tuning, and recommend improvements for operational efficiency 
• Provide health status of operations within platform with specific support for database and ETL processes 

Implement Enhancements  

• Partner closely with business users to understand requirements and rapidly prototype reports to maximize end-user involvement and solicit feedback 
• Enhance environment stability by working with others to set up and maintain production configurations. Continuously improving service levels with all business and technical stakeholders 
• Automate manual processes, optimize data delivery, and redesign infrastructure for greater efficiency and scalability
• Initiate knowledge dissemination of design, coding, and analysis techniques in collaborative manner 
• Facilitate testing of solutions and production implementation planning while performing as a trusted liaison between IT, Investment business stakeholders, and external solution providers 
• Think creatively to design solutions, addressing both business and technical aspects, with a forward-thinking approach to best accommodate future opportunities 
• Incorporate operational risk and systems performance management in all initiatives 
• Design and develop reports and analytical dashboards in Power BI 

What do you need to succeed?

• Undergraduate degree in Computer Science or Engineering or other related discipline with experience in building and maintaining IT data operations in the asset management or investment industry
• Minimum 10 years of experience designing complex Python and SQL queries leveraging Databricks, including performance tuning and query optimization (preferably within Investment Management – Private Markets) 
• Expert experience in ETL processing using tools in such as Databricks, Microsoft SSIS and Azure Data Factory 
• Intermediate to senior level experience in operationalizing data platforms with Azure data solutions such as Azure Databricks, Azure Analysis Service and Azure Synapse as well as Snowflake 
• Experience with tools like GitHub Copilot or OpenAI Codex that assist in writing code by generating suggestions and autocompleting code based on context 
• Familiarity with licensing options on Azure data platforms to recommend optimal solutions 
• Solid experience in building and maintaining data models 
• Proficient in Python and Power Shell scripting is preferred 
• Hands-on experience with source control management systems and continuous integration/deployment  
• Familiar with system management of monitoring, backup, and maintenance plan  
• Experience with quality engineering tools such as Query surge, Soda core 
• Practical experience in building data warehouse and report building in Power BI 
• 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 deal 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 such as incident management, change management, configuration management and operations management 

What IMCO Can Offer You:

We thrive on the challenge to be our best, to deliver an unparalleled employee experience and to work as one team to continuously improve the management of broader public-sector investment funds. In addition to offering a competitive salary and comprehensive benefit package, we pride ourselves on helping you reach your potential, making a difference in our communities, and achieving success that is mutual.

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.