.jpg)
.jpeg)
.jpeg)
.jpeg)
Western National Insurance
is hiring
Data Analyst
About Our Company
Western National Insurance, headquartered in Edina, Minn., is a super-regional group of property-and-casualty insurance companies providing personal and commercial coverage in 19 states across the Midwestern and Western U.S. as well as in Alaska; and surety bonds in 38 states. We distribute our products exclusively through trusted, professional Independent Insurance Agents.
Our insurance products and services allow individuals and businesses throughout our communities to have the peace of mind and financial security to focus on what is most important to them. Whether serving customers directly or working behind the scenes, every role at Western National provides a valuable contribution in which you can take pride.
WHY WESTERN NATIONAL?
At Western National, we attribute our success to the relationships we have built. For our customers, this means providing quality products and exceptional service. For our team members, this means an opportunity to build a meaningful career while maintaining a work/life balance. We encourage staff to take advantage of paid time-off, flexible working schedules, pre-arranged volunteer opportunities, and wellbeing programs that we offer. Our values, and the programs that support them, have resulted in our consistent ranking as a Star Tribune Top Workplace. More importantly, they are the reason that people choose to come to Western National and stay throughout their career.
Job Description & Responsibilities
Western National is seeking a Data Analyst I to join our team!
The individual in this role will have the opportunity to translate business requests into results through data gathering and analysis. They will partner with internal customers to clarify requirements and provide deliverables that meet their needs.
What are the responsibilities and opportunities of this role?
- Uses data to help solve business problems and answer questions about business performance and meets management and compliance, analytical and reporting needs.
- Develops an understanding of data available within the data warehouse and learns the data structure within the various source systems.
- Collaborates with the data management team by testing and validating data elements via defined test plans.
- Pulls data from SQL server and a cloud PostgreSQL data lake using SQL querying tools.
- Recognizes data quality and business application.
- Assists other data analysts with projects.
- Designs and builds business intelligence reports and dashboards using Tableau or SSRS.
- Modifies and improves established reports using Tableau or SSRS.
- Identifies new insights and process improvements.
- Builds an understanding of one to three insurance lines.
- Performs special projects and other duties as assigned.
Requirements
What is a must have?
- 0-3 years of experience in data analysis, reporting, and data mining.
What will our ideal candidate have?
- Basic insurance knowledge of assigned lines of business.
- Clear communication skills with the ability to communicate findings to various levels and departments within the organization.
- Ability to work independently and as part of a team.
- Ability to pay close attention to detail.
- Intermediate knowledge of SQL.
- Advanced Microsoft 365 knowledge, specifically pivot tables.
- Pursuit of CPCU or similar insurance-related course of study.
- Bachelor’s degree in science, technology, mathematics, business, or related field; experience in lieu of degree is acceptable.
What we offer
The full hiring range for this role is $61,400 - $84,480 annually. However, the base pay offered may vary depending on the job-related knowledge, skills, credentials, and experience of each candidate as well as other factors such as the scope and location of the role. Candidates looking for compensation outside of the posted range are encouraged to apply and will be considered based on their individual qualifications and/or may be considered for other positions.
Culture and Total Rewards
Western National has long been known as “The Relationship Company®” and caring for our employees is part of that relationship commitment. We value connectiveness, empowerment, and accountability, and we believe that our employees are our biggest assets. Nearly half of our employees choose to stay at Western National for ten years or more!
Currently ranked as the 41st largest private company by revenue in Minnesota (Minneapolis-St. Paul Business Journal), Western National has earned accolades year-over-year as an employer of choice and garnered multiple awards for wellness in the workplace. Western National was also named a Star Tribune Top Workplace in 2021, 2022, and 2023. The Group is consistently recognized as a Ward’s 50 property-and-casualty insurance company for its outstanding financial results.
Western National offers full time employees a significant Total Rewards Package, including:
- Medical insurance Plan options and other standard employee benefits, including dental insurance, vision benefits, life insurance, disability insurance, and more!
- Health Savings Accounts (HSA) and Flex Spending Accounts (FSA)
- 401(k) Plan (plus company match)
- Wellbeing Program, including onsite fitness studio
- Time Off – including vacation, volunteer, and holiday pay
- 100% company-paid tuition reimbursement for approved job-relevant coursework and access to The Institutes (Risk & Insurance Education)
- Paid parental leave
- Bonus opportunities
Western National believes in supporting balance between work and life by providing a flexible work environment, with includes a variety of hybrid and remote work arrangements designed to balance individual, job, department, and company needs.
Western National provides employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
