Senior Data Analyst

TEEMA; Markham; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Data Analyst based in Markham, Ontario, to collaborate with stakeholders, define data requirements, and develop insightful reports and dashboards. The ideal candidate must possess strong expertise in SQL and SSIS, with a track record of building reports using Tableau.

Qualifications

• Minimum 5 years of hands-on experience in data analysis and report development.
• Strong expertise in SQL and SSIS is a must.
• Proven experience building reports and dashboards using Tableau.

Responsibilities

• Collaborate with business stakeholders to gather and document user stories.
• Design and write complex SQL queries for analysis and reporting.
• Build and maintain reports and dashboards in Tableau.

Skills

SQL

SSIS

Data Analysis

Reporting

Analytical Thinking

Problem-Solving

Communication

Tools

Tableau

Job description

Job Title:Senior Data Analyst
Job ID:81731
Location:Markham, Ontario –Hybrid 1-Day a week

Overview:
We are seeking a highly skilled Senior Data Analyst with a strong background in business data analysis, SQL development, and reporting. This role will work closely with business stakeholders to gather requirements, define user stories, and help shape data solutions that align with business objectives. The ideal candidate is an excellent communicator, technically proficient, and experienced in translating business needs into actionable insights and technical requirements.

What you will be doing:

• Collaborate with business stakeholders to capture, refine, and document user stories and data requirements

• Map business requirements to data and participate in defining data models in collaboration with data engineers

• Create prototypes and proof-of-concept dashboards using Tableau and SQL

• Translate complex business logic into clear and actionable data tasks for engineering teams

• Design and write complex SQL queries for analysis and reporting

• Develop, maintain, and troubleshoot complex SSIS packages including data flow, control flow, and error handling

• Perform basic unit testing and assist in business acceptance testing (BAT)

• Document business rules, data transformations, and reporting logic

• Build and maintain reports and dashboards in Tableau to support business decision-making

What you must have:

• Minimum 5 years of hands-on experience in data analysis and report development

• Strong expertise in SQL and SSIS – must-have

• Solid understanding of SSIS components including data flow tasks, control flow, and error handling

• Proven experience building reports and dashboards using Tableau

• Strong analytical thinking and problem-solving skills

• Excellent communication skills with the ability to work closely with both technical and non-technical stakeholders

• Ability to articulate business logic clearly and collaborate effectively with data engineers and developers

• Experience participating in or contributing to data modeling activities is a strong plus

• Detail-oriented with the ability to perform unit testing and support user acceptance testing

• Clearance Requirement:Active Security Clearance required or must be eligible for Reliability Security Clearance

For more information about TEEMA and to consider other career opportunities, please visit our website atwww.teemagroup.com