Data Analyst I- Commercial Lines

Recognized as a Milwaukee Journal Sentinel Top Workplace for 12 consecutive years, including three years of being honored as number one! Join us at West Bend, where we believe that our associates are our greatest asset. We hire talented individuals who are conscientious, dedicated, customer focused, and able to build lasting relationships. We create and maintain an environment where you feel a sense of belonging and appreciation. Your diversity of thought, experience, and knowledge are valued. We’re committed to fostering a welcoming culture, offering you opportunities for meaningful work and professional growth. More than a workplace, we celebrate our successes and take pride in serving our communities.

As a Data Analyst on the Commercial Enterprise Analytics team, you'll play a key role in transforming datasets into actionable insights that drive strategic decisions. Using your expertise in SQL, SAS, or PowerBI, you’ll perform analysis and create compelling visualizations and reports. Your work will enable stakeholders to make informed decisions and guide crucial business strategies.

In this role, you'll collaborate with fellow analysts and cross-functional teams to address business needs and communicate insights effectively. Your ability to translate technical data into impactful business strategies will be essential in shaping our commercial success and driving growth. If you’re passionate about data and innovation, this is your opportunity to make a significant impact.

Under minimal supervision, monitors all aspects of premium production, including new business flow and the various components of retention. Aggregates and performs analysis on business data based on requests from leadership within the Commercial Enterprise. Ensures data quality in reported results. Interprets data to identify business trends and identifies possible causes. Integrates data from multiple data sources or functional areas when necessary. Writes queries or reports to provide data for analytical projects, and wherever possible utilizes a self-serve query tool like Power BI to empower end-users of the reports. Educates internal users on various reports and how to use them effectively. Serves as a Business Power User for Business Objects and other reporting tools. Runs and publishes monthly/quarterly reports separate from certified BI Portal content.

Note: the CE Analytics team is not responsible for forecasting and advanced analytics like ML and AI, or storage or curation of raw data.  This team works primarily with curated data for reporting or the joining of curated datasets to build reports.

Preferred Experience and Skills:

• 4-6 years of commercial insurance experience
• Analytical and proficient with numbers and formulas
• Advanced knowledge of MS Excel, Access, and Business Objects
• Knowledge of Python and/or SQL 
• Knowledge of Power BI
• Understanding of insurance metrics
• Understanding of databases, data sets, and tabular models.

Preferred Education and Training

• Bachelor’s degree in Business, Insurance, or related field
• Associate in General Insurance designation

#LI-CB

West Bend provides equal employment opportunities to all associates 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.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, and promotion.