Data Analyst

Connor Clark and Lunn Financial Group

$110K — $130K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-5 years in data analysis or related technology role
  • Strong SQL skills for relational data analysis
  • Experience with enterprise applications like Salesforce or Greenhouse
  • Knowledge of relational data modeling and integration principles
  • Familiarity with REST APIs and testing tools like Postman
  • Strong skills in data quality validation and reconciliation
  • Excellent problem-solving and communication skills

Responsibilities

  • Analyze data across systems to identify trends and improvement opportunities
  • Partner with stakeholders to gather requirements for data solutions
  • Support design and development of data models for reporting and analytics
  • Collaborate with engineers to define data transformation rules
  • Test and validate data flows between business applications
  • Perform data quality checks to ensure accuracy of information
  • Document models and integration processes involved in data solutions
  • Participate in Agile testing and release activities

Benefits

  • Hybrid work model with three days in-office for team collaboration
  • Annual performance bonus
  • Opportunity to work with leading enterprise data solutions
  • Engagement with cross-functional teams in a dynamic environment
  • Exposure to modern data technologies and software development practices
Full Job Description
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.

Similar Jobs

More Jobs at Connor Clark and Lunn Financial Group

  • Data Analyst
    $110K — $130K *
    Vancouver, BC V5K 5J9
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Data Analyst jobs: