Data Analyst, Investment Data Architecture
About the role
Data Analyst, Investment Data Architecture
Connor, Clark & Lunn Financial Group Ltd.
Vancouver, BC
Interested in joining one of Canada’s top performing asset managers? We are looking for a Data Analyst to join our Vancouver-based Investment Data Architecture (IDArch) team.
The IDArch Team resides within the middle office and works on projects to enhance data management capabilities across the organization. Our focus includes leading Modern Data Platform (MDP) initiatives, building comprehensive metadata management frameworks, and acting as primary owners of the Investment Data Management platform, including security master, pricing master, and market reference data systems. This is a fantastic opportunity to be part of a dynamic strategic team whose scope and influence are growing enterprise wide.
We value an entrepreneurial spirit and maintain a collaborative culture where every individual can contribute to success. Our team thrives in a fast-paced environment with a focus on delivering impactful solutions. Our offices currently operate on a hybrid model with a combination of in office and remote working days throughout the week
What You Will Do
The IDArch Analyst is the bridge between system developers, the investment data management team, and key stakeholders including investment teams. As a business lead on MDP initiatives, you will work closely with investment managers, enterprise project team and various middle and back-office business units. You will leverage your financial and technical knowledge to provide critical investment data inputs across the investment operations process. Key responsibilities include:
- Establish Metadata Management Framework: Lead the development of metadata management practices, including the creation of data lineage models, data cataloging, and data dictionary to ensure transparency, accessibility, and governance across all data assets.
- Understand Data Models: Convert business requirements into conceptual and logical data models in cloud platforms like Fabric and Snowflake. Explain data modeling concepts to non-technical stakeholders and support their use across business units.
- Implement Data Architecture Solutions: Collaborate on developing data integration systems, ETL processes, and centralizing data from multiple sources. Establish data governance strategies in partnership with data architects, engineers, and key stakeholders.
- Enhance Security Master Data Management: Develop and reengineer processes to maintain the accuracy and integrity of equity, fixed income, and derivative data within the security master system, ensuring consistency across multiple systems and databases.
- Project Management: Lead or contribute to various strategic projects in collaboration with operational, engineering, and senior management teams.
- Assess Current Tools and Data Management Needs: Analyze existing data management tools and infrastructure to identify gaps and opportunities for improvement.
- Optimize Data Workflows: Innovate and improve data workflows related to vendor systems, internal and market data transfers, valuation, and benchmarking, enhancing efficiency and reliability across all data processing operations.
- Advance Data Quality Assurance: Implement strategies to improve data quality, resolving data-quality exceptions, and upholding high standards of accuracy.
What You Bring
- Education: A degree in Finance, Data Science, Business Analysis or a related field. Designations such as CFA or FRM are an asset.
- Industry Experience: Previous exposure to investment management, ideally with experience in equity, fixed income, or derivative data. Previous experience implementing an Enterprise Data Management (EDM) platform is a plus.
- Business and Technical Analysis: Strong ability to assess data management requirements and align them with business needs. Data centric project experience in a fast-paced environment is valuable.
- Technical Skills: Familiarity with SQL, Python/PySpark and Lakehouse architecture for modern data pipelines is beneficial. Experience with data modeling in Fabric, Snowflake, or other cloud environments will be an asset.
- Data Governance & Metadata Management: Understanding of data governance framework and experience with metadata management tools such as MS Purview or Solidatus is a plus.
- Data Science Acumen: Ability to work with large, complex datasets and derive meaningful insights.
- Communication & Collaboration: Excellent communication skills with the ability to work across teams and with various stakeholders. Collaborative mindset with a focus on delivering results.
- Accountability & Ownership: Demonstrated ability to take initiative and deliver outcomes with measurable results.
The salary range for this position is $75,000-$95,000. The salary range provided reflects the base salary range for this position as required by legislation*.* In addition, there is an annual performance bonus which contributes to the total compensation of 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 $155 billion in client assets, providing a diverse range of traditional and alternative investment products and solutions to institutional, high-net-worth and retail clients.
For a closer look at how you can build your career with us, we invite you to explore cclgroup.com.
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.
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.
#LI-HYBRID #LI-JB1
About Connor, Clark & Lunn Financial Group (CC&L)
At Connor, Clark & Lunn Financial Group, we understand the value of opportunity for both 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 manage over C$132 billion in assets and offer a diverse range of traditional and alternative investment products and solutions to institutional, high-net-worth and retail clients.
A career here can look different for everyone, but every path is rooted in our commitment to invest in our greatest asset – you. We prioritize community, personal growth and recognition to create an environment where you can thrive. For more information on building your career with us, visit our website.
Data Analyst, Investment Data Architecture
About the role
Data Analyst, Investment Data Architecture
Connor, Clark & Lunn Financial Group Ltd.
Vancouver, BC
Interested in joining one of Canada’s top performing asset managers? We are looking for a Data Analyst to join our Vancouver-based Investment Data Architecture (IDArch) team.
The IDArch Team resides within the middle office and works on projects to enhance data management capabilities across the organization. Our focus includes leading Modern Data Platform (MDP) initiatives, building comprehensive metadata management frameworks, and acting as primary owners of the Investment Data Management platform, including security master, pricing master, and market reference data systems. This is a fantastic opportunity to be part of a dynamic strategic team whose scope and influence are growing enterprise wide.
We value an entrepreneurial spirit and maintain a collaborative culture where every individual can contribute to success. Our team thrives in a fast-paced environment with a focus on delivering impactful solutions. Our offices currently operate on a hybrid model with a combination of in office and remote working days throughout the week
What You Will Do
The IDArch Analyst is the bridge between system developers, the investment data management team, and key stakeholders including investment teams. As a business lead on MDP initiatives, you will work closely with investment managers, enterprise project team and various middle and back-office business units. You will leverage your financial and technical knowledge to provide critical investment data inputs across the investment operations process. Key responsibilities include:
- Establish Metadata Management Framework: Lead the development of metadata management practices, including the creation of data lineage models, data cataloging, and data dictionary to ensure transparency, accessibility, and governance across all data assets.
- Understand Data Models: Convert business requirements into conceptual and logical data models in cloud platforms like Fabric and Snowflake. Explain data modeling concepts to non-technical stakeholders and support their use across business units.
- Implement Data Architecture Solutions: Collaborate on developing data integration systems, ETL processes, and centralizing data from multiple sources. Establish data governance strategies in partnership with data architects, engineers, and key stakeholders.
- Enhance Security Master Data Management: Develop and reengineer processes to maintain the accuracy and integrity of equity, fixed income, and derivative data within the security master system, ensuring consistency across multiple systems and databases.
- Project Management: Lead or contribute to various strategic projects in collaboration with operational, engineering, and senior management teams.
- Assess Current Tools and Data Management Needs: Analyze existing data management tools and infrastructure to identify gaps and opportunities for improvement.
- Optimize Data Workflows: Innovate and improve data workflows related to vendor systems, internal and market data transfers, valuation, and benchmarking, enhancing efficiency and reliability across all data processing operations.
- Advance Data Quality Assurance: Implement strategies to improve data quality, resolving data-quality exceptions, and upholding high standards of accuracy.
What You Bring
- Education: A degree in Finance, Data Science, Business Analysis or a related field. Designations such as CFA or FRM are an asset.
- Industry Experience: Previous exposure to investment management, ideally with experience in equity, fixed income, or derivative data. Previous experience implementing an Enterprise Data Management (EDM) platform is a plus.
- Business and Technical Analysis: Strong ability to assess data management requirements and align them with business needs. Data centric project experience in a fast-paced environment is valuable.
- Technical Skills: Familiarity with SQL, Python/PySpark and Lakehouse architecture for modern data pipelines is beneficial. Experience with data modeling in Fabric, Snowflake, or other cloud environments will be an asset.
- Data Governance & Metadata Management: Understanding of data governance framework and experience with metadata management tools such as MS Purview or Solidatus is a plus.
- Data Science Acumen: Ability to work with large, complex datasets and derive meaningful insights.
- Communication & Collaboration: Excellent communication skills with the ability to work across teams and with various stakeholders. Collaborative mindset with a focus on delivering results.
- Accountability & Ownership: Demonstrated ability to take initiative and deliver outcomes with measurable results.
The salary range for this position is $75,000-$95,000. The salary range provided reflects the base salary range for this position as required by legislation*.* In addition, there is an annual performance bonus which contributes to the total compensation of 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 $155 billion in client assets, providing a diverse range of traditional and alternative investment products and solutions to institutional, high-net-worth and retail clients.
For a closer look at how you can build your career with us, we invite you to explore cclgroup.com.
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.
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.
#LI-HYBRID #LI-JB1
About Connor, Clark & Lunn Financial Group (CC&L)
At Connor, Clark & Lunn Financial Group, we understand the value of opportunity for both 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 manage over C$132 billion in assets and offer a diverse range of traditional and alternative investment products and solutions to institutional, high-net-worth and retail clients.
A career here can look different for everyone, but every path is rooted in our commitment to invest in our greatest asset – you. We prioritize community, personal growth and recognition to create an environment where you can thrive. For more information on building your career with us, visit our website.