• Junior Data Analyst

    Job Locations US-MN-Edina
    Posted Date 3 weeks ago(11/20/2018 12:27 PM)
    # of Openings
  • Overview

    Western National is seeking a Junior Data Analyst to join our growing organization. This position will work closely with multiple business units throughout the organization helping to support data extraction and analytics needs.


    The ideal candidate will have 0-2+ years of Data Analysis experience preferably within the Insurance Industry or a degree with a focus in Data Analytics. This role will use SQL to extract data but will also have a strong focus on analyzing the data to help come up with solutions to the business. This role will combine Technical and business aspects.


    • Work on analytical projects to help management understand detailed information about their business portfolio.
    • Produce meaningful reports and ad-hoc analysis relating to premiums, losses, business processes, agency performance and other areas that support the business.
    • Provide trend analysis and ad hoc data related activities; effectively communicate insights to customers in a clear and concise manner.
    • Conduct pre/post-rate change impact analysis to ensure our products maintain a competitive position.
    • Collaborate across several business units including Underwriting, Marketing, Product Management, and Claims to identify opportunities to improve company or operational performance.
    • Understand, extract, validate / correct and define data from multiple internal and external sources.
    • Collaborate with IT Data Management by prioritizing and defining requirements for future development and testing data elements.
    • Update and enhance existing reports and create or modify dashboards that help end users better understand their book of business.
    • Join data elements from various source systems; build data sets that allow for various types of aggregation and analysis.
    • Develop and refine sustainable processes that help improve efficiency.


    • Previous Analytical experience within the Data world including previous experience in data mining, analysis and reporting is strongly preferred.
    • Bachelor’s degree in Data Analysis, Math or similar major is required.
    • Ability to accurately identify, document and recommend solutions to business problems.
    • Advanced MS Office skills with strong focus on Excel is required.
    • Experience creating and presenting ad hoc date related analysis.
    • Experience or understanding of SQL and ability to create queries to extract data is preferred.
    • Experience extracting data from an enterprise data warehouse and core operating systems.
    • Understanding of different data visualization tools with a strong focus on Tableau is preferred.
    • Ability to communicate clearly and effectively both verbally and in writing to technical and non-technical audiences.
    • Experience in P&C insurance industry is preferred. 


    Western National Insurance is a growing, A+ rated (A.M. Best) group of property-and-casualty insurance companies serving individuals, families, and businesses in 20 states across the Midwestern and Western U.S. plus Alaska. Currently ranked as the 57th largest private company by revenue in Minnesota (Minneapolis-St. Paul Business Journal), Western National has consistently earned accolades as an employer of choice, including as a Star Tribune Top Workplace (2011 – 2016), and previously as a recipient of the Minnesota Business Ethics Award, as a Minnesota Business Magazine Top 100 Workplace, as a Principal Financial “10 Best” Company, and as a finalist for the Alfred P. Sloan “When Work Works” Award.


    Western National is known as “The Relationship Company®”, and caring for employees is a key part of that relationship commitment. Western National offers competitive pay, advancement opportunities, a generous benefits package, a robust wellbeing program, and a healthy work/life balance (including three weeks of paid time off, nine paid holidays, and eight hours of paid volunteer time as a starting point for new employees). These attributes are just some of the reasons why nearly half of our employees choose to stay on the Western National team for 10 years or more.


    Our benefits package includes:

    • 401(k) company match
    • Medical insurance – We offer affordable (thanks to a strong employer subsidy), above-average coverage and the choice of either a traditional Preferred Provider Organization (PPO) option OR a High-Deductible Health Plan (HDHP) option
    • Western Wellbeing program – Including on-site massage, yoga classes, salad and healthy snack days, sit/stand workstations, nutrition seminars, and more
    • 100% company-paid tuition reimbursement for approved, job-relevant coursework
    • Discounts on automobile and homeowner's insurance
    • Other standard employee benefits – Including dental insurance, vision benefits, life insurance, disability insurance, and more


    We could continue to list the things that we think make Western National a great place to work, but why not hear it instead from actual current and former employees? Here are some quotes that Western National employees have posted to the Glassdoor public review site:

    • “Excellent company which prioritizes customer service and community service.”
    • “Just a great place to come to work, and stay for a career. I love the personal touch from [the] executive suite on down. [The] CEO is on a first-name basis with everyone.”
    • “Above-average benefits, especially on the health insurance front.”
    • “I have felt welcomed here and I feel like the Senior Management cares.”


    (For more reviews from current and former Western National employees, you can visit the company’s Glassdoor page here: http://bit.ly/2qXtl4A .)


    ***Western National is an equal opportunity employer. All qualified applicants will receive consideration for employment.***


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed