Senior Data Engineer
Waltham, MA, US, 02451
Full Time Senior-level / Expert USD 124K - 156K
National Grid
We are one of the world’s largest investor-owned energy companies, committed to delivering electricity and gas safely, reliably and efficiently to the customers and communities we serve.About us
National Grid is hiring a Senior Data Engineer for our Finance Data and Reporting Office team (FDRO) based in Waltham, MA or Brooklyn, NY.
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.
To be successful we must anticipate the needs of our customers, reducing the cost of energy delivery today and pioneering the flexible energy systems of tomorrow. This requires us to deliver on our promises and always look for new opportunities to grow, both ourselves and our business.
Job Purpose
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.
Key Accountabilities
The 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.
- Design, develop, and maintain ETL processes using 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.
Qualifications
Requirements:
• A minimum of 3+ years work experience with relational databases, ETL, and data warehouse.
• Expert level knowledge of industry leading ETL/ELT tools such as 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.
• Ability to work with different functional groups and levels of employees to effectively and professionally achieve results.
• 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 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
Salary
$124k - $146k a year in Waltham, MA.
$133k - $156k a year in Brooklyn, NY.
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 an equal opportunity employer that values a broad diversity of talent, knowledge, experience and expertise. We foster a culture of inclusion that drives employee engagement to deliver superior performance to the communities we serve. National Grid is proud to be an affirmative action employer. We encourage minorities, women, individuals with disabilities and protected veterans to join the National Grid team.
Tags: APIs Business Intelligence Computer Science Data analysis Data quality Data visualization Data warehouse Data Warehousing ELT ETL Finance Informatica Matillion Power BI RDBMS Security Snowflake SQL SSIS Tableau
Perks/benefits: Career development
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs