Senior Data Analyst

at  Wawanesa Insurance

Date: Jun 14, 2024
Location: Winnipeg, MB (Hybrid), CA Hybrid - Canada, CA
Company: Wawanesa Insurance
Job ID: 8185
Working Business Language: This role is considered a head-office role and will be required to communicate with internal stakeholders across Canada where the primary business language utilized is English.
Salary: At Wawanesa, salary is only one component of a holistic, comprehensive and competitive offering that we provide to our employees. In addition to salary, full-time and part-time permanent employees are eligible for an annual bonus plan, leave of absence top-up programs and provided with generous vacation time, personal days, premium free benefits and pension plan.
The salary offered for this role is determined with consideration to various factors, including but not limited to: your work location, local labour market conditions, external market salary data, internal pay equity and the knowledge, skills, experience and anticipated proficiency in the role. The salary offered is estimated to be within the following range: $90, 000 - $115, 000. Candidates with salary expectations outside of the range are still encouraged to apply.

ABOUT US

At Wawanesa, we’re proud to offer a hybrid work environment that offers flexibility to our employees in balancing in-office (2 days per week OR 15 hours per week in a Wawanesa office) and remote work. You may work from any of the following locations: Winnipeg, MB; Wawanesa, MB; Vancouver, BC; Calgary, AB; Edmonton, AB; Lethbridge, AB; Toronto, ON; Kitchener, ON; Thunder Bay, ON; Ottawa, ON; Montreal, QC; Moncton, NB; Dartmouth; NS
The Wawanesa Mutual Insurance Company (“Wawanesa Mutual”), founded in 1896, is one of Canada’s largest mutual insurers, with over $3.5 billion in annual revenue and assets of $10 billion (CAD). Wawanesa Mutual, with its National Headquarters in Winnipeg, is the parent company of Wawanesa Life, which provides life insurance products and services throughout Canada, and Western Financial Group, which distributes personal and business insurance across Canada. Wawanesa proudly serves more than 1.7 million members in Canada, and we are home to more than 3,600 employees distributed across the Canadian regions and communities where we operate. We give back to organizations that strengthen communities, donating more than $3.5 million annually to charitable organizations, including over $2 million annually in support of people on the front lines of climate change. To learn more visit wawanesa.com.
We are currently looking for dedicated, driven, and enthusiastic individuals who thrive in an environment that welcomes change and are looking for an opportunity for diverse experience and advancement on a growing team.

JOB OVERVIEW

We are looking for a Senior Data Analyst with deep analytical and technical expertise in driving data-driven solutions by querying, analyzing, profiling, and curating data sets. This individual will directly work with our Enterprise Data Warehouse, our ETL & data streaming processes, and complex data models from source systems such as our Guidewire Insurance Suite system. The ideal candidate will possess a strong analytical mindset, excellent communication and collaboration skills, and an understanding of insurance products and operations.
The Analyst will be part of our data delivery team and contribute by designing, documenting, testing, and supporting our data pipelines and repositories to meet business stakeholder reporting and data consumption requirements.

QUALIFICATIONS

• Degree or certificate in Computer Science, Statistics, Mathematics, or a related field.
• At least 4 years (6 or more is preferred) of experience as a Data Analyst, preferably in the insurance industry.
• Highly proficient in SQL including complex joins and query performance optimization techniques.
• Able to identify, validate, document, and determine root cause of Data Quality issues.
• Knowledgeable in various data file structures and format such as Excel, CSV, JSON, XML, Parquet, and database tables.
• Able to evaluate and design logical and physical data models including various data types and relationships between entities.
• Deep understanding of data lineage and data transformation rules, and therefore able to perform data change impact assessments.
• Understanding of dimensional models and related modeling techniques such as Kimball Data Warehousing/Business Intelligence techniques.
• Able to author and evaluate data-driven test cases.
• Experience in other data analysis processing languages such as Python or R would be an asset.
• Proficiency with MicroStrategy, Power BI, or other similar visualization and reporting tools would be an asset.
• Knowledge of AWS and its various tools & services (Oracle, Redshift, Aurora PostgreSQL) would be an asset.
• Experience with Peoplesoft or Financial data will be considered an asset.
• Knowledge of Guidewire Insurance Suite and its data model would be an asset.
• Experience in Jira and Confluence would be an asset.
• Experienced in Data Governance and Stewardship would be an asset.
  Wawanesa is proud to be one of Manitoba’s Top Employers, a Kincentric Best Employer in Canada and a Forbes Best Employer in Canada recognizing an exceptional place to work!

• Collaborate with cross-functional teams to identify and prioritize data consumption needs.
• Collect, analyze, and cleanse datasets to extract patterns, insights, and trends.
• Develop and enhance curated data sets to support underwriting, actuarial, and risk management strategies.
• Conduct ad-hoc data analysis to address specific business questions, challenges, or data quality issues.
• Assist Data Architects and Data Modelers in authoring diagrams and models.
• Perform impact assessments of upstream data system changes and enhancements. This includes high-level estimating and work breakdowns to respond to data changes.
• Facilitate data and reporting requirements sessions to flesh out detailed data provisioning requirements and scope of work.
• Develops and advises on best practices for business stakeholders, including consultations on data management and reporting explorations.
• Stay current with industry trends and best practices in data management, data analytics and insurance.