Business Intelligence Developer

OSLRS; Mississauga; On-site; CAD 80,000 - 110,000; Full time

Job summary

Join a leading company as a Business Intelligence Developer, where you'll be responsible for enhancing our BI capabilities and ensuring operational efficiency. Ideal candidates will have strong experience in BI tools such as Domo and possess a solid foundation in SQL and data analytics. The role offers competitive pay, professional development opportunities, and a collaborative work culture focused on inclusion and growth.

Benefits

Competitive base salary plus bonus

Vacation plus additional flex days

Comprehensive benefits

RRSP matching program

Training and development opportunities

Qualifications

• 3+ years of experience in BI solutions.
• Advanced SQL proficiency for data analysis.
• Solid experience with ETL tools and data modeling.

Responsibilities

• Develop and maintain scalable BI solutions using Domo and other platforms.
• Monitor and manage ETL workflows to ensure data reliability.
• Provide support to BI users and align with business requirements.

Skills

SQL

BI Development

Data Analytics

Problem-Solving

Collaboration

Education

Bachelor’s degree in computer science or related field

Tools

Domo

Power BI

Tableau

Azure Data Factory

SSIS

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.