Senior Data Engineer- Bala Cynwyd, PA

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 designing, developing and maintaining data pipelines, data integration solutions and ETL/ELT processes utilizing data engineering tools and platforms to support analytics and reporting across TMNAS Business Units.

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

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field preferred
• Master’s degree 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

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.