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.