Senior Data Solutions & Reporting Analyst

Company: CGIC
Department: Retail Sales 
Employment Type: Temporary Full-Time (12 months)
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.

The Sr Data Solutions & Reporting Analyst will autonomously contribute to various and diverse Retail Sales & Service projects and initiatives. This role will bring strong and clear knowledge of both the breadth and depth of various products and sources (ie. Life, Wealth, P&C, Group, Edge, Federated, PLCM, Compensation) within the organization and how to integrate to deliver data and analytics reporting solutions.  The Sr Data Solutions & Reporting Analyst is creative and resourceful in integrating and developing these solutions to meet the very high-paced, high-demand and the ever-evolving needs of RSS business partners and uses their strong business acumen to impart knowledge and translate technical needs into business value.

How you will create impact:

• Maintain an excellent knowledge of various data integration tools and general-purpose languages (SQL, T-SQL, MySQL, R, SAS, Python) and data platforms (Azure, Databricks)
• Build controls to assess the data quality for reporting and analytics
• Have a strong knowledge of the various data sources (ie. CFIS, CLIC, Edge, Federated, PLCM, P&C, Compensation) across the organization for the intent of integration and developing robust data solutions
• Good knowledge of operational tools (SalesForce, PolicyCentre, ClaimCentre, BillingCentre) and their business integration points
• Design, build and maintain data solutions to support unmet reporting and analytics needs for RSS not available in the data environment (Azure)
• Design, develop, and maintain reporting assets through enterprise tools (ie. MSTR, PowerBI, Excel) to enable easy and effective analysis and storytelling for various business partners across the organization
• Act as a Subject Matter Expert on key projects
• Participate and translates RSS business needs to partners (BI) for the development and delivery of valuable data solutions
• Provide technical as well as business coaching, training and support to DI&A team members on the needs and priorities of the team. Proactively shares knowledge with less experienced colleagues.
• Establish partnerships within RSS and with business partners (i.e. Business Intelligence, Product, Finance, Actuarial) to optimize business performance.

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:

• Diploma or degree in Actuarial, Mathematics, Statistics, Computer Science, or equivalent combination of education and experience.
• Designations relating to data modeling (ie Azure), coding (ie. SQL) and report development (ie. MSTR) are an asset
•  Strong knowledge and understanding of Data analysis, programming/tools, modelling techniques, data warehouse/data management, research
•  Requires practical expertise in own area and general knowledge of related areas
•  Knowledge of best practices and how own area is integrated with others
•  Understanding of the competition and the factors that differentiate the company in the market
• Strong knowledge of all products (P&C, Life, Wealth)
• 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 to support personal and family needs.
• A holistic approach to your well-being, with physical and mental health programs and a supportive workplace culture.
• Volunteer opportunities to give back to your community

Expected Salary Range: $71,070 -- $118.450

The salary amount for the successful candidate is determined by Co-operators in its discretion and will vary depending on several criteria including but not limited to: local market conditions, geography and relevant job-related factors such as knowledge, skills, qualification, experience and education.