Business Intelligence Analyst

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.

The Company:

OSL was established in 2012 in Mississauga, Ontario, to provide clients with customized designed sales solutions in retail, direct sales, merchandising and customer acquisition.

 

About the role:

Reporting to the Analytics Manager, the Business Intelligence Analyst is a skilled analytical professional who has significant hands-on experience with analysis, reporting, and dashboarding. You will be responsible for creating and developing metrics, identifying opportunities in the business, and shaping the vision for reporting and analysis at OSL.

What you’ll do:

• Acquire data from primary or secondary data sources and build/maintain ETL workflows and dashboards
• Filter and clean data by reviewing reports and performance indicators to locate and correct problems and validate data accuracy
• Identify, analyze, and interpret trends in complex data sets and provide easily digestible reports and actionable business insights
• Examine reporting relationships to increase end-user productivity, availability, and accuracy
• Work with management to prioritize business and information needs
• Locate and define new process improvement opportunities
• Assist in identifying opportunities in business and works to produce impactful analysis
• Liaise with internal and external clients on reporting needs to find effective solutions
• Develop and build datasets using SQL/ETL tools and create automated dashboards and alerts
• Support the team by creating reports – ad hoc or routine – and dashboards

 

What you’ve done:

• 3+ years BI experience
• Proven working experience as a business data analyst
• Technical expertise regarding data models, database design development, data mining and segmentation techniques
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Adept at queries, report writing, data visualization and presenting findings
• Strong knowledge of and experience with dashboarding (PowerBI, Tableau, or Domo), databases (SQL etc), ETL Tools (Knime, Alteryx).
• Programming with Python or Javascript is an asset
• BS in Business, Mathematics, Economics, Computer Science, Information Management or Statistics an asset

What we offer:

• A competitive base salary of $70-$85K 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

 

Next Steps:

• 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 managers including a technical test on basic knowledge of EXCEL and SQL.
• Step 3: The final step is a virtual conversation 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.