Lead Data Engineer

N2G•Jersey City, NJ

2d•Remote

About The Position

The Lead Data Engineer leads 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. The role designs scalable, reliable, and maintainable data architecture; develops and optimizes ETL/ELT pipelines; and ensures data quality, integrity, security, and performance in accordance with business requirements, service-level agreements, governance policies, and regulatory and internal standards. The Lead Data Engineer partners with executives and business, underwriting, pricing, carrier, and compliance teams to gather analytics and reporting requirements and turn them into technical solutions. The role maintains internal BI reporting and supports self-service analytics with appropriate access controls. It also guides developers working on databases, pipelines, integrations, and reporting, and supports the evolution of internal and external data streams and downstream systems. The position is full-time and 100% remote from anywhere in the mainland United States.

Requirements

U.S. Master’s degree or foreign degree equivalent in Analytics, Data Analytics, Computer Science, or Risk Management.
Two years of 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 of insurance-domain data, including policy types, transactions, and performance metrics, and 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.

Responsibilities

Design data architecture, including data models, schemas, and integration frameworks, for long-term scalability, reliability, and maintainability.
Develop, maintain, and optimize ETL/ELT pipelines to transform raw data into actionable datasets.
Implement validation frameworks, perform ongoing data-quality checks, and conduct structured data cleanup in accordance with data governance policies.
Monitor and optimize database and pipeline performance, including query optimization, indexing strategies, and workload balancing, to meet business requirements and SLAs.
Diagnose and resolve database errors, integration failures, performance bottlenecks, and data inconsistencies.
Oversee security patches, upgrades, backups, and monitoring to support 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.
Guide and oversee developers responsible for database development, ETL/ELT processes, integrations, and reporting solutions, ensuring adherence to coding standards, governance policies, and best practices.
Support the evolution of system integrations, internal and external data streams, underwriting platforms, pricing tools, and downstream systems.