Senior Data Analyst

Adastra Corporation; Markham; Hybrid; CAD 70,000 - 90,000; Part time

Job summary

A consulting company is seeking a highly skilled Senior Data Analyst to work closely with business stakeholders. You will gather requirements, define user stories, and help shape data solutions. The ideal candidate has strong expertise in SQL and SSIS, a solid understanding of data flow tasks, and proven experience building reports using Tableau. This contract position is hybrid, requiring 1 day on-site work per week.

Qualifications

• Must have Reliability Clearance or eligible to obtain clearance.
• Proven experience building reports and dashboards using Tableau.
• Detail-oriented with the ability to perform unit testing and support user acceptance testing.

Responsibilities

• Collaborate with stakeholders to capture and document user stories.
• Map business requirements to data and define data models.
• Create prototypes and dashboards using Tableau and SQL.

Skills

SQL

SSIS

Tableau

Analytical thinking

Communication skills

Job description

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.

Location : Hybrid 1-Day onsite

Status : Contract

Responsibilities

• 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

Qualifications

• Must have Reliability Clearance or eligible to obtain clearance
• Strong expertise in SQL and SSIS
• 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

About Adastra

For more than 25 years Adastra Corporation has been hyper-focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation and Enterprise Application Development. Our team of experts, combined with our world-class data management platform, helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes for around-the-clock global coverage. Adastra has a proven track record of helping organizations of all sizes achieve their data transformation goals, whether accelerating innovation, improving operational excellence, or creating unforgettable customer experiences.

Equal Opportunity Employer

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in applicable laws. Accommodation will be provided during the hiring process where required. Adastra Corporation’s implementation and support of employment initiatives encourage diversified labor force participation and equal access to opportunities based on merit and performance.