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.