Analyst, Data Analytics & Modelling

Connor, Clark & Lunn Infrastructure

Toronto, ON

Interested in joining one of Canada’s top performing and fastest growing infrastructure investment teams? Connor, Clark & Lunn Infrastructure (“CC&L Infrastructure”) is seeking an Analyst to fill an existing role in our Asset Management Team. As a member of a collaborative, highly-motivated and performance-driven team, you will own the automation of reporting and monitoring workflows across our renewable energy portfolio, while developing the aptitude to enable broader AI adoption across the organization. You will work closely with the Director of Asset Management to build reliable, parameter-driven data pipelines that connect operational data to portfolio-level views that enable valuable decision making. This is an opportunity to work at the intersection of infrastructure investing and modern data automation. Our offices currently operate on a hybrid model with a combination of in office and remote working days throughout the week.

Responsibilities

• Build and maintain automated data collection pipelines for asset (Solar, Wind, Hydro) monitoring and reporting, including data ingestion, validation, and output generation;
• Build and maintain financial and operating models in Microsoft Excel;
• Automate monthly workflows by developing integrations between external data sources with internal work-product;
• Develop and maintain integrations to pull data from a variety of sources (API, SFTP, external databases);
• Implement validation layers with variance alerts and exception logging to ensure data integrity;
• Create and maintain site configuration registries so that adding new assets requires config updates only, not code changes;
• Contribute to AI enablement initiatives, including prototyping LLM-powered workflows; and
• Document data lineage, create runbooks, and support knowledge transfer to ensure operational continuity.

Qualifications

• Undergraduate degree in a quantitative field (engineering, computer science, finance, mathematics, or related);
• 1-3 years of experience working with financial models (e.g. MS Excel, Power BI);
• 1-3 years of experience working with data processing (e.g. pandas, openpyxl, pySpark, SQL);
• Demonstrated ability to wrangle heterogeneous data from multiple sources;
• Experience with Microsoft Fabric or similar data platforms is an asset;
• Hands-on experience using LLMs and AI tools (ChatGPT, GitHub Copilot, Claude) for practical work tasks;
• Strong problem-solving mindset with attention to detail and data quality;
• Excellent communication skills and ability to explain technical work to non-technical stakeholders; and
• Interest in infrastructure and energy markets; prior exposure is an asset but not required.

The salary range for this position is $95k - $100k. The salary range provided reflects the base salary range for this position as required by legislation. In addition, there is a discretionary annual performance bonus which may represent a significant proportion of total compensation for this position. Further questions may be directed to the HR team during the interview process.

About Connor, Clark & Lunn Financial Group

At CC&L Financial Group, we understand the value of opportunity – for our clients and our team. Independent and employee-owned, we partner with investment professionals to grow successful asset management businesses, giving them the space to innovate and truly make an impact. With more than 40 years of history and offices across Canada and in the US, the UK and India, CC&L Financial Group and our multi-boutique family of affiliate firms collectively manage over $179 billion in client assets, providing a diverse range of traditional and alternative investment products and solutions to institutional, high-net-worth and retail clients.

About Connor, Clark & Lunn Infrastructure

CC&L Infrastructure is part of the Connor, Clark & Lunn Financial Group. We are an active owner and operator of middle-market infrastructure assets with more than 20 years of experience. We manage over $7 billion in assets under management on behalf of a wide range of high-net-worth and institutional investors such as pensions, endowments and foundations, indigenous trusts, insurance companies and corporations, among others. Our diversified portfolio represents more than 100 individual infrastructure facilities, including roads, rail, hospitals, airports, solar, hydro and wind generation facilities, among others.

By joining us, you will make a real impact by working on important and challenging projects that contribute meaningfully to our business. For a closer look at how you can begin building the foundation for your future, we invite you to explore our website.

CC&L Financial Group is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to gender, ethnicity, religion, sexual orientation or expression, disability, or age.

To apply for this position, please submit your resume and cover letter as one PDF.

Your application will be reviewed by a member of the hiring team - AI is not used in the screening, assessment or selection of applications at this time.

We thank all applicants in advance for their interest, but only those candidates shortlisted for interviews will be contacted. No telephone calls or recruitment agencies will be accepted.