Lead Data Engineer

National Grid; New York (NY); Hybrid; USD 142,000 - 178,000; Full time

Job summary

National Grid is seeking a Lead Data Engineer to design scalable, reliable data solutions for a large enterprise and lead the engineering teams responsible for implementation. This hybrid role is based in our Waltham, MA, or Brooklyn, NY offices.

You will oversee data migrations, mappings, catalog updates, and the development of data models and SaaS integrations, driving data-driven design and governance across projects.

Qualifications

• 7+ years' experience in database development (Snowflake, SQLServer, Oracle, etc.)
• Experience in data mapping and data modeling with cross-team collaboration
• Proven ability to work in a dynamic, collaborative environment and strong communication

Responsibilities

• Perform and collaborate on system designs and data solution development including data migration and extracts from multiple legacy systems
• Provide day-to-day supervision and leadership of engineering team(s) responsible for implementation
• Update data mappings and data catalogs
• Participate in, and/or lead, design and pre-deployment reviews
• Data profiling and data synchronization design/development
• Assist in designing SaaS solutions and data modeling
• Promote data-driven design and governance across projects

Skills

Snowflake

SQL Server

Oracle

Azure

Matillion

Data Modeling

Data Warehousing

Agile/Lean

SaaS Integrations

Tools

Matillion

Job description

About us

National Grid is one of the largest investor-owned energy companies in the world, serving communities across Massachusetts, New York, Rhode Island, and the United Kingdom. We are focused on delivering clean, reliable, and affordable energy while supporting the transition to a more sustainable future.

This role operates under a hybrid working model and is based out of our Waltham, MA, or the Brooklyn, NY office. Hybrid work expectations are subject to business needs and company policy.

Job Purpose

The Lead Data Engineer is a collaborative, hands-on role within the Digital Platform Data Engineering team. This individual is responsible for designing scalable, reliable, and high-performing data solutions for a large-volume enterprise environment and leading the engineering teams responsible for implementation.

This role will support a major IT initiative focused on enabling National Grid business partners, improving how employees serve customers today, and building a data platform that supports future growth.

Key Accountabilities

• Perform and collaborate on system designs, data solution development including data migration and extracts from multiple legacy systems
• Provide day-to-day supervision and leadership of engineering team(s) responsible for implementation.
• Updates to data mappings and data catalogs
• Participate in, and/or lead, design and pre-deployment reviews.
• Data profiling
• Design and development of data synchronization processes
• Participate in the design/development of SaaS solutions, including data modeling
• Assist in determining the cross-application data standards, data distribution standards and promote data-driven design
• Create database deliverables ensuring quality and traceability to requirements and adherence to all quality management plans and governance standards
• Work with the team to ensure that all components work together to meet objectives and performance goals as defined in the requirements. Identify and communicate any cross-area or cross-release issues that may affect other areas of the project
• Participate in go-live preparation activities such as QA, dress rehearsals, issue remediation, cutover and go-live aftercare
• Participate in data management maturity assessments to identify gaps and pain points for capabilities including data quality, governance, analytics, metadata management, master data management
• Seek opportunities for continuous improvement in processes, procedures and systems with regards to data

Qualifications

• 7+ years' experience in database development (Snowflake, SQLServer, Oracle, etc)
• Experience in data mapping, modeling and working with teams to define data models
• Experience in a dynamic work environment
• Proven ability to work well in a team environment, and be capable of building and maintaining positive relationships with other staff, departments, and customers
• Strong communicator
• Experience with cloud data architecture (Azure)
• Experience with Snowflake
• Experience with Matillion (or other ETL tools) is a plus
• Experience with real-time data loads is a plus
• Experience with coding/design/implementation of large-scale data warehouse environments (Type 2 & Type 1 SCDs, Kimball design concepts, etc.)
• Experience with Agile/Lean software development process and practices is a plus
• Experience in with SaaS solutions such as Salesforce, ESRI and Workforce is a plus

More Information

* This is a Band D position
* Location: Waltham/Brooklyn(hybrid)
* Manager: Alex James
* Recruitment Business Partner: Rajbir Kaur

Salary

Waltham: $142k - $166k a year

Brooklyn: $152k - $178k a year

National Grid will not be providing visa sponsorship for this position now or in the future. You must have the ability to work without a need for current or future visa sponsorship.

National Grid utilizes an assessment that evaluates the job qualifications/characteristics using AI or statistically based scoring. For more information, please view NYC Local Law 144.

This position has a career path which provides for advancement opportunities within and across bands as you develop and evolve in the position; gaining experience, expertise and acquiring and applying technical skills. Candidates will be assessed and provided offers against the minimum qualifications of this role and their individual experience.

National Grid is committed to providing equal employment opportunities to all employees and applicants for employment regardless of protected class. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability, genetic information, or any other protected status in accordance with applicable federal, state, and local laws. National Grid maintains affirmative action programs for individuals with disabilities and protected veterans.

Our employment practices are designed to ensure that all individuals are treated fairly and with respect throughout the hiring process and during employment. National Grid complies with all applicable federal, state, and local anti-discrimination laws. We are dedicated to fostering a workplace that is free from unlawful discrimination and harassment, and we encourage a culture of respect for all.