Master's degree in Analytics, Data Analytics, Computer Science, or Risk Management (or equivalent)
2 years of experience in data engineering or related roles
Proficient in building and managing data pipelines using Python, R, and SQL
Familiarity with insurance domain data and translating business needs into technical solutions
Experience in guiding development teams on coding standards and data governance
Skilled in database performance tuning and ensuring data integrity
Responsibilities
Design data architecture, models, and integration frameworks for scalability and reliability
Develop and optimize ETL/ELT pipelines for actionable data processing
Implement validation frameworks and conduct quality checks to ensure data accuracy
Monitor and optimize database and pipeline performance to meet business SLAs
Diagnose and resolve technical issues related to databases and data integration
Oversee system maintenance activities for compliance with standards
Collaborate with various teams to gather analytics requirements and translate them into technical solutions
Enhance internal BI reporting solutions for self-service analytics while ensuring data security
Benefits
Paid holidays
Flexible discretionary time off
Sick, maternity, and parental leave
Vision, dental, and medical health plans
Employer-paid life insurance
401k with company match
Short-term and long-term disability
Employee assistance program
Full Job Description
Lead Data Engineer
Jersey City, NJ (Remote Position)
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.
