Business Intelligence (BI) Specialist

Aviva; Markham; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Business Intelligence Specialist, where you'll leverage advanced BI tools to create innovative applications and insightful reports. In this dynamic role, you'll support business needs through automated solutions, enhance data visualization capabilities, and mentor junior team members. Enjoy a competitive rewards package, including health benefits and a flexible hybrid work model. This is an exciting opportunity to make a tangible impact on business decisions while working with a dedicated team focused on delivering exceptional value to clients.

Benefits

Annual bonus eligibility

Retirement savings plan

Health benefits

Competitive vacation package

Corporate wellness programs

Volunteer opportunities

Qualifications

• 5+ years experience in BI Development and Analytics.
• Strong knowledge of Data Modeling and Data Warehousing concepts.

Responsibilities

• Craft and develop innovative BI applications.
• Build sophisticated queries and reports for data analysis.

Skills

Business Intelligence Development

Data Visualization

Data Analysis

Problem Solving

Communication Skills

Education

Bachelor’s degree in Mathematics or Computer Science

Tools

SAP Business Objects

Qlik

Tableau

SAS

SQL

Snowflake

Amazon Redshift

Google BigQuery

Job description

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

With the growing needs for more self-serve tools to digest sophisticated data and information, the business insights and analytics team in PI is seeking a Business Intelligence Specialist. In this role, the BI specialist will use Aviva’s technologies to design, develop, and support visually informative and innovative applications, including customized reports that provide tangible business benefits.

In this role, you'll have 3 main mandates:

1. Support business needs through automated and/or self-served solutions via BI tools
2. Assist business insights & analytics team in solving data gaps and analytical needs
3. Provide outstanding data visualization capabilities as data sources increase in complexity over time

Come join our team!

What you'll do:

• Craft and develop innovative BI applications
• Build sophisticated queries and reports, using complex variable creation, multiple queries, and other advanced techniques
• Assess data quality making recommendations for workflow management
• Provide informal mentoring/training to junior members of the team
• Perform advanced data cleansing, data analysis, and build visualizations that provide an easy-to-understand and actionable solution
• Advise on how data visualizations can be best leveraged to provide business value
• Collaborate within the Business Insights and Analytics team on data requirements such as data structure, data flow, dependencies, and data mapping
• Strong design and documentation of all new and existing process development with a best-in-class outstanding mentality and design principles.
• Proactively work on design, scope, solution, and deployment alongside the business to deliver agile solutions quickly and effectively.

What you'll bring:

• Demonstrated ability (5+ years) in BI Development and Analytics (using SAP Business Objects, Qlik, Tableau, or others)
• Bachelor’s degree or equivalent experience in Mathematics or Computer Science, or professional experiences in an applicable industry
• Previous experience in designing, developing, and implementing BI dashboards. Experience in SAS and Qlik is highly preferred.
• Knowledge of Data Modeling and Data Warehousing concepts, solid understanding of databases such as Postgres, Salesforce, Hadoop, etc.
• Experience with SAS or SQL, and hands-on data cleansing and transforming using a wide variety of data sources; structured and unstructured.
• Experience with Cloud Data Warehouses such as Snowflake, Amazon Redshift, or Google BigQuery is highly desired
• Previous Insurance or Finance industry experience is preferred
• Strong problem solving and solutioning skills are essential
• Excellent communication skills for detailed documentation and collaboration with the business, scope, and deliveries.

What you’ll get:

• Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
• Competitive vacation package with the option to purchase 5 extra days off per year
• Employee-driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion
• Corporate wellness programs to support our employees’ physical and mental health
• Hybrid flexible work model

Please note that we may use AI tools to help us through the recruitment process. This is an existing position which has been posted both internally & externally.

Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.

#LI-AI1

About the company

We’re here to protect our 33 million customers from life’s unexpected twists and turns – freeing them from fear of uncertainty. We are one of only a few insurance companies in the world that can provide customers with life, general, and health insurance, and asset management in one place – a composite insurer. We have a unique competitive advantage. Whether we’re protecting them from everyday risks or helping them to save for the future, we put customers at the heart of all we do – creating a bright and sustainable future for our customers, employees, and our communities.