Business Intelligence Developer

OSL Retail Services Inc.; Mississauga; On-site; CAD 80,000 - 110,000; Full time

Job summary

OSL Retail Services Inc. is searching for a Business Intelligence Developer to enhance their BI capabilities. This role involves the design and management of scalable BI solutions using various platforms while ensuring data integrity and system performance. Candidates should have substantial BI experience, particularly in SQL and ETL processes. Join a people-focused company recognized as one of Canada’s Best Managed Companies and advance your career in a supportive environment.

Benefits

Competitive base salary plus bonus

Vacation plus additional flex days

Comprehensive benefits

RRSP matching program

Training and development opportunities

Supportive workplace culture

Qualifications

• 3+ years of hands-on experience developing BI content and solutions.
• Advanced SQL proficiency with ability to write complex queries.
• Solid experience with ETL/ELT frameworks and tools.

Responsibilities

• Design and maintain scalable BI solutions including dashboards and data flows.
• Monitor and manage scheduled data loads and ETL workflows.
• Provide second-level support to BI users and collaborate with stakeholders.

Skills

SQL proficiency

Data modeling techniques

Analytical skills

Problem-solving skills

Communication skills

Education

Bachelor’s degree in computer science, Information Systems, Engineering, or related

Tools

Domo

Power BI

Tableau

Looker

Qlik

SSIS

Azure Data Factory

Airflow

Job description

Overview

It’s an exciting time to be at OSL Retail Services, working for a people focused company that’s at the top of its game. The momentum we’ve generated in recent years with our commitments to client customers, innovation, business results, and an entrepreneurial spirit has created energy, enthusiasm, and engagement among our employees that is pushing us to new heights. And we’re on the lookout for talented people who share our vision and values and want to join us in this journey. At OSL, our culture is our foundation. Passionate employees, great customer service and long-term relationships are all built upon that foundation. We value people, passion, honesty, respect, and integrity.

Position Overview:

Reporting to the Manager, BI Operations, the Business Intelligence Developer is a technically skilled professional responsible for building new BI capabilities and handling day-to-day operational tasks within the organization’s business intelligence platforms and infrastructure. With deep hands-on experience in BI tool administration, SQL development, data pipelines, and incident management, you will work to ensure the reliability, scalability, and efficiency of BI systems that support enterprise-wide data access and reporting.

What You’ll Do

Technical Development & Deployment

• Design, develop, and maintain scalable BI solutions including dashboards, reports, data flows, and embedded analytics using Domo and other enterprise BI platforms.
• Write, review, and optimize complex SQL queries, views, and stored procedures to support reporting, analytics, and data integration use cases.
• Partner with data engineers and architects to ensure robust, secure, and scalable data pipelines, including efficient semantic layer design.
• Create and maintain well-structured data models that align with business needs and promote self-service analytics.

BI Platform Operations & Support

• Monitor and manage scheduled data loads, ETL/ELT workflows, and job orchestration tools to ensure data reliability and system uptime.
• Investigate and resolve system issues, data discrepancies, and job failures with root cause analysis and timely resolution.
• Document operational processes, technical configurations, and support playbooks to enable cross-functional collaboration and knowledge sharing.
• Provide second-level support to BI users and act as a liaison between business stakeholders and technical teams.

What You’ve Done

• 3+ years of hands-on experience developing BI content and solutions in enterprise platforms (e.g., Domo, Power BI, Tableau, Looker, Qlik).
• Advanced SQL proficiency, with demonstrated ability to write and optimize complex queries, stored procedures, and scripts.
• Solid experience with ETL/ELT frameworks and job orchestration tools (e.g., SSIS, Azure Data Factory, Airflow, Domo Workbench).
• Strong knowledge of data modeling techniques (star/snowflake schemas) and semantic layer best practices.
• Demonstrated ability in BI system administration, including monitoring, incident management, and performance tuning.
• Proven analytical and problem-solving skills in high-availability, fast-paced environments.
• Excellent communication and collaboration skills; ability to translate business requirements into technical solutions.
• Bachelor’s degree in computer science, Information Systems, Engineering, or a related technical discipline (or equivalent experience).

What we offer:

• A competitive base salary plus bonus
• Vacation plus additional flex days
• Comprehensive benefits
• RRSP matching program
• Training and development opportunities to grow your career with one of Canada’s Best Managed Companies
• A supportive workplace culture and work environment

Interview Process:

• Step 1: If your profile is a match, we will invite you for a first conversation with the recruiter.
• Step 2: The next step is an in-person interview with the hiring manager including a technical test on basic knowledge of EXCEL and SQL.
• Step 3: The final step is a virtual interview with the Director of BI and Analytics.

If this sounds like you and you’re excited to be a member of our team, pleaseapply now.

We thank all interested applicants; however, only qualified candidates will be contacted. This position requires successful completion of a criminal background check.

Disclaimer: The preceding job description has been designed to indicate the general nature and level of work performed by employees within this job. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

OSL is committed to an inclusive workplace that does not discriminate against race, nationality, religion, age, marital status, physical or mental disability, sexual orientation, gender, or gender identity. We believe in diversity and encourage any qualified individual to apply.