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