BUSINESS INTELLIGENCE ANALYST (HYBRID)

Green Shield Canada (GSC); Windsor; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading health benefits organization in Ontario seeks a Business Intelligence Analyst to enable data-driven decision-making across the organization. This role involves leading BI product development, collaborating with teams to maintain metrics and dashboards, and ensuring adherence to data governance standards. The ideal candidate should have a post-secondary degree in a relevant field and possess strong skills in BI tools like Power BI and SQL. Join a mission-driven team that values inclusivity and innovation.

Benefits

Inclusive workplace environment

Opportunities for professional growth

Work-life balance

Qualifications

• 3+ years of experience designing, developing, and deploying BI products.
• Strong technical proficiency in querying and transforming data.
• Proven track record of translating business requirements into BI solutions.

Responsibilities

• Lead the development and execution of BI products.
• Collaborate with teams to define, build, and maintain metrics and dashboards.
• Conduct deep-dive analyses to support decision-making.

Skills

Data visualization

SQL

Power BI

DAX

Data storytelling

Education

Post secondary degree in computer science, data science, mathematics or statistics

Tools

Power BI

Tableau

SQL

Python

R

Job description

WHO WE ARE

When it comes to health, we’re always looking for ways to push for better. It’s why we were founded in the first place. In 1957, our founder, pharmacist William Wilkinson, witnessed a mother sacrifice her health by forgoing her own medicine to pay for her sick daughter’s prescription. He discovered there had to be a better way. So, he introduced North America’s first prepaid drug plan and GreenShield was born as a not‑for‑profit with a mission to support better health for all Canadians.

We aren’t just a health and benefits company. We’re the only not‑for‑profit social enterprise that brings worlds of coverage and care together, all in one place. We’re noble challengers, purposefully building a better way and we need the best people to help us create a more holistic approach that takes care of the mind and body. Our mission is to create better health for all Canadians, and we know that starts with our employees.

THE ROLE IN A NUTSHELL

Reporting to the Director, Enterprise Operations Business Partner, the Business Intelligence Analyst plays a crucial role in enabling data‑driven and evidence‑based decision‑making across the organization. Business Intelligence (BI) Delivery and Enablement.

• Lead the development and execution of BI products that support strategic and operational decision‑making.
• Collaborate with data and analytics teams to define, build, and maintain metrics and dashboards aligned with business priorities.
• Act as a bridge between business stakeholders and technical teams to ensure BI solutions meet user needs.
• Translate business needs into technical requirements and ensure BI solutions are scalable, accurate, and actionable.
• Ensure BI solutions adhere to data governance standards, including data quality, consistency, and security.
• Collaborate with data architects and stewards to align BI tools with enterprise data architecture and strategy.
• Maintain documentation of data definitions, sources, and transformation logic to support transparency and reuse.
• Adopt, implement and effectively evolve report automation and/or visualization standards.

PERFORMANCE MONITORING

• Collaborate with stakeholders to define meaningful performance metrics that align with business goals.
• Proactively monitor key performance indicators (KPIs) across business to identify trends, anomalies, and opportunities for improvement.
• Continuously evaluate and refine reporting processes to improve efficiency, accuracy, and relevance of performance insights.
• Partner with operational teams to interpret data and drive continuous improvement initiatives.
• Provide support to business users on BI tools and data interpretation.

FOSTER A DATA‑DRIVEN CULTURE BY PROMOTING THE USE OF ANALYTICS IN EVERYDAY DECISION‑MAKING

ANALYSIS AND DECISION SUPPORT

• Conduct deep‑dive and ad‑hoc analyses to support business leadership in evaluating initiatives, solving problems, and making evidence‑based decisions.
• Interpret, assess and respond to informational requests from teams across the organization while ensuring analyses are relevant, accurate, and aligned with business goals.
• Present findings in a clear, concise, and compelling manner to both technical and non‑technical audiences.
• Maintain a high standard of data integrity and clarity in all reporting and analysis deliverables.
• Ensure analytical outputs are actionable and contribute to strategic and operational decision‑making.

WHO WE’RE LOOKING FOR

• Post secondary degree in computer science, data science, mathematics, statistics or a related field.
• 3+ years of hands‑on experience designing, developing, and deploying BI products such as dashboards, reports, and scorecards using tools like Power BI, Tableau, or Looker.
• Strong technical proficiency in querying and transforming data using SQL, DAX, Power Query, M, or other relevant languages.
• Excellent communication and storytelling skills to present insights to both technical and non‑technical audiences.
• Ability to work with large, complex datasets from multiple sources and ensure data accuracy, consistency, and integrity.
• Proven track record of translating business requirements into scalable and actionable BI solutions that support strategic and operational decision‑making.
• Familiarity with end‑to‑end development of automated BI solutions, including working with relational databases, performing data extraction, transformation, and loading (ETL), data analysis, and data visualization.
• Familiarity with data modeling concepts and experience working with data warehouses or cloud‑based data platforms (e.g., BigQuery, Azure Synapse, Snowflake).
• Strong understanding of data governance principles, including metadata management, lineage tracking, and security protocols.
• Collaborative mindset with experience working across business units, data teams, and technical stakeholders to align BI solutions with enterprise strategy.

NICE TO HAVE

• Knowledge of scripting languages (e.g., Python, R) for advanced analytics or automation.
• Exposure to machine learning or predictive analytics concepts and their integration into BI workflows.
• Background in training or mentoring business users on BI tools and data literacy.
• Bilingual in French and English.

THE CULTURE

We believe a career should be meaningful. Not just a means to earn a living. Our culture values everyone’s voice and strives to create better health for all. We dare to challenge the status quo and are driven by people who challenge theirs. It’s a workplace that empowers you to be the best version of yourself. That’s why we provide a place where you can be inspired, challenged, and rewarded.

Where your growth means our growth.
Where your voice is heard and valued.
Where your work has purpose. And purpose matters.

We believe our people are critical to our overall success. Inclusivity makes us stronger, smarter, and more informed. Intentionally inclusive of diverse backgrounds, perspectives and experiences enhances our culture and positively impacts how we support our communities. A career at GreenShield isn’t just about personal achievements, it’s about making a difference together.

A FEW MORE DETAILS

Proficiency in English is required for this position. Part of this role you will communicate with colleagues or customers who use English as their primary language. Requiring English proficiency ensures employees can excel, collaborate, and communicate effectively, contributing to the success of our organization.

GS supports diversity, equity and inclusion in our teams and communities, and we value the unique contributions made by all. Even if your experience doesn’t align perfectly to every requirement, we invite you to apply. We encourage applications from all candidates and will accommodate needs under human rights legislation throughout all stages of the recruitment and selection process. Please let us know of any accommodation through [e-mail]. Information received relating to accommodation will be addressed confidentially.

Providing this information gives GS consent to use your personal information to assess your suitability for specific positions, future opportunities or for your personnel file. Your résumé will be held in strict confidence and will be viewed only by the Organization. Information may be stored outside Canada and could be used for aggregate statistical purposes (which uses no personal identification).