Business Intelligence (BI) Specialist

Aviva Canada; Markham; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Business Intelligence Specialist, where you'll leverage cutting-edge BI tools to craft innovative applications and reports. This role is pivotal in supporting business needs through automated solutions, enhancing data visualization capabilities, and addressing analytical challenges. With a focus on collaboration within a dynamic team, you'll drive impactful insights and support decision-making processes. Enjoy a compelling rewards package, outstanding career development opportunities, and a hybrid work model that promotes work-life balance. This is your chance to make a significant impact in a company that values diversity and inclusion.

Benefits

Annual bonus eligibility

Retirement savings plan

Health benefits

Competitive vacation package

Professional development support

Corporate wellness programs

Volunteer opportunities

Option to purchase extra vacation days

Qualifications

• 5+ years of experience in BI Development and Analytics.
• Strong knowledge of Data Modeling and Data Warehousing concepts.
• Experience with Cloud Data Warehouses is highly desired.

Responsibilities

• Develop innovative BI applications and reports.
• Collaborate on data requirements and design solutions.
• Mentor junior team members and ensure data quality.

Skills

Business Intelligence Development

Data Visualization

Data Cleansing

Problem Solving

Communication Skills

Education

Bachelor’s Degree in Mathematics

Bachelor’s Degree in 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 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.