Data & Business Intelligence Analyst - HYBRID

Penn National Insurance - Harrisburg, PA

Full-time - Entry Level

Hybrid - Harrisburg, PA

Insurance Carriers and Related Activities

About the position

The Data & Business Intelligence Analyst at Penn National Insurance plays a crucial role in supporting the Enterprise Data Warehouse and Advanced Analytics initiatives. This hybrid position involves data collection, manipulation, reporting, and analysis to enhance decision-making processes across various departments. The analyst will collaborate with multiple teams to identify data needs, develop training, and ensure data quality while contributing to the overall efficiency of the organization.

Responsibilities

• Maintain and update data including extracts, queries, aggregates, and snapshots.
• Extract data for ad hoc predictive modeling projects.
• Identify and recommend internal and external data for modeling and decision making.
• Provide data and analysis for ad hoc projects as directed.
• Create and update systems documentation including business or systems requirements, change requests, and report layouts.
• Develop and deliver system training courses for corporate and service office business clients.
• Support data needs of various departments including Commercial Lines, Personal Lines, Claims, IT, Actuarial, Finance, and Customer Experience.
• Collaborate with staff to solve problems and suggest efficient processes.
• Assist the Enterprise Data Warehouse team with metadata and ad hoc data extracts.
• Test data extracts, queries, aggregates, and snapshots.
• Estimate, plan, lead, organize, control, and report status for small-to-medium sized projects.
• Support modelers with data needs in large modeling projects and smaller ad hoc projects.
• Analyze data quality and recommend improvements.
• Act as a liaison between business and IT personnel.
• Design and program ad hoc business intelligence solutions.
• Identify problems that data analytics might help solve and opportunities to use data analytics for decision making.
• Compile, manipulate, synthesize, validate, and analyze data.
• Effectively communicate analytics results graphically and via narrative.

Requirements

• Bachelor's Degree in Mathematics, Computer Science, or a related field.
• Minimum of 2 years professional statistical or analytical experience, preferably in property and casualty insurance.
• Programming skills in structured query language or other data management/analysis applications, such as Microsoft Access, SQL, or other database programs.
• Experience designing reports for end-users preferred.
• Working knowledge of the property/casualty insurance industry and operations.
• Excellent communication skills, both oral and written.
• Strong organizational and time management skills.
• Good interpersonal skills.
• Thorough knowledge of data warehousing and Penn National's Enterprise Data Warehouse.
• Excellent PC skills, with an emphasis on Access, Excel, Pivot Tables, Power Pivot, and SharePoint.
• Familiarity with Data Warehouse concepts and database querying language such as MS SQL.

Nice-to-haves

• Experience with business object-oriented databases and XML.
• Familiarity with ETL and BI concepts.

Benefits

• Health insurance
• 401k retirement plan
• Paid holidays
• Flexible scheduling
• Professional development opportunities