Address
Form of workJob ID: 7737
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, 00- $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, founded in 1896, is one of Canada's largest mutual insurers, with over $4 billion in annual revenue and assets of $12 billion. Wawanesa Mutual, with executive offices in Winnipeg, is the parent company of Wawanesa General, which offers property and casualty insurance in California and Oregon; 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 two million members in Canada and the United States. Wawanesa actively gives back to organizations that strengthen communities where it operates, donating well above internationally recognized benchmarks for excellence in corporate philanthropy. Learn more at 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.
Job Responsibilities:
- 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 flush 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.
Qualifications
- Degree or certificate in Computer Science, Statistics, Mathematics, or a related field.
- 4 or more years 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.
- Deep understanding of data profiling techniques to analyze, identify, and document data patterns and anomalies.
- 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 (Redshift, Aurora PostgreSQL, DMS) would be 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 for 2023 recognizing that we are an exceptional place to work!
Diversity, Equity & Inclusion
Wawanesa is an equal opportunity employer and is committed to fostering a diverse workforce that is equitable and inclusive for all. Wawanesa provides equal employment opportunity to all employees and applicants without regard to an individual's protected status: race/ethnicity, colour, religion, creed, sex or gender, sexual orientation, gender identity or expression, family or marital status, pregnancy/childbirth or related conditions, national origin, disability, military or veteran status, or any other protected status. Disability or medical-related accommodations are available upon request throughout all aspects of the recruitment and selection process. Candidates requiring reasonable accommodations may contact, in confidence, jobs@wawanesa.com.
If you are interested in this exciting, challenging position with Wawanesa, apply today with your Resume.
All Wawanesa job applicants are subject to Wawanesa's Privacy Policy.
