Data Analyst

Lumentum; Ottawa; On-site; CAD 150,000 - 170,000; Full time

Job summary

A leading technology company is seeking a skilled Data Analyst 5 to conduct deep-dive analysis of large datasets, design data models, and build executive-level dashboards using SQL, Databricks, and Tableau. With a minimum of 8 years' experience in data analytics, the ideal candidate will translate analytical findings into actionable recommendations and mentor junior analysts. This is a permanent position based in Ottawa, offering a competitive salary between CAD 150,000 and CAD 170,000, along with comprehensive benefits.

Benefits

Disability insurance

Dental insurance

Extended medical insurance

Qualifications

• Minimum of 8 years of progressive experience in data analytics or business intelligence.
• Expert proficiency in SQL, Databricks, Tableau, and data modeling.
• Strong track record of delivering insights in complex, enterprise environments.
• Proven ability to design executive-ready dashboards and reports.
• Demonstrated experience mentoring and upskilling other analysts.

Responsibilities

• Conduct deep-dive analysis of large datasets to uncover trends, risks, and opportunities.
• Translate analytical findings into actionable recommendations for leaders.
• Design and maintain robust data models in Databricks and SQL.
• Build and optimize executive-level dashboards in Tableau.
• Mentor junior analysts, enhancing the team’s analytical maturity.

Skills

SQL

Databricks

Tableau

Data modeling

Communication

Storytelling

Presentation skills

Business acumen

Education

Bachelor’s degree in computer science, computer engineering, commerce or mathematics

Tools

AWS

Azure

GCP

Python

R

Job description

POSITION

Data Analyst 5

MAIN DUTIES AND RESPONSIBILITIES

• Conduct deep-dive analysis of large, complex datasets to uncover trends, risks, and opportunities;
• Translate analytical findings into actionable recommendations for executive and business leaders;
• Design and maintain robust data models (dimensional, relational, star/snowflake schema) in Databricks and SQL;
• Partner with data engineers to ensure optimized, scalable data pipelines for analytics use cases;
• Build, maintain, and optimize executive-level dashboards in Tableau, ensuring accuracy, usability, and performance;
• Drive consistency and trust in metrics across functions by defining and enforcing reporting standards;
• Mentor junior analysts and elevate the team’s analytical maturity through training, code review, and best-practice sharing;
• Create repeatable analytics frameworks and documentation to scale knowledge across the organization;
• Act as a trusted partner to Sales, Operations, HR, and Manufacturing, providing data-driven insights to guide decisions; and
• Collaborate with leadership to establish KPIs and dashboards that align with corporate goals.

TERMS OF EMPLOYMENT

Permanent

LANGUAGE OF WORK

English

WAGE

CAD 150,000.00 to CAD 170,000.00 per annum based on a 37.5 hour work week. Eligible for discretionary performance-based increase and bonus.

BENEFITS

• Disability insurance, dental insurance and extended medical insurance.

LOCATION(S) OF WORK

61 Bill Leathem Drive, Ottawa, ON K2J 0P

EDUCATION

Bachelor’s degree in computer science, computer engineering, commerce or mathematics

EXPERIENCE & OTHER REQUIREMENTS

• Minimum of 8 years of progressive experience in data analytics or business intelligence;
• Expert proficiency in SQL, Databricks, Tableau, and data modeling;
• Strong track record of delivering insights in complex, enterprise environments;
• Proven ability to design executive-ready dashboards and reports;
• Demonstrated experience mentoring and upskilling other analysts;
• Strong business acumen with the ability to bridge technical and non-technical stakeholders;
• Excellent communication, storytelling, and presentation skills;
• Experience in technology, manufacturing, or telecommunications industries;
• Familiarity with cloud data platforms (AWS, Azure, or GCP); and
• Knowledge of Python or R for advanced analytics.

CONTACT US: [e-mail]