Senior Data Analyst

Lumentum; Ottawa; On-site; CAD 85,000 - 110,000; Full time

Job summary

A leading technology company in Ottawa, Canada is seeking a Data Analytics expert with over 7 years of experience. The successful candidate will conduct deep-dive analyses of complex datasets and create executive dashboards using SQL and Tableau. Mentorship and collaboration with cross-functional teams are essential. This position offers an exciting opportunity to work in a dynamic environment focused on delivering actionable insights. Ideal for those passionate about data-driven decision-making.

Qualifications

• 7 plus years of progressive experience in data analytics or business intelligence.
• Expert proficiency in SQL, Databricks, Tableau, and data modeling.
• Track record of delivering insights in complex, enterprise environments.

Responsibilities

• Conduct deep-dive analysis of datasets to uncover trends and risks.
• Design and maintain data models in Databricks and SQL.
• Build and optimize executive dashboards in Tableau.
• Mentor junior analysts and elevate analytical maturity in team.

Skills

SQL

Data modeling

Tableau

Databricks

Communication skills

Analytical thinking

Job description

It's fun to work in a company where people truly BELIEVE in what they're doing!
We're committed to bringing passion and customer focus to the business.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Lumentum Canada was awarded the 2022 National Capital Region’s Top Employers for the 6th consecutive year and the 2022 Career Directory Canada’s Best Employers for Recent Graduates for the 5th consecutive year.

Key Responsibilities

• Advanced Analytics & Insights

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.

• Data Modeling & Engineering Collaboration

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.

• Executive Reporting & Visualization

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.

• Upskilling & Team Development

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.

• Cross-Functional Business Partnership

Act as a trusted partner to Sales, Operations, HR, and Manufacturing, providing data-driven insights to guide decisions.

Collaborate with leadership to establish KPIs and dashboards that align with corporate goals.

Qualifications

• 7 plus 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.
• 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.

Preferred Qualifications

• Experience in technology, manufacturing, or telecommunications industries.
• Familiarity with cloud data platforms (AWS, Azure, or GCP).
• Knowledge of Python or R for advanced analytics