Lead Data Engineer Job at National Grid, Waltham, MA

  • National Grid
  • Waltham, MA

Job Description

About usNational 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 PurposeThe 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 AccountabilitiesPerform and collaborate on system designs, data solution development including data migration and extracts from multiple legacy systemsProvide day-to-day supervision and leadership of engineering team(s) responsible for implementation.Updates to data mappings and data catalogsParticipate in, and/or lead, design and pre-deployment reviews.Data profilingDesign and development of data synchronization processesParticipate in the design/development of SaaS solutions, including data modelingAssist in determining the cross-application data standards, data distribution standards and promote data-driven designCreate database deliverables ensuring quality and traceability to requirements and adherence to all quality management plans and governance standardsWork 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 projectParticipate in go-live preparation activities such as QA, dress rehearsals, issue remediation, cutover and go-live aftercareParticipate in data management maturity assessments to identify gaps and pain points for capabilities including data quality, governance, analytics, metadata management, master data managementSeek opportunities for continuous improvement in processes, procedures and systems with regards to dataQualifications7+ years’ experience in database development (Snowflake, SQLServer, Oracle, etc)Experience in data mapping, modeling and working with teams to define data modelsExperience in a dynamic work environmentProven ability to work well in a team environment, and be capable of building and maintaining positive relationships with other staff, departments, and customersStrong communicatorExperience with cloud data architecture (Azure)Experience with SnowflakeExperience with Matillion (or other ETL tools) is a plusExperience with real-time data loads is a plusExperience 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 plusExperience in with SaaS solutions such as Salesforce, ESRI and Workforce is a plusMore Information• This is a Band D position• Location: Waltham/Brooklyn(hybrid)• Manager: Alex James • Recruitment Business Partner: Rajbir Kaur SalaryWaltham: $142k - $166k a yearBrooklyn: $152k - $178k a yearNational 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.

Job Tags

Work at office, Local area

Similar Jobs

Apidel Technologies

Analyst-Program/Project 3 Job at Apidel Technologies

Job Description Job Description Education Requirement High School Diploma or Equivalent Day-to-Day Responsibilities/Workload Provide project management support for Transmission Project Management (TPM) project teams. Support 2 to 3 Project Managers simultaneously...

TMS International

Heavy Equipment Operator - Scrap Metal & Slag Yard Job at TMS International

A leading provider of industrial services is seeking a Heavy Equipment Operator in Mesa, AZ. In this role, you will operate and maintain heavy equipment for processing scrap metal while ensuring safety and efficiency. Ideal candidates have proven experience in similar... 

Heartland Dental

Dental Receptionist - Business Assistant Job at Heartland Dental

 ...Job Details Req ID: 123668 Supported Practice: Metro Dental Associates Category: Business Assistant Location: 900 52nd St SW, Wyoming, MI 49509 Years of Experience: No Experience Required (open to experience or new grad) Position Summary: Business... 

TransUnion

Business Development Executive, Financial Services Job at TransUnion

 ...Privacy NoticeTeam OverviewWe are seeking a Business Development Executive with exceptional sales and...  ...facing expertise for our Financial Services Sales Team. This is a remote position...  ...work-related events at the discretion of management.This is a remote position which may... 

AuraOne Human Data

Sports Video Failure Analyst Job at AuraOne Human Data

 ...Sports Video Failure Analyst is a remote evaluation track for reviewing sports video failure analyst evaluation prompts and responses against AuraOne's quality rubric. Reviewers compare paired outputs, label edge cases, and write the kind of structured feedback the modeling...