Data Analyst -Commercial Lines (Power BI)

at  West Bend Insurance Company

Company Overview:
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.
Job Summary:
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 as a Power BI developer, as well as utilizing Python or SQL within Databricks to create new datasets, you’ll create compelling visualizations and reports - enabling stakeholders to make informed decisions and guide crucial business strategies.
Responsibilities & Qualifications:
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:

• 3+ years of commercial insurance experience
• 2+ Years of experience as Power BI developer
• Analytical and proficient with numbers and formulas
• Advanced knowledge of MS Excel, Access, and Business Objects
• Knowledge of Python and/or SQL
• 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

Please refer the Job description for details