Senior Data Engineer

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.