Senior Data Engineer
About us
Every day we deliver safe and secure energy to homes, communities, and businesses. We are there when people need us the most. We connect people to the energy they need for the lives they live. The pace of change in society and our industry is accelerating and our expertise and track record puts us in an unparalleled position to shape the sustainable future of our industry.
About the Role
We are seeking a Senior Data Engineer to join National Grid’s Finance data and reporting office team (FDRO). The FDRO is responsible for financial data and financial reporting across the breath of National Grid Finance. Day to day you will lead all aspects of the design, development, and delivery of database, business intelligence, data warehouse, and data integration solutions.
What You'll Do
A Senior data engineer will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our data warehouse. The ideal candidate should have hands-on experience with ETL tools, strong data analysis skills, and the ability to work with large datasets.
· Lead the design, development, and maintenance of large-scale data systems, including data warehouses, data lakes, and data pipelines.
· Design, develop, and maintain ETL processes using tools like Matillion.
· Design, Develop and maintain optimal data flows in tools like Matillion.
· Develop and Maintain Datawarehouse objects like tables, views and security roles in snowflake database.
· Extract data from various sources, such as databases, flat files, and APIs
· Transform and cleanse data to ensure data quality and integrity
· Load data into the data warehouse, ensuring data consistency and accuracy
· Optimize ETL processes for performance, scalability, and reliability
· Work closely with data architects, analysts, and developers to support data integration initiatives.
· Implement data validation, data quality checks, and data security measures
· Troubleshoot and resolve data issues, performance bottlenecks, and ETL failures.
· Implement best practices for data warehousing, data modeling, and ETL development.
· Document ETL processes, data mappings, and configurations.
What You'll Need
· A minimum of 6 years of experience with relational databases, ETL, and data warehouse required.
· Expert level knowledge of industry leading ETL/ELT tools such as ODI, Informatica, Matillion or SSIS.
· Experience in designing and developing complex near real-time and/or batch data integration solutions using cloud based ETL and integration tools
· Experience with traditional and non-traditional forms of analytical data design (Kimbal, Inmon etc)
· Proficiency in SQL programming and relational database concepts.
· Experience with loading and maintaining a data warehouse.
· Bachelor’s degree in Computer Science or a related field with 6 years of related experience, or Master’s degree in Computer Science or a related field with at least 4 years of related experience required.
·
Nice to Have
· Experience with cloud-based data platforms, such as Snowflake.
· Domain knowledge in the area of finance data is preferred.
· Experience with SAP Systems and Databases
· Knowledge of data visualization tools, such as PowerBI or Tableau.
More Information
#:I-NK1 #LI-ETL #LI-SQL #LI-WALTHAM #LI-HYBRID
Salary
$133,000-$156,000
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.
Nearest Major Market: Waltham
Nearest Secondary Market: Boston