Data Analyst - BI OMNI Distribution

Company: CGIC

Department: Business Intelligence

Employment Type: Regular Full-Time

Work Model: Hybrid

Language: English is required, French is an asset.

Additional Information: This/these role(s) is/are currently vacant.

The Opportunity

We are a leading Canadian financial services co-operative committed to being a catalyst for a sustainable and resilient society and our team is essential to deliver on this strategy. That’s why we prioritize our people, to ensure we provide a strong culture and development opportunities which enables our team to thrive and to live our purpose. The best part is that you will work with people that care passionately about you, our clients, and our communities.

Our Business Intelligence team empowers decision making using leading edge science and analytics. We strive to deliver a single version of truth, by providing our business partners with access to comprehensive data and valuable insights to help our organization achieve operational excellence.

As Data Analyst, you actively contribute to various initiatives by analyzing data to solve business problems and providing valuable insights. You understand the insurance business domain and ensure your own tasks contribute to meeting the business objectives by applying appropriate methods and critical thinking and performing analysis.

How You Will Create Impact

• Autonomously perform descriptive and diagnostic analysis using recommended methods (ex: regression, cohort analysis, cluster analysis, A/B testing, factor analysis).
• Design and develop metrics to enable descriptive analysis and diagnostic analysis.
• Autonomously design proof of concept and deliver with guidance a prototype analytical solution to enable effective storytelling and descriptive/diagnostic analysis.
• Work on Data querying (T-SQL, SQL, MySQL, etc.)
• Extract, clean, reconcile and prepare the data required for the analysis.
• Autonomously communicate findings to colleagues and your manager in an effective manner.
  
  
  

How You Will Succeed

• You have an innovative mindset to improve operational efficiencies and ability to influence change, with a primary focus on client needs.
• You use critical thinking skills to recognize assumptions, evaluate arguments, draw conclusions and proactively propose solutions.
• You have strong communication skills to clearly convey messages and explore diverse points of view.
• You build trusting relationships and provide guidance to support the development of colleagues.
  
  
  

To Join Our Team

• You have 3-5 years of relevant experience in Business Intelligence or other relevant domain.
• You have a University Degree in Business Intelligence, Computer Science, Actuarial Science, Mathematics, Statistics, or equivalent technical experience.
• ACAS or FCAS designations are considered an asset.
• You have experience solving standard problems by analyzing possible solutions by using our experience, judgment and precedent & challenging status quo.
• You have good knowledge and understanding of data analysis, programing, modeling techniques, data warehouse and data management, research, architecture and design.
• Experience with the following technologies is required: Excel, SQL, Synapse
• Experience with the following technologies is an asset: Power BI, MicroStrategy, R, Python, Databricks
• This position primarily works with majority non-francophone groups, and teams located outside of Québec, and requires proficiency in English. The essential non-French duties are not assignable to adjacent or other team members. 
  
  
  

What You Need To Know

• You will be subject to a Background check as a condition of employment, in the event you are the successful candidate.
  
  
  

What’s in it for you?

• Training and development opportunities to grow your career.
• Flexible work options and paid time off to support your personal and family needs.
• A holistic approach to your well-being, with physical and mental health programs and a supportive workplace culture.
• Paid volunteer days to give back to your community.
• In addition to our competitive salary and incentive programs, eligible employees also benefit from a comprehensive total rewards package including group retirement savings plans, pension and benefits (e.g., health and wellness, dental, disability and life coverage), mental health support and an employee assistance program.