Data Analyst I

Who are we

Western National Insurance Group is a private mutual insurance company with over 120 years of experience serving customers property-and-casualty insurance needs in the Midwestern Northwestern and Southwestern United States. Known as The Relationship Company we define success as a measure of the relationships weve built over everything that we do we know that delivering a friendly and helpful interaction makes for a better experience for everyone involved. Thats the power of nice. At Western National nice is something we work to bring to every person and organization with whom we partner and serve.

Does this opportunity interest you

Western National is seeking a Data Analyst I to join our team!

The individual in this role will have the opportunity to translate our business requests into results through data gathering and analysis. The individual in this role will partner with internal customers to clarify requirements and provide deliverables to 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 Engineering Team by testing and validating data elements via defined test plans.
• Updates and / or modifies existing published Insight content.
• Pulls data from cleansed data sources and primary source system tables.
• Recognizes data quality and business application.
• Assists team members with projects.
• Modifies and improves established reports.
• Creates new reports both ad hoc and recurring.
• Utilizes generative AI and other new technologies to improve productivity.
• Identifies new insights and process improvements.
• Builds an understanding of one to three insurance lines.
• Consistently acts according to our customer experience standards including responding quickly maintaining a positive attitude building rapport demonstrating empathy managing the customers expectations using the proper communication channel for the situation and taking ownership to ensure the customers issue is resolved.
• Performs special projects and other duties as assigned.

What are the must-have qualifications for a candidate

• Basic understanding of personal or commercial insurance lines.
• Up to three years of experience in data analysis reporting and data mining.
• Excellent oral and written communication skills with the ability to communicate with individuals at all levels of an organization.
• Excellent attention to detail.
• Ability to work independently and as part of a team.
• Ability to prioritize work to meet project deadlines.
• Some knowledge of SQL.
• Advanced experience with Microsoft Office tools and functions especially with pivot tables in Excel.
• Bachelors degree required related degree in science technology mathematics or business preferred.

What will our ideal candidate have

• Fundamental insurance knowledge preferably in pursuit of a CPCU or a similar insurance-related course of study.
• Previous experience working with data in a professional environment.

Compensation overview

The targeted hiring range for this role is $70000 - $80000 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 asset.

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 has also been named a Top Workplace by the Star Tribune for consecutive addition the Group is consistently recognized as a Wards 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 Flexible Spending Accounts (FSA)
• 401(k) Plan (participants are eligible for 100% matching on the first 6% of their contributions)
• Wellbeing Program including onsite fitness studio
• Paid Time Off including holiday vacation and volunteer
• 100% company-paid tuition reimbursement for approved job-relevant coursework and access to The Institutes (Risk and insurance education)
• Paid parental leave
• Bonus opportunities

Western National believes in supporting balance between work and life by providing a flexible work environment which includes a variety of hybrid and remote work arrangements designed to balance individual job department and company needs.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

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.