Data Analyst

Connor, Clark & Lunn Financial Group (CC&L); Vancouver; Hybrid; CAD 110,000 - 130,000; Full time

Job summary

CC&L Financial Group seeks a Data Analyst to join the Enterprise Data Solutions team. You will analyze data across enterprise systems, build scalable data models, support reporting, analytics, and integrations, and collaborate with business and technology partners to ensure data quality and enable enterprise-wide data initiatives.

The role involves working with Salesforce, Dayforce, and Greenhouse, and requires strong SQL, API testing, and data validation skills, in a hybrid environment with

Qualifications

• 3–5 years of experience in data analysis, business systems analysis, data integration, or a related technology role.
• Strong SQL skills and querying relational data.
• Experience with Salesforce, Dayforce, Greenhouse, or similar CRM/ATS/HRIS platforms.
• Experience with REST APIs and JSON; API testing tools like Postman.
• Experience with Power BI or other analytics platforms.
• Exposure to cloud data platforms and data warehouses.

Responsibilities

• 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.
• Design and develop scalable data models and data structures for reporting, analytics, and integrations.
• Define and validate data transformation rules with data engineers.
• Test and validate REST APIs, integrations, and data flows between 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.
• Identify opportunities to improve data usability, consistency, and operational efficiency.

Skills

SQL

REST API testing

Data modeling

Data quality analysis

Analytical thinking

Documentation

Stakeholder management

Power BI

Python

Agile

Tools

Salesforce

Dayforce

Greenhouse

Postman

Job 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.

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.