Senior Data Analyst

Lookout; Ottawa; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Comprehensive healthcare benefits

Paid parental leave

Fitness reimbursement

Company match for charitable donations

Cell phone reimbursement

Work-from-home support

Job summary

Lookout in Ottawa, Ontario is seeking a Senior Data Analyst to lead the analytics function as the sole Data Analyst. You will partner with teams across the organization to turn business, product, and security data into actionable insights, develop executive dashboards in Tableau, and support decision-making through advanced SQL on AWS Athena.

You will analyze business operations, customer behavior, product telemetry, and security event data, drive KPIs, and present clear recommendations to

Qualifications

• Bachelor’s degree or higher in a related field.
• 5+ years of analytics or BI experience in technology, mobile apps, cybersecurity, or related environment.
• Advanced SQL proficiency and experience with complex relational datasets.
• Experience with AWS Athena or similar cloud-based query engines.
• Experience analyzing software product telemetry, usage, or operational data.

Responsibilities

• Lead the company’s reporting and analytics function as the sole Data Analyst.
• Partner with cross-functional teams to turn data into actionable insights.
• Develop and maintain executive dashboards and operational reports using Tableau.
• Analyze business operations, customer behavior, product telemetry, and security event data to support decision-making.
• Define and monitor KPIs and provide recommendations for product and business improvements.
• Translate complex data findings into clear insights for technical and non-technical audiences.

Skills

SQL

Analytical thinking

Problem solving

Communication skills

Tableau

AWS Athena

Python

Data storytelling

Data modeling

Education

Bachelor’s degree in Computer Science / Information Systems / Data Analytics / Statistics / Mathematics / Business

Tools

Tableau

AWS Athena

Python

Job description

• We are looking for a Senior Data Analyst to lead the company’s reporting and analytics function. As the sole Data Analyst, this role serves as an internal analytics consultant, partnering with teams across the organization to turn business, product, and security data into actionable insights
• The Senior Data Analyst analyzes business operations, customer behavior, mobile application telemetry, and security event data to support decision-making, measure product performance, identify trends, and inform strategic planning
• They also contribute to financial reporting, assisting with quarter-end close, invoicing and reconciliation. Success in this role requires advanced SQL skills, strong analytical and problem-solving abilities, independence, and excellent communication skills
• Develop and maintain executive dashboards and operational reports using Tableau
• Analyze and contextualize:
• Business metrics including revenue, customer growth, subscriptions, retention, product adoption, and operational performance
• Mobile application telemetry, customer behavior, product usage, and feature adoption
• Security event data to monitor threats, trends, anomalies, and product effectiveness
• Partner with Finance, Sales, Customer Success, Product Management, Engineering, and Security Intelligence to address recurring and ad hoc analytical needs
• Define and monitor KPIs and identify trends and opportunities for business and product improvement
• Translate complex data findings into clear insights and recommendations for technical and non-technical audiences
• Write efficient SQL queries in AWS Athena to extract and analyze large datasets stored in Amazon S3
• Integrate data from multiple internal systems to develop meaningful reporting and analytical solutions
• Design, develop, publish, and maintain Tableau dashboards used throughout the organization
• Ensure data accuracy, consistency, and integrity
• Document data sources, business rules, report definitions, and analytical methodologies
• Identify opportunities to automate recurring reporting and analysis
• Success in this role means becoming a trusted analytics partner across the organization. The Senior Data Analyst will deliver accurate, timely, and actionable insights; proactively identify opportunities for improvement; and continuously enhance the company’s reporting and analytical capabilities

Benefits

• Comprehensive healthcare benefits
• Paid parental leave
• Fitness reimbursement
• Company match for charitable donations
• Cell phone reimbursement
• Work-from-home support
• Anniversary awards
• All-hands gatherings
• Community groups
• Team-building activities
• Paid time off
• Volunteer time off
• Company holidays
• Global holiday shutdown

Ability to manage multiple priorities and projects with minimal supervisionStrong analytical, problem-solving, and critical-thinking skills5+ years of experience delivering analytics or business intelligence solutions in technology, mobile applications, cybersecurity, or a related environmentExpert-level SQL proficiency and experience working with complex relational datasetsExperience with AWS Athena or a similar cloud-based analytical query engineStrong understanding of relational databases and data modelingAdvanced Tableau or equivalent BI platform experienceBachelor’s degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, Business, or a related field, or equivalent experienceAbility to translate complex data into clear business insights and recommendationsExperience working with large-scale datasets in cloud environmentsExperience analyzing software product telemetry, application usage, or operational event dataExcellent written and verbal communication skillsFamiliarity with AI-enabled tools and workflows for automating reporting and analysisKnowledge of data governance and data quality practicesExperience in cybersecurity, mobile applications, and/or SaaSExperience with Python or R for statistical analysis, data exploration, and automation