Data Analyst

800 McAteer Employee Benefit Plan Services Limited; Markham; On-site; CAD 60,000 - 70,000; Full time

Benefits offered by this job

Extended benefits

Retirement plan with company contrib

Health & Wellness programs

Mental health support

Educational support for designations

Competitive compensation

Job summary

People Corporation is seeking a Data Analyst to support management in administering group insurance, health benefits, and pension plans. The role involves data management, analysis, and reporting metrics in our Toronto office.

Responsibilities include generating exports, developing queries, data quality assurance, and presenting insights to executives. Collaboration with business partners in financial services is key, with a base salary in a competitive range.

Qualifications

• 2–3 years of experience in an analyst role.
• Strong analytical and problem-solving skills.
• Advanced Microsoft Excel experience.
• Proficient knowledge of MS Word and PowerPoint.
• Excellent oral and written communication skills.
• Database management experience.
• UAT and data conversion experience is an asset.
• Experience collaborating with business partners to understand data requirements in the financial services industry.

Responsibilities

• Generate data exports and reports by developing queries to retrieve data and ensure data quality.
• Perform data analysis to present meaningful data for the management and executive team.
• Ad-hoc data integrity cleanup projects as required.

Skills

Analytical skills

Problem solving

Advanced Excel

MS Word

PowerPoint

Communication skills

Database management

User Acceptance Testing

Data conversion

Collaboration with business partners

Financial services experience

Job description

We are seeking a Data Analyst to work in our Toronto office providing support to our management staff in the administration of group insurance and self-funded health benefits and both defined benefit and defined contribution pension plans. The successful candidate will play a role in data management, data analysis, and reporting metrics.

The Data Analyst will:

• Generate data exports and reports by developing queries to retrieve data from the databases and ensuring data quality and assurance
• Perform data analysis to present meaningful representation of data for the management and executive team
• Ad-hoc data integrity cleanup projects as required

To be successful as a Data Analyst with People Corporation, you will need:

• 2-3 years of experience in an analyst role
• Strong analytical and problem-solving skills
• Experience organizing and managing data with Microsoft Excel. (Advanced level user of Excel)
• Proficient knowledge of MS Word and PowerPoint
• Excellent oral and written communication skills
• Database management experience
• User Acceptance testing and data conversion experience an asset
• Recent and significant experience working collaboratively with business partners to understand, analyze, and articulate data requirements and recommend solutions, gained while working in the financial services industry.

What’s in It for You

Learn by working alongside our experts

• Extended health care and dental benefits
• A retirement savings plan with company contributions
• A suite of Health & Wellness offerings
• Mental Health programs and support for you and your family
• Assistance for the completion of industry designations
• Competitive compensation

The McAteer Group of Companies has provided leadership in consulting, administration and governance advisory services for group health and pension plans since 1980. McAteer provides third-party advisory and administration services for over 200,000 plan members and beneficiaries. We are authorized claims payors for several major insurance companies; we provide administration services to plans that are local, provincial, and national in scope.

The base salary for this position is between $60,000 - $70,000 annually. This represents base salary only and does not represent other variable compensation components of our total compensation (i.e. annual bonus, commission). The actual base salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are selected to move forward in our recruitment process, the Talent Acquisition Specialist will be able to provide additional details of the total compensation for this role.

Providing an inclusive, accessible environment, where all employees and clients feel valued, respected and supported is something we're committed to. We are dedicated to building a workforce that reflects the diversity of the communities in which we live, and to creating an environment where every employeehas the opportunity toreach their potential.

If you require an accommodation or an alternative format of any posting please reach out to [e-mail]

We know that it's the vast expertise and commitment of our teams in People Corporation and our Partner Firms that have put us where we are today. We value our employees and provide competitive salaries, a comprehensive group benefits plan, and a generous retirement savings plan. And we're in it for the long haul - once you join us, we want you to thrive. If you want to make a difference in the lives of customers, if you take pride in a job well done, and if you like to have fun, talk to us.

Providing an inclusive, accessible environment, where all employees and clients feel valued, respected and supported is something we're committed to. We are dedicated to building a workforce that reflects the diversity of the communities in which we live, and to creating an environment where every employeehas the opportunity toreach their potential. If you require an accommodation or an alternative format of any posting please reach out to [e-mail].

For more information on Accessibility at People Corporation, visit our link https://www.peoplecorporation.com/en-ca/accessibility-statement.