Lead Data Engineer

Lead Data Engineer

Jersey City, NJ (Remote Position)

About N2G Worldwide Insurance Services, LLC

N2G Worldwide is a joint venture created by Nationwide Mutual Insurance Company (Nationwide), one of the largest insurance and financial services companies in the U.S., and Generali Global Corporate and Commercial (Generali), a top global insurance company based in Italy. Corporate and Commercial (Generali), a top global insurance company based in Italy.

The combination of Nationwide and Generali allows N2G Worldwide to provide a lifetime of customized protection to our global clients through creativity, flexibility, renowned service and happy, innovative colleagues utilizing a powerful portfolio of global and local products, virtually unmatched in-house risk analytics, engineering and client service capabilities and an owned, 180+ country global network.

At N2G Worldwide, we aspire to be the most admired, most caring, most innovative and most colleague and client-focused provider of global insurance solutions in the market.

Position Overview

Lead Data Engineer is responsible for leading the migration and consolidation of enterprise data from multiple source systems - including CRM platforms, underwriting systems, pricing tools, policy administration systems, financial transaction systems, and external data feeds - into a unified cloud-based data lake and data warehouse.

Responsibilities include:

• Design the overall data architecture, including data models, schemas, and integration frameworks, to ensure long-term scalability, reliability, and maintainability.
• Develop, maintain, and optimize ETL/ELT pipelines to process and transform raw data into actionable datasets.
• Ensure data integrity and accuracy by implementing validation frameworks, conducting ongoing quality checks, and performing structured data cleanup in accordance with N2G’s data governance policies.
• Proactively monitor, tune, and optimize database and pipeline performance to meet defined business requirements and SLAs, including query optimization, indexing strategies, and workload balancing.
• Diagnose and resolve technical issues, including database errors, integration failures, performance bottlenecks, and data inconsistencies.
• Oversee system maintenance activities, including security patches, upgrades, backups, and monitoring, to ensure compliance with regulatory and internal standards.
• Partner with executives, business units, underwriting and pricing teams, carrier partners, and compliance teams to gather reporting and analytics requirements and translate them into technical solutions.
• Enhance and maintain internal BI reporting solutions, enabling self-service analytics while enforcing role-based access controls and data security.
• Provide guidance and oversight to developers responsible for database development, ETL/ELT processes, integrations, and reporting solutions, ensuring adherence to coding standards, data governance policies, and best practices.
• Support the evolution of N2G’s system integrations, internal and external data streams, underwriting platforms, pricing tools, and downstream systems.
• Position is 100% remote work from home full-time from anywhere in mainland USA.

Experience And Skill Requirements

• U.S. Master’s degree (or foreign degree equivalent) in Analytics, Data Analytics, Computer Science or Risk Management.
• 2 years’ experience in the job offered or a related occupation.
• Experience building and managing data pipelines, ETL/ELT processes, and integrations using programming languages such as Python, R, and SQL.
• Knowledge in insurance domain data, including policy types, transactions, and performance metrics, and the ability to translate business requirements into technical data solutions.
• Experience providing guidance and oversight to development teams, ensuring adherence to coding standards, best practices, and data governance policies.
• Experience with database performance tuning, troubleshooting, security, and data integrity, ensuring compliance with regulatory and internal standards.

Position Salary and Benefits

The annual salary for this position is $118,000 per year. N2G Worldwide Insurance Services offers a comprehensive benefits plan that includes the following: Paid holidays, flexible discretionary time off, sick, maternity and parental leave plan, vision, dental and medical health plans, employer paid life insurance, 401k with company match, short term and long-term disability, direct deposit, and employee assistance program.