Digital Analytics Consultant

Co-operators; Burlington; Hybrid; CAD 80,000 - 95,000; Full time

Job summary

A leading Canadian financial services cooperative is seeking a Digital Analytics Consultant in Burlington, Ontario. The role focuses on building digital analytics to enhance CRM initiatives, utilizing SQL and ETL skills. Ideal candidates will have at least 5 years of experience in CRM development and analytics tools. This is a hybrid position with opportunities for growth and development in a supportive work environment.

Benefits

Training and development opportunities

Flexible work options

Paid volunteer days

Comprehensive total rewards package

Qualifications

• Minimum 5 years of related experience in CRM system development and digital analytics.
• Requires strong SQL query and ETL experience for CRM development and reports.
• Experience with analytics tools required.

Responsibilities

• Build digital analytics to support digital initiatives.
• Create complicated queries and perform data analysis.
• Present analysis to key stakeholders.

Skills

SQL query

ETL experience

CRM analytics

project management tools

Communication skills

Education

University degree or Completion of post-secondary technical diploma in Computer Science

Tools

Salesforce

Azure Data Studio

Power BI

MicroStrategy

Jira

Confluence

Job description

Company : CGL

Department : Digital Analytics

Employment Type : Regular Full-Time

Work Model : Hybrid

Language : This role operates in English

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

The Opportunity :

We are a leading Canadian financial services cooperative 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.

Disruptive technology, emerging trends, and new ways of doing business are redefining the future of insurance, with digital at the heart of it. Our Digital team is made up of experts who put our customers at the centre of what we do, creating engaging experiences that drive business outcomes. We are creative and inventive agile enthusiasts who value transparency and collaboration as we deliver scalable, robust and innovative digital solutions. Join us as we transform our digital platforms and build a visionary experience of seamless and compelling journeys for our clients, advisors and operational teams across Canada.

The digital analytics consultant is responsible for building digital analytics that support our digital initiatives. Examples include analysis of Salesforce CRM performance ( sales, service, and campaign interactions). There is “downstream work” (collecting and analysing the data). The purpose of the analysis is to help us deliver efficient, successful, CRM experience.

How you will create impact :

• Understand business requirements for CRM analytics (what needs to be profiled, what degree of detail, frequency etc).
• Create complicated queries and perform data analysis per business requirements.
• Present analysis to key stakeholders including digital product owners, legal and compliance.
• Help stakeholders understand the results and help determine resulting actions.
• Monitor the collection of data, build reports, dashboards etc.
• Design / stage / prepare data for analysis.
• Perform end to end ETL activities.
• Initiate and lead analytics discussion with digital stakeholders (project requirements, reporting etc).
• Work with digital team leads and developers on CRM data ( Saleforce leads, opportunities, account management) etc.

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 :

Minimum 5 years of related experience in CRM system development and digital analytics experience ( CRM Analytics).

University degree or Completion of post-secondary technical diploma in Computer science.

Requires strong SQL query and ETL experience (working level) for CRM development, reports and data migration.

Requires analytics experience (working level is acceptable, but expert level is ideal). Experience with analytics tools required ( CRM Analytics, Azure Data Studio, Power BI, MicroStrategy etc).

Requires experience using project management tools such as Jira and Confluence.

What you need to know :

You will travel occassionally.

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 (, health and wellness, dental, disability and life coverage), mental health support and an employee assistance program.