Data Analyst
Summary
Builds and maintains scalable data solutions for a financial services firm, integrating enterprise systems (Salesforce, Dayforce) to support business decisions via analytics, API testing, and data quality improvements.
Interested in joining one of Canada's top performing asset managers? We are looking for a Data Analyst to join our Enterprise Data Solutions team. In this role, you'll help build integrated, reliable, and scalable data solutions that support business decision-making across the organization. Working with enterprise platforms such as Salesforce, Greenhouse, and Dayforce, you'll collaborate with business and technology partners to analyze data, support system integrations, improve data quality, and contribute to impactful enterprise-wide data initiatives. If you're curious, analytical, and enjoy working at the intersection of business, data, and technology, this could be an exciting next step in your career. Our offices operate on a hybrid model with three days per week in-office to support team collaboration.
What You Will Do
- Analyze and profile data across enterprise systems to identify trends, issues, and opportunities for improvement.
- Partner with business and technology stakeholders to gather requirements and translate them into data solutions.
- Support the design and development of scalable data models and data structures for reporting, analytics, and integrations.
- Collaborate with data engineers and application teams to define and validate data transformation rules.
- Test and validate REST APIs, integrations, and data flows between business applications and data platforms.
- Perform data quality, reconciliation, and validation activities to ensure accuracy and completeness of information.
- Develop and execute test cases for data mappings, APIs, and end-to-end integration processes.
- Document data models, mappings, integration requirements, and technical processes.
- Participate in Agile delivery activities, including testing, defect resolution, and release validation.
- Help identify opportunities to improve data usability, consistency, and operational efficiency across the organization.
What You Bring
- 3-5 years of experience in data analysis, business systems analysis, data integration, or a related technology role.
- Strong SQL skills with experience querying and analyzing relational data.
- Experience working with enterprise applications such as Salesforce, Dayforce, Greenhouse, or similar CRM, ATS, HRIS, or SaaS platforms.
- Knowledge of relational data modelling concepts and data integration principles.
- Experience working with and testing REST APIs, including JSON and API testing tools such as Postman.
- Strong experience in data validation, reconciliation, and data quality analysis.
- Excellent analytical, problem-solving, and troubleshooting skills.
- Ability to document requirements, data mappings, testing activities, and technical processes.
- Strong communication and stakeholder management skills, with the ability to work across technical and non-technical teams.
- Familiarity with Agile delivery practices and software development lifecycles.
- Experience with Power BI or other reporting and analytics platforms.
- Experience with Python or another scripting language.
- Exposure to cloud-based data platforms, data warehouses, or modern data technologies.
- Experience working with HR, recruiting, CRM, finance, or other enterprise business data.
- Financial services or other regulated industry experience.
The starting salary for this position is $110,000 - $130,000. The starting salary provided reflects the base salary 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.
#LI-HYBRID #LI-SM2
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.
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.
As published by greenhouse
First Name, Last Name, Email, Phone, Resume/CV, Cover Letter
- Preferred First Name optional
- LinkedIn Profile optional
- Website optional
- Have you been employed by Connor, Clark & Lunn Financial Group or any associated affiliates in the past? choose one
- Acknowledgement of Privacy Policy choose one
- Review and acknowledge how we handle your data choose one
- Have you applied to any roles at Connor, Clark & Lunn Financial Group or any associated affiliates in the past 6 months? choose one · optional
- Are you legally eligible to work in the country of the role you are applying to? choose one
- Which of the following enterprise platforms have you worked with professionally? (Select all that apply) choose any
- How many years of professional experience do you have using SQL to analyze and query relational databases? choose one
- This position follows a hybrid work model that requires employees to work in the Vancouver office three days per week. Are you able to meet this requirement? choose one
- Which reporting and analytics platforms have you used? Please indicate your level of experience with each. choose any
- Which types of business data have you worked with most extensively? (Select all that apply) choose any