[Remote] Lead Data Engineer

Note: The job is a remote job and is open to candidates in USA. N2G Worldwide Insurance Services, LLC is hiring a Lead Data Engineer to lead the migration and consolidation of enterprise data from multiple source systems into a unified cloud-based data lake and data warehouse. The role focuses on data architecture, pipelines, data quality and performance, integrations, BI reporting, and technical guidance for developers.

Responsibilities

• 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

Skills

• 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

Benefits

• Paid holidays
• Flexible discretionary time off
• Sick leave
• 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
• Employee assistance program

Company Overview