Data Analyst
Description
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-SM1
What We Offer
At Connor, Clark & Lunn Financial Group, we’re "invested in our greatest asset, you". Our shared goals reflect what matters most to our people:
- Your community: we foster belonging through collaboration, inclusion and flexibility. Enjoy social events, volunteering and a strong commitment to corporate social responsibility. Our flexible work practices are designed to support work-life balance and provide employees with flexibility in where and how they work
- Your growth: we prioritize your development with meaningful work, continuous learning budgets, paid study days and support for professional designations.
- Recognizing you: your contributions are rewarded with competitive total compensation, retirement savings support, wellness credits, enhanced parental leave, and comprehensive health benefits.
For a closer look at how you can build your career with us, we invite you to explore cclgroup.com.
We are committed to providing an inclusive, accessible recruitment and selection process. We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the recruitment and selection process. Please contact [email protected] if you require accommodation.
AI may be used to support certain stages of our screening & recruitment process. These tools support, but do not replace, human judgment and decision-making.
Skills
As published by greenhouse · 14 questions · 1 written answer
Basics
First Name, Last Name, Email, Phone, Resume/CV, Cover Letter
Short answers (3)
- Preferred First Name optional
- LinkedIn Profile optional
- Website optional
Pick from a list (10)
- Have you been employed by Connor, Clark & Lunn Financial Group or any associated affiliates in the past?
- Acknowledgement of Privacy Policy
- Review and acknowledge how we handle your data
- Which of the following enterprise platforms have you worked with professionally? (Select all that apply)
- How many years of professional experience do you have using SQL to analyze and query relational databases?
- 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?
- Which reporting and analytics platforms have you used? Please indicate your level of experience with each.
- Which types of business data have you worked with most extensively? (Select all that apply)
- Are you currently entitled to work in the country to which you are applying on an ongoing basis (that is, with no end date) and without limitation (for instance, not on a study permit with hours of work limitation or on a work permit that ties you to a specific employer)?
- By submitting this application form, you acknowledge (1) that the information provided by you is accurate to the best of your knowledge, and (2) that a job offer or any employment provided to you by Connor, Clark & Lunn Financial Group is contingent on you having provided accurate information. Any information provided that is incorrect may impact the hiring decision. If the inaccuracy of any information is discovered after you are offered employment, your employment offer may be rescinded. If the inaccuracy of any information is discovered after you are hired, your employment may be terminated with immediate effect.
Written answers (1)
- If your answer to the above question is “No” or if you are unsure how to answer the above question, please provide a full explanation below including information relating to your ability to work in the country of the role which you are applying, information relating to the type of work permit you are on (if applicable) and its validity dates (start and end dates), and any other relevant information. If your answer to the above question is "Yes", please enter "N/A" into the text box below.