Senior Data Engineer- Bala Cynwyd, PA

Tokio Marine Group of Companies•Lower Merion Township, PA

6d•$108,000 - $135,000

About The Position

Tokio Marine North America Services (TMNAS) provides professional support services to Tokio Marine Group companies in the United States. This role leads and/or participates in designing, developing, and maintaining data pipelines, data integration solutions, and ETL/ELT processes using data engineering tools and platforms to support analytics and reporting across TMNAS Business Units.

Requirements

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.
Superior attention to detail.
Ability to juggle multiple, competing, frequently changing time-sensitive deadlines and priorities.
Ability to work effectively and lead a team.

Nice To Haves

Master’s degree preferred.

Responsibilities

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.