Senior Business Intelligence Developer
Date: Sep 5, 2024
Location: Hybrid - Canada, CA
Company: Wawanesa Insurance
Job ID: 8166
Working Business Language: English. 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: $80,000-115,000 CAD per year. 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
Working under minimal supervision, we are seeking a to Senior Business Intelligence Developer who will contribute to Wawanesa success by creating, maintaining, and optimizing MicroStrategy and/or PowerBI reporting solutions. This role will primarily be responsible for supporting the analysis, design, development, and maintenance of reporting solutions within our Business Intelligence environment.
Job Responsibilities
- Design, develop, and test reporting solutions in our BI Reporting environment (MicroStrategy and Power BI).
- Back-end data integration and architecture including BI data modeling, and performance tuning.
- Prepare technical specifications through collaboration with business partners to elicit requirements.
- Collaborate with multiple stakeholders to diagnose, troubleshoot, and resolve incidents supporting our Business Intelligence environment.
- Understand and profile data to extract patterns, and trends to create Business Insights with a focus on optimal user experience and data quality.
- Translate complex data sets into clear and compelling visualisations.
- Participate in code reviews.
- Coordinate with analysts and operations team for environments availability, stability, and deployments.
- Estimate and track progress of assigned work.
- Create and update relevant documentation.
- Follow established practices, processes, and guidelines.
- Keep current with relevant technologies.
Qualifications
- Completion of Post-secondary degree or diploma with 8+ years of relevant experience in Business Intelligence/reporting experience.
- Extensive experience of 5+ years in a Business Intelligence development and/or architectural role working with MicroStrategy and/or Power BI.
- Proficient in complex SQL (multi joins, subqueries, analytical functions, nested and recursive CTEs), and creation of database objects (tables, views, materialized views).
- Construct and maintain robust data models to support dynamic and scalable reporting solutions.
- Optimize BI architecture, reports, and queries to ensure fast and efficient performance, especially when dealing with large volumes of data.
- Knowledge of Data Warehousing concepts with a focus on Kimball Based Data Models, and relational database concepts.
- Detail oriented with analytical and problem-solving skills to recognize and identify issues and take proper action to resolve them.
- Ability to work independently with little direct supervision and as a member of a multi-disciplinary team.
- Ability to deal well with ambiguity, deliver results in a fast-paced environment.
- Effective communication skills, with the ability to communicate in a clear and concise manner with style fitting for the audience and message.
- Strong ability to work collaboratively in a team environment by making quality contributions and supporting fellow team members.
- Strong organizational skills with the ability to self-manage a fluctuating workload, with various situations and changing priorities.
- Possesses a willingness to learn while keeping abreast of developments in field with the ability to apply learning to new situations.
- Experience using software development tools, such as JIRA, Confluence and Source Code Management is considered an asset.
- Certifications in relevant technology is considered an asset.
- Knowledge and experience in the Insurance industry and Guidewire Insurance Suite is considered an asset.
- Python coding considered an asset.
- AWS experience and familiarity with Redshift and PostgreSQL databases considered a strong asset.
#LI-HYBRID
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!
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.