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 of 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

• Support business needs through automated and/or self-served solutions via BI tools
• Assist business insights & analytics team in solving data gaps and analytical needs
• 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 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 is essential
• Excellent communication skills both for accurate and detailed documentation as well as collaborator management and communication 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.
• Outstanding Career Development opportunities.
• We’ll support your professional development education.
• 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.