Business Intelligence Developer

OSL Retail Services; Mississauga; On-site; CAD 70,000 - 90,000; Full time

Job summary

Join OSL Retail Services as a Business Intelligence Developer and contribute to the evolution of our BI strategies. In this role, you will design scalable BI solutions and ensure the reliability of our systems, fostering a culture of collaboration and excellence. A competitive salary and supportive workplace underscore our commitment to your professional growth in a cutting-edge environment.

Benefits

Competitive base salary plus bonus

RRSP matching program

Training and development opportunities

Supportive workplace culture

Qualifications

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

Responsibilities

• Design and maintain scalable BI solutions using Domo and SQL.
• Monitor and manage data loads and workflows.
• Document processes and provide second-level support.

Skills

SQL

Data Analysis

Problem-Solving

Collaboration

Communication

Education

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

Tools

Domo

Power BI

Tableau

Azure Data Factory

SSIS

Job description

Direct message the job poster from OSL Retail Services

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.

Optimization & Automation

• Proactively identify and implement opportunities to automate manual processes, reduce redundant effort, and streamline data workflows across BI systems.
• Refactor and optimize existing SQL queries, dataflows, and ETL/ELT pipelines to improve performance, scalability, and maintainability.
• Evaluate and enhance dashboard performance by simplifying visualizations, consolidating metrics, and minimizing unnecessary complexity.
• Remediate legacy or ad hoc code to align with technical standards, naming conventions, and best practices for long-term maintainability.
• Work closely with BI and data engineering teams to develop and enforce standardized development frameworks and code reuse patterns.
• Regularly review platform usage to deprecate unused assets, optimize user experience, and maintain a clean, efficient BI environment.

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
• 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, please apply 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.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  General Business

• Industries

  Retail

Referrals increase your chances of interviewing at OSL Retail Services by 2x

Get notified about new Business Intelligence Developer jobs in Mississauga, Ontario, Canada.

Senior Business Intelligence Analyst (Power Automate / Apps)

Business Analyst-Azure data/ datawarehouse

Data Governance Foundation Lead Analyst - C13 - MISSISSAUGA

Senior Data Control Analyst - IT Ops Oversight

Data Center Technical Deployment Analyst

Senior Analyst, Data Audience and Activation (English Services) (Telework/Hybrid)

Senior Business Analyst - Wealth Platform Data Masters

VP, EDO Business Execution Analyst - Data Transformation Program Staffing & Financial Commitments-Mississauga

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.