Senior Data Engineer- Bala Cynwyd, PA

Reposted 3 Months Ago
Bala Cynwyd, PA, USA
In-Office
108K-135K Annually
Senior level
Insurance
The Role
Lead design, build, and maintain complex ETL/ELT data pipelines and integration solutions to support analytics and reporting. Ensure data quality, optimize processing for performance and scalability, monitor pipelines, document data lineage and procedures, and collaborate with stakeholders and analysts to resolve data issues and requirements.
Summary Generated by Built In

Marketing Statement:

Tokio Marine North America Services (TMNAS) provides professional support services to Tokio Marine Group companies in the United States, including Tokio Marine America, First Insurance Company of Hawaii, and Philadelphia Insurance Companies. Customer service is our focus and our passion! Tokio Marine North America Services adds value in all that we do, providing the best professional service to our business partners, allowing them to achieve their goals. Our talented team delivers actuarial, audit, corporate communications, financial and investment, human capital services, information technology, legal, and payroll expertise to our customers.

Job Summary: Leads and/or participates in the design, development, and maintenance of enterprise data solutions that support analytics, reporting, and business operations across TMNAS Business Units. Develops scalable data pipelines, data integration solutions, and cloud-based data engineering processes utilizing SQL, Python, Databricks, and related technologies. Supports both existing on-premises data warehouse platforms and the modernization of data assets and pipelines to cloud-based architectures while ensuring data quality, reliability, and performance.

 

Essential Job Functions:

  • Leads and/or participates in the design, development, and maintenance of scalable data pipelines, SQL-based data warehouse solutions, and cloud-native data engineering processes using Python, Databricks, and related technologies
  • Develops and implements data integration solutions that ensure the availability of trusted, high-quality data for analytics, reporting, business intelligence, and advanced analytics initiatives
  • Collaborates with data analysts, architects, engineers, and business stakeholders to understand business requirements and translate them into effective data solutions
  • Ensures data quality, consistency, and accuracy through data validation, reconciliation processes, and root-cause analysis of data issues
  • Optimizes SQL queries, data models, Spark workloads, and data processing workflows for performance, scalability, reliability, and cost efficiency
  • Monitors and supports production data pipelines and warehouse processes, proactively identifying and resolving issues to minimize downtime and business impact
  • Troubleshoots and resolves data-related technical issues while providing guidance and support to business and technical stakeholders
  • Documents data architectures, data lineage, pipeline designs, technical specifications, and data engineering best practices
  • Participates in the modernization and migration of data assets, integrations, and reporting solutions from on-premises data warehouse platforms to cloud-based architectures
  • Designs and develops reusable Python-based frameworks, automation solutions, and engineering utilities to improve operational efficiency and maintainability
  • Stays current with emerging data engineering technologies, industry trends, and best practices related to cloud platforms, Databricks, and modern data architectures
  • Creates, maintains, and updates Standard Operating Procedures, Knowledge Base Articles, FAQs, Design Documents, and Configuration Documentation

Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field preferred
  • 7+ years of overall IT experience
  • 5+ years of hands-on data engineering experience developing and supporting enterprise data solutions
  • Strong SQL development and data modeling skills required, including experience with SQL Server and enterprise data warehouse environments
  • Strong experience with Python for data engineering, automation, and data processing required
  • Strong experience with Databricks, PySpark, and distributed data processing required
  • Experience developing and supporting data pipelines across both traditional data warehouse and cloud-based environments preferred
  • Experience with cloud data platforms, Lakehouse architectures, Delta Lake, and modern analytical ecosystems preferred
  • Knowledge of Snowflake preferred
  • Experience with enterprise data integration tools such as Informatica is a plus
  • Knowledge of Property & Casualty Insurance industry preferred
  • Strong understanding of data warehousing concepts, dimensional modeling, and data architecture principles
  • Strong knowledge of data engineering technologies and tools, including data lakes, data warehouses, and cloud-based solutions
  • Experience with source control, CI/CD processes, automated testing, and data engineering best practices preferred
  • Strong written and verbal communication skills
  • Strong customer service orientation with a consultative, collaborative, and responsive approach
  • Strong interpersonal and relationship-building skills with the ability to work effectively across business and technical teams
  • Strong analytical and problem-solving skills with the ability to identify root causes and implement effective solutions
  • Strategic thinker with the ability to align technical solutions to organizational goals and priorities
  • Superior attention to detail
  • Ability to manage multiple priorities and time-sensitive deadlines in a fast-paced environment
  • Ability to work independently and effectively contribute to or lead technical initiatives

Salary range $108,000 to $135,000. Ultimate salary offered will be based on factors such as applicant experience and geographic location. Our company offers a competitive benefits package and bonus eligibility on top of base.

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. 

Skills Required

  • Bachelor's degree in Computer Science, Information Technology, or related field
  • Master's degree
  • 7+ years overall IT experience
  • 3+ years data engineering and management experience
  • Strong knowledge of SQL and SQL programming
  • SQL Server-specific knowledge
  • Strong knowledge of Python
  • Experience with cloud-based data platforms (Databricks, Snowflake, Azure)
  • Knowledge of Informatica
  • Proficiency in data processes and data modeling
  • Experience with data engineering technologies: data lakes, data warehouses, cloud solutions
  • Proficiency with Microsoft Office products (Excel, Word, Visio, PowerPoint)
  • Strong writing and communication skills
  • Strong analytical ability and problem root-cause determination
  • Ability to lead a team and collaborate with stakeholders
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Bala Cynwyd, PA
479 Employees
Year Founded: 2012

What We Do

We provide professional support services to the Tokio Marine Group of companies in the United States, including Tokio Marine America, the First Insurance Company of Hawaii, and the Philadelphia Insurance Companies. Among our professional service offerings are actuarial, financial, audit, payroll, human resource, legal, information technology, communications, and investment expertise. At Tokio Marine North America Services (TMNAS), customer service is our focus and our passion. We are recognized as a Best Place to Work in Insurance, Best Place to Work in Pennsylvania, and Philly.com Top Workplace. We are also recognized as one of the Healthiest 100 Workplaces in America. At Tokio Marine North America Services, we strive to add value in all that we do, providing the best professional service to our business partners, allowing them to achieve their goals. Our mission is to provide superior professional services which support the business and governance needs of our valued customers. Our values guide and direct our actions and our culture: *Customer-Centric Partnership *Integrity *Respect *Engagement *Innovation *Enthusiasm We strive to Empower our People, Look Beyond Profit, and Deliver on Commitments. We are passionate about the services we provide: Legal, Internal Audit, Actuarial, Finance & Accounting, Facilities, Communications, Human Resources, and Information Technology. It is only possible through the efforts of all employees that we are able To Be a Good Company, operating for the benefit of our customers, stakeholders, and society.

Similar Jobs

PNC Bank Logo PNC Bank

Infrastructure Engineer

Machine Learning • Payments • Security • Software • Financial Services
Remote or Hybrid
USA
55000 Employees
91K-203K Annually

Ahold Delhaize USA Logo Ahold Delhaize USA

Purchasing Manager

AdTech • eCommerce • Food • Marketing Tech • Retail
Hybrid
Carlisle, PA, USA
10000 Employees
93K-139K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
16 Locations
40000 Employees
45K-85K Annually

Optum Logo Optum

CNA Hospice Aide- Johnstown

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Johnstown, PA, USA
160000 Employees
14-23 Hourly

Similar Companies Hiring

MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account