Lead Data Engineer — Architecting Scalable Data Platforms

ISO New England Inc.; Manchester (NH); Hybrid; USD 150,000 - 170,000; Full time

Benefits offered by this job

Competitive base salary with bonus

401(k) and financial planning

Tuition reimbursement

Wellness programs

Flexible work hours

Hybrid work environment (3 days onsite

Relocation assistance

On-call rotation

Onsite gym

Job summary

ISO New England is seeking a Lead Data Engineer to design, build, and maintain enterprise data warehouses, data marts, and BI data systems that support strategic decisions. You will own data architecture, ensure reliability, and mentor the data engineering team.

The role includes a 24/7 on-call rotation, a hybrid work model (3 days onsite), and a competitive compensation package with bonus and comprehensive benefits.

Qualifications

• 8 years of experience in data engineering, BI, or analytics roles.
• 5 years of hands-on SQL and Python, building scalable data pipelines.
• 5 years of experience with cloud-based data platforms (AWS preferred: S3, Lambda, Athena, Aurora, Glue, Redshift).
• Strong expertise in relational data modeling, database design, and performance optimization (PostgreSQL preferred).
• Experience mentoring and developing engineers, fostering best practices and code quality.
• Strong communication skills and ability to translate business requirements into scalable data solutions.
• Ability to influence architectural decisions and collaborate cross-functionally with engineering, analytics, and business teams.

Responsibilities

• Own Data Architecture & Solution Delivery
• Lead the design and implementation of scalable data platforms, including data warehouses, data marts, and ETL/ELT pipelines.
• Establish standards and best practices for data modeling, transformation, and system design.
• Drive Platform Performance & Reliability
• Ensure high availability and performance of data systems through optimization and operational excellence.
• Oversee pipeline reliability, database performance, and production readiness for mission-critical workloads.
• Lead Data Strategy & Integration
• Partner with business and IT stakeholders to align data architecture with organizational goals.
• Drive integration of data systems and ensure accessibility and usability of enterprise data.
• Advance Innovation & Technical Leadership
• Evaluate and adopt new tools, frameworks, and emerging technologies; mentor the team.
• Participate in a 24/7 on-call rotation to support analytics in production.

Skills

SQL

Python

Data Modeling

ETL/ELT

Data Warehousing

Cloud AWS

Mentoring

Communication

Education

Bachelor's degree in CS/Engineering

Master's degree preferred

Tools

dbt

Airflow

Dagster

Terraform

Redshift

PostgreSQL

Job description

ISO New England is seeking a Lead Data Engineer to design, build, and maintain enterprise data warehouses, data marts, and BI data systems that support strategic decisions. You will own data architecture, ensure reliability, and mentor the data engineering team.

The role includes a 24/7 on-call rotation, a hybrid work model (3 days onsite), and a competitive compensation package with bonus and comprehensive benefits.