Business Intelligence Associate - P&C (Remote Nationwide)

Homesite Insurance was founded in 1997 and was one of the first companies to enable customers to purchase home insurance directly online, during a single visit. Since then, we've continued to innovate rapidly to meet the needs of our customers and their changing expectations.

One thing that's stayed the same since our founding: our commitment to our customers, partners and employees.

Join us on our journey as we continue to grow into a powerful contender in the field of insurance.

Compensation may vary based on the job level and your geographic work location.

Compensation Minimum:

Compensation Maximum:

We are seeking a Business Intelligence Analyst with insurance/product management experience excited to build and work with tools / models that drive our profit and loss analytics for the property line of business in our Product Management Center for Excellence. This role will report directly to the head of our Property CW Analytics Tools and Insights Senior Manager.

The Business Intelligence Analyst is part of the Product Management team and will work cross functionally within Product Management on a regular basis to design and build financial and operational models and tools to report on and analyze performance and influence product improvements. Strong candidates are collaborative, curious, have a passion for working with data, problem solvers with have strong quantitative acumen, will demonstrate strong analytical and problem-solving skills. This position offers an excellent opportunity to interact with a variety of departments in the organization (Government Affairs, Compliance, IT Leadership, Partner Management, Operations, Claims, etc.) and the broader American Family community.

Primary Roles and Responsibilities:

Contribute to the development and streamlining of new tools: Create, maintain, and improve reporting and analytical tools (including dashboards) for countrywide and State insights.

• Create a streamlined suite of standard reports (pivot tools, exhibit support, dashboards) leveraging the GCP (Google Cloud Platform) to report on operational performance (Quote flow, Policy Attribution, Retention, Premium and Growth, Loss and Combined Ratios)

• Build tools to enable analysts and state management to better support underwriting decisions (leakage reports, Day 1 implementation monitoring, mix of business reports, state deep dives)

• Streamline data visualization best practices (Tableau, Power BI, Excel, Google Sheets) for reporting and communicating operational results

Product Insights: Deliver operational insights to achieve key performance indicators through analysis of the drivers of profitability, including production, retention, average premium, frequency/severity trends, loss ratios, and other data. Recommend actions to achieve profitability and growth goals. Perform modeling, “what-if’, scenarios on production, premium, and loss trends.

Monthly / Quarterly Financial Reporting assist in the project management and creation of the monthly and quarterly reporting on Property Business results, enabling variance analysis to be performed on a countrywide basis, understand peril drivers, and claims and sales performance.

Requirements

Relevant Experience: A minimum of 4 years of professional experience, ideally including work in Property & Casualty insurance.

Educational Credentials: A bachelor’s degree and quantitative analytical knowledge is required; a graduate degree and/or CPCU designation is preferred, but not required.

Entrepreneurial Mindset: A self-starter who can identify business opportunities, develop a product plan to capitalize on those opportunities, and successfully implement the plan.

Structured & Logical Thinking: The ability to identify and define business problems and issues, and develop strategic, analytical, and financial frameworks to conduct analyses.

Analytical Rigor: Analyze state performance, identify additional areas of research, and recommend improvements.

Powerful Communication: The ability to communicate effectively and succinctly across a variety of media.

Team Player: The candidate is collaborative, and able to work well as part of a team.

Software Experience: Subject matter expertise in the areas of SQL, SAS, R, Python, Tableau, and/or other programming/data query/reporting knowledge, in addition, intermediate to advanced skills in Microsoft Excel is required

Personal Qualifications:

The candidate selected for this position will be a creative, out-of-the-box thinker who is intellectually curious with a demonstrated interest in learning. This person will also need to be a self-motivated, enthusiastic individual who can easily function in a fast-paced, performance-driven environment. He/she must have a passion for working with big data, and building simple, visual tools and reports to analyze results. Be accustomed to working on multiple tasks in parallel and committed to meeting deadlines, including some with short time frames. This professional must demonstrate strong leadership skills, including the ability to gain credibility with and influence both team members and management.

#LI-Remote

When you work at Homesite you can expect benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, and a paid-time off program. In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Enterprise benefits.

Stay connected: Join Our Enterprise Talent Community!