Data Analyst (All PHLY Offices)

Philadelphia Insurance Companies; Bala Cynwyd (PA); On-site; USD 77,000 - 86,000; Full time

Job summary

Philadelphia Insurance Companies is seeking a Data Analyst to analyze business data and support operational insights, reporting tools, and data products. You will partner with IT and business units to translate needs into technical solutions, ensuring data initiatives deliver measurable value.

You will act as a liaison between stakeholders and technical teams for successful delivery. The role emphasizes eliciting requirements, data quality improvements, dashboard prototyping, and governance

Qualifications

• Bachelor's degree in Business, Analytics, Information Systems, Statistics, Economics, or related field preferred.
• 3+ years' experience in insurance business processes, business analysis or data analysis.
• Ability to elicit, analyze, and document business requirements.
• Ability to query, process, and interpret data; identify patterns and insights.
• Familiarity with relational databases, SQL, DataBricks and data modeling concepts.
• Experience with BI tools (Power BI, Tableau, Qlik or similar).
• Basic proficiency in Python, R, or similar for data manipulation and automation.
• Strong ability to translate technical concepts into business language.

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 Subject Matter Expert (SME) for the organization’s data models and 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

SQL

Python basics

Data visualization

Education

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

Tools

Power BI

Tableau

Qlik

APIs

ETL concepts

Job description

Description

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.

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.
• 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