Every day, we deliver safe and secure energy to homes, communities, and businesses, connecting people to the energy they need for their lives. Our expertise and track record position us uniquely to shape the sustainable future of our industry as the pace of change accelerates. To succeed, we must anticipate customer needs, reduce energy delivery costs, and pioneer flexible energy systems. This requires delivering on our promises and seeking opportunities for growth.
Our work is critical, as National Grid powers millions of homes and businesses in the UK and US, and the technology we employ is vital to this task. The successful applicant for this position will play a crucial role in our mission, supported by our multicultural, customer-centric global team, with opportunities for professional development.
National Grid is hiring a Principal Data Engineer. This hybrid position can be located in Waltham, MA or our Brooklyn, NY offices.
Job PurposeWe are seeking a Principal 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. The successful candidate should have a strong background in data engineering, architecture, and leadership. They will be responsible for driving the data strategy, guiding a team of data engineers, and ensuring the scalability, security, and performance of our data systems.
Key AccountabilitiesA Principal data engineer will be responsible for driving data integration strategy ensuring the scalability, security, and performance of our data systems and ETL processes to extract, transform, and load data from various sources into our data warehouse.
• Set Architectural, Design and development standards for Data Integrations.
• Review design and code to ensure standards are maintained.
• Lead a team of data engineers, providing technical guidance, mentorship, and coaching.
• 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.
• A minimum of 8 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 eight years of related experience, or master’s degree in computer science or a related field with at least 6 years of related experience required.
• Ability to work with different functional groups and levels of employees to achieve results effectively and professionally.
• Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced environment.
Nice to Have
• Experience with cloud-based data platforms, such as Snowflake.
• Domain knowledge in finance data is preferred.
• Experience with SAP Systems and Databases
• Knowledge of data visualization tools, such as Power BI or Tableau.
Rewarding work and a collaborative, team-oriented culture are just the beginning. Review our digital benefit guide at ngbenefitslivebrighter.com for full details and descriptions.
#LI-RK1 #LI-HYBRID
Salary
Waltham:$156k - $183k a year
Brooklyn: $167k - 196k a year
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. Internal candidates will be assessed and provided offers against the minimum qualifications of this role and their individual experience.