Data Analyst (All PHLY Offices)

Philadelphia Insurance Companies; Lower Merion Township (Montgomery County); On-site; USD 77,000 - 86,000; Full time

Job summary

Philadelphia Insurance Companies in the United States seeks a Data Analyst to support data-driven decision making by analyzing business data and delivering actionable insights through reports, dashboards, and data products.

You will partner with IT and business units to translate needs into technical solutions, ensuring data quality and governance while delivering measurable value across operations.

Qualifications

• Bachelor’s degree in a related field preferred.
• 3+ years’ experience in insurance data analysis or business analysis.
• Strong ability to elicit, analyze, and document business requirements.
• Ability to query, process, and interpret data; identify patterns and insights.
• Familiarity with SQL, DataBricks and data modeling concepts; APIs/ETL preferred.
• Experience with BI tools (Power BI, Tableau, Qlik).
• Basic proficiency in Python or R for data manipulation.

Responsibilities

• Elicit, document, and validate business and data requirements, including constraints and dependencies.
• Perform gap analysis on source data and identify data quality issues.
• Serve as a SME for the organization’s operational workflows, base data models and related data products.
• Collaborate with technical teams to design and prototype reports, dashboards, and data visualizations.
• Liaise with technical teams to support cross-system integrations and data flows.
• Support debugging and enhancement of existing activations.
• Support the data governance team with standards and best practices.

Skills

Business analysis

Data analysis

Requirements gathering

Data storytelling

Education

Bachelor’s degree in Business, Analytics, Information Systems, Statistics, Mathematics, Economics, or related field

Tools

SQL

DataBricks

APIs

ETL concepts

Relational databases

Job description

Marketing Statement:

Philadelphia Insurance Companies, a member of the Tokio Marine Group, designs, markets and underwrites commercial property/casualty and professional liability insurance products for select industries. We have been in operation since 1962 and are nationally recognized as a member of Ward’s Top 50 and rated A++ by A.M.Best.

We are looking for a Data Analyst to join our team open to join our team!

Summary:

The Data Analyst supports data-driven decision-making across the organization by analyzing business data to support and enhance the rollout of operational insights, reporting tools and data products. This role partners closely with IT and business units to connect business needs with technical solutions, ensuring data products deliver actional insights and measurable value. The Data Analyst will act as the liaison between business stakeholders and technical teams, ensuring clarity, alignment and successful delivery of data initiatives.

A typical day will include the following:

• Elicit, document, and validate business and data requirements, including constraints and dependencies.

• Perform gap analysis on source data and identify data quality issues.

• Serve as a Subject Matter Expert (SME) for the organization’s operational workflows, base data models and related data products.

• Collaborate with technical teams to design and prototype reports, dashboards, and data visualizations.

• Liaise with technical teams to support cross-system integrations and data flows.

• Support debugging and enhancement of existing activations.

• Support the data governance team with standards and best practices.

• Pay Range $77,000-86,000.

• Ultimate salary offered will be based on factors such as applicant experience and geographic location.

Qualifications:

• Bachelor’s degree in Business, Analytics, Information Systems, Statistics, Mathematics, Economics, or a related field preferred.

• 3+ years’ experience working with insurance business processes, business analysis, data analysis or a combination of thereof.

• Strong ability to elicit, analyze, and document business requirements.

• Ability to query, process, and interpret data; identify patterns, anomalies, and insights.

• Familiarity with relational databases, SQL, DataBricks and data modeling concepts as well as understanding of APIs, data pipelines, and ETL processes preferred.

• Experience with BI tools (Power BI, Tableau, Qlik or similar)

• Basic proficiency in Python, R, or similar for data manipulation and automation.

• Skilled at translating technical concepts into business language.

EEO Statement:

Tokio Marine Group of Companies (including, but not limited to the Philadelphia Insurance Companies, Tokio Marine America, Inc., TMNA Services, LLC, TM Claims Service, Inc.and First Insurance Company of Hawaii, Ltd.) is an Equal Opportunity Employer. In order to remain competitive we must attract, develop, motivate, and retain the most qualified employees regardless of age, color, race, religion, gender, disability, national or ethnic origin, family circumstances, life experiences, marital status, military status, sexual orientation and/or any other status protected by law.

Benefits:

We offer a comprehensive benefit package, which includes tuition reimbursement and a generous 401K match. Our rich history of outstanding results and growth allow us to focus our business plan on continued growth, new products, people development and internal career opportunities. If you enjoy working in a fast paced work environment with growth potential.
Additional information on Volunteer Benefits, Paid Vacation, Medical Benefits, Educational Incentives, Family Friendly Benefits and Investment Incentives can be found at https://www.phly.com/Careers/default.aspx