Data Analyst (All PHLY Offices)

PHLY Insurance Services Inc; Bala Cynwyd (PA); On-site; USD 77,000 - 86,000; Full time

Job summary

PHLY Insurance Services Inc seeks a Data Analyst to drive data-driven decisions across our organization. You will analyze business data, support operational insights, and partner with IT and business units to deliver data products and dashboards that provide measurable value.

The role requires SQL, DataBricks, and BI tool experience, plus the ability to translate technical concepts into business language. Salary range is competitive and based on location and experience.

Qualifications

• Bachelor's degree in Business, Analytics, Information Systems, Statistics, Mathematics, Economics, or related field.
• 3+ years’ experience in insurance business processes, business analysis, data analysis, or similar.
• 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; 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.
• 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 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

Data analysis

Requirements elicitation

SQL

Data modeling

BI tools

Business communication

Education

Bachelor's degree

Tools

SQL

DataBricks

APIs

ETL

Power BI

Tableau

Qlik

Python

R

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

Typical Day

• 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

PHLY delivers comprehensive insurance coverage and risk management expertise in over 120 specialized business markets across the country. For over 60 years, we've focused on delivering unsurpassed customer service to our policyholders, agents, and broker partners. Headquartered just outside of Philadelphia and with more than 2,000 employees strategically located across the U.S., we consistently provide value-added coverages and services to customers. Our commitment to unsurpassed customer service, industry-leading financial strength, and talented employees help set us apart from other companies. PHLY is also a proud a member of the Tokio Marine Group, one of the largest global insurance groups in the world and a top 20 P/C carrier in the U.S.* *Based on a June 2022 AM Best Report on net written premium