Analyst, Data Analytics & Modelling

Crestpoint Real Estate Investments

Job Location:

Toronto - Canada

Monthly Salary: $ 95 - 100

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Analyst Data Analytics & Modelling

Connor Clark & Lunn Infrastructure

Toronto ON

Interested in joining one of Canadas 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 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.

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.

Required Experience:

Analyst Data Analytics & ModellingConnor Clark & Lunn InfrastructureToronto ONInterested in joining one of Canadas 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 M...