Business Intelligence & Data Systems Analyst

Labtician Ophthalmics Inc.; Oakville; Hybrid; CAD 70,000 - 85,000; Full time

Job summary

Labtician Ophthalmics Inc. in Oakville, Ontario, is seeking a Business Intelligence & Data Systems Analyst to manage data platforms (Snowflake, Fivetran, Census, Veeva CRM) and partner with business stakeholders to develop KPIs, dashboards, and standardized reporting.

You will ensure data integrity, accessibility and actionable decision support, while designing scalable analytics solutions and ensuring consistent metrics across the organization.

Qualifications

• Bachelor's degree in Business, Data Analytics, Computer Science, Information Systems, Statistics, or a related field.
• 3-7 years of experience in business intelligence, analytics, data management, or a related role.
• Strong experience with Qlik Sense dashboard development and reporting.
• Experience working with cloud-based data warehouses such as Snowflake.
• Experience managing data integrations and ETL processes.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• Strong analytical, problem-solving, and organizational skills.

Responsibilities

• Administer and support the company's data and analytics environment, including Snowflake, Fivetran, Census, Veeva CRM and related data integrations.
• Monitor data pipelines and integrations to ensure reliability, accuracy, and timeliness.
• Troubleshoot data issues and coordinate resolution with internal and external partners.
• Maintain data governance standards, documentation, and system best practices.
• Identify opportunities to improve data architecture, automation, and reporting efficiency.
• Develop, maintain, and enhance dashboards, scorecards, and reports using Qlik Sense.
• Create and maintain standardized reporting for commercial, finance, operations, and executive teams.
• Design and implement KPI frameworks that support strategic decision-making.
• Ensure consistency and accuracy of metrics across the organization.
• Translate business requirements into scalable reporting and analytics solutions.
• Work closely with stakeholders across Sales, Marketing, Finance, Operations, and Leadership teams to understand reporting needs.
• Act as a trusted advisor on data availability, reporting capabilities, and analytical insights.
• Support business planning, forecasting, and performance management activities through data analysis.
• Present findings and recommendations in a clear and actionable manner.

Skills

Qlik Sense

Data Analytics

Communication

Analytical Thinking

Data Governance

Education

Bachelor's degree (Business, Data Analytics, CS, IS, Statistics)

Tools

Snowflake

Fivetran

Census

Veeva CRM

ETL

Qlik Sense

Job description

Labtician Ophthalmics is a Canadian-owned pharmaceutical company focused on developing, manufacturing, and marketing innovative ophthalmic products. We offer a collaborative, entrepreneurial environment and supportive team culture, where employees can make a meaningful impact on the business. We offer competitive compensation, benefits and development opportunities.

Position Summary

The Business Intelligence & Data Systems Analyst plays a critical role in managing and optimizing the company's data ecosystem and transforming data into actionable business insights. This position is responsible for overseeing key data platforms, supporting reporting and analytics initiatives, and partnering directly with business stakeholders to develop KPIs, dashboards, and standardized reporting solutions.

The successful candidate will combine technical expertise with strong business acumen to ensure data integrity, accessibility, and meaningful decision support across the organization.

Key Responsibilities

Data Systems Management

• Administer and support the company's data and analytics environment, including Snowflake, Fivetran, Census, Veeva CRM and related data integrations.


• Monitor data pipelines and integrations to ensure reliability, accuracy, and timeliness.


• Troubleshoot data issues and coordinate resolution with internal and external partners.


• Maintain data governance standards, documentation, and system best practices.


• Identify opportunities to improve data architecture, automation, and reporting efficiency.

Business Intelligence & Reporting

• Develop, maintain, and enhance dashboards, scorecards, and reports using Qlik Sense.


• Create and maintain standardized reporting for commercial, finance, operations, and executive teams.


• Design and implement KPI frameworks that support strategic decision-making.


• Ensure consistency and accuracy of metrics across the organization.


• Translate business requirements into scalable reporting and analytics solutions.

Business Partnership

• Work closely with stakeholders across Sales, Marketing, Finance, Operations, and Leadership teams to understand reporting needs.


• Act as a trusted advisor on data availability, reporting capabilities, and analytical insights.


• Support business planning, forecasting, and performance management activities through data analysis.


• Present findings and recommendations in a clear and actionable manner.

Data Analysis

• Analyze business performance trends and identify opportunities for improvement.


• Conduct ad hoc analyses to support strategic initiatives and decision-making.


• Validate data quality and investigate discrepancies.


• Support special projects involving data integration, automation, and business process improvement.

Qualifications

Required

• Bachelor's degree in Business, Data Analytics, Computer Science, Information Systems, Statistics, or a related field.


• 3-7 years of experience in business intelligence, analytics, data management, or a related role.


• Strong experience with Qlik Sense dashboard development and reporting.


• Experience working with cloud-based data warehouses such as Snowflake.


• Experience managing data integrations and ETL processes.


• Ability to communicate effectively with both technical and non-technical stakeholders.


• Strong analytical, problem-solving, and organizational skills.

Preferred

• Experience with Fivetran, Census and Veeva CRM data.


• Experience in pharmaceutical, healthcare, life sciences, or regulated industries.


• Knowledge of data governance and data quality best practices.


• Experience with forecasting, commercial analytics, or KPI development.

Success in This Role

The successful candidate will:

• Ensure reliable and scalable data systems that support business operations.


• Deliver accurate and insightful reporting that drives decision-making.


• Build strong relationships with business stakeholders.


• Continuously improve data quality, accessibility, and reporting capabilities.


• Serve as a key contributor to the organization's data-driven culture.

Location: Oakville, ON (hybrid 2 days per week in-office currently)

Salary Range: $70-$85K base pay.

This posting is for an existing, immediate vacancy. Accommodations are available upon request for candidates taking part in all aspects of the selection process. If contacted for an interview, please advise the hiring team if you require any disability-related accommodations.