Senior Data Engineer

Tokio Marine North America Services; Bala Cynwyd (PA); On-site; USD 110,000 - 150,000; Full time

Job summary

Tokio Marine North America Services (TMNAS) is seeking a data engineering professional to design and optimize complex data pipelines and ETL processes. You will collaborate with analysts, architects, and stakeholders to ensure high-quality, scalable data solutions for analytics and reporting.

Responsibilities include data quality, workflow optimization, documentation, and staying current with industry trends.

Qualifications

• Bachelor’s degree in computer science, information technology, or a related field preferred.
• 7+ years of overall IT experience.
• 3+ years of experience in data engineering and management.
• Strong knowledge of SQL and SQL programming. SQL Server-specific knowledge required.
• Strong knowledge of Python preferred.
• Strong knowledge of cloud-based data platforms preferred (Databricks/Snowflake/Azure).
• Knowledge of Informatica is preferred.
• Knowledge of P&C Insurance industry preferred.
• Strong proficiency in data processes and data models.

Responsibilities

• Leads and/or participates in the design and development of complex data pipelines and ETL processes.
• Leads and/or participates in implementation of data integration solutions for analytics and reporting.
• Collaborates with data analysts, architects, engineers and stakeholders to understand data requirements.
• Ensures data quality and consistency by identifying and resolving data issues and creating data reconciliations.
• Optimizes data workflows for performance, scalability, and reliability.
• Monitors data pipelines and addresses issues to minimize downtime.
• Documents data engineering processes, lineage, and dictionaries.
• Stays current with data engineering technologies and industry trends.
• Creates and maintains knowledge articles and SOPs.

Skills

SQL (SQL Server)

Python

Cloud data platforms

Databricks

Snowflake

Azure

Informatica

Data modeling

Data lakes/warehouses

Office tools

Communication

Team leadership

Education

Bachelor’s degree in Computer Science or related field

Tools

Databricks

Snowflake

Azure

Job description

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.

Essential Job Functions:

• Leads and/or participates in the design and development of complex data pipelines, ETL (Extract, Transform, Load) processes and decision support systems’ data procedures.
• Leads and/or participates in implementation of data integration solutions to ensure the availability of high-quality data for analytics and reporting.
• Collaborates with data analysts, architects, engineers and business stakeholders to understand data requirements.
• Ensures data quality and consistency by identifying and resolving data issues and creating data reconciliations.
• Optimizes data workflows and processing for performance, scalability, and reliability.
• Monitors data pipelines and proactively addresses issues to minimize downtime and disruptions.
• Works with stakeholders to aid with data-related technical issues.
• Documents data engineering processes, data lineage, and data dictionaries.
• Stays current with data engineering technologies, best practices, and industry trends.
• Creates, maintains and updates various knowledge articles such as Standard Operating Procedures, Knowledge Base Articles, FAQ, Design and Configuration documents.

Other Functions:

• Complies with proper internal controls as necessary to conduct job functions and/or carry out responsibilities and/or administrative activities at the Company.
• Establishes and builds strong working relations and partnerships with Business Units and IT teams.
• Performs special projects and other duties as may be assigned.
• Assists in data governance, data quality and data cleansing efforts.
• Contributes to disaster recovery and business continuity planning for data engineering.
• Participates in data architecture and data warehouse design discussions.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field preferred.
• 7+ years of overall IT experience.
• 3+ years of experience in data engineering and management.
• Strong knowledge of SQL and SQL programming. SQL Server-specific knowledge required.
• Strong knowledge of Python preferred.
• Strong knowledge of cloud-based data platforms preferred (Databricks/Snowflake/Azure).
• Knowledge of Informatica is preferred.
• Knowledge of P&C Insurance industry preferred.
• Strong proficiency in data processes and knowledge of data models.
• Strong knowledge of data engineering technologies and tools, including data lakes, data warehouses, and cloud-based solutions.
• Knowledge of Microsoft Office products (Excel, Word, Visio, PowerPoint).
• Knowledge of techniques for recognizing, anticipating, and resolving organizational, operational, or process problems, ability to apply this knowledge appropriately to diverse situations.
• Proactive approach in staying updated on industry trends and emerging data technologies.
• Strong writing and communication skills.
• Strong customer service orientation (responsive, consultative, collaborative and accurate).
• Strong interpersonal relationship building skills: able to work with a variety of people and groups in a constructive and collaborative manner.
• Strong analytical ability with the capability to determine the root cause of problems and issues and provide solutions.
• Strategic thinking: Applies organizational acumen to identify and maintain focus on key success factors for the organization.
• Ability to juggle multiple, competing, frequently changing time-sensitive deadlines and priorities.
• Ability to work effectively and lead a team.

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.