Lead Data EngineerJersey City, NJ (Remote Position)Position OverviewLead 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 BenefitsThe 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.
