Senior Data Engineer

2 weeks ago


Brooklyn, New York, United States National Grid Full time
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.


  • Data Engineer

    2 weeks ago


    Brooklyn, New York, United States Altana AI Full time

    Altana provides the world's only dynamic, intelligent map of the global supply chain - the Altana Atlas - using AI and machine learning models to connect with and learn from massive sets of public and private data. Through the Atlas, companies and governments can understand the distant origins of products well beyond their own direct suppliers; discover...

  • Data Engineer

    2 weeks ago


    Brooklyn, New York, United States Altana AI Full time

    Altana provides the world's only dynamic, intelligent map of the global supply chain - the Altana Atlas - using AI and machine learning models to connect with and learn from massive sets of public and private data. Through the Atlas, companies and governments can understand the distant origins of products well beyond their own direct suppliers; discover...


  • Brooklyn, New York, United States Ekimetrics Full time

    Ekimetrics is a leader in data science and AI-powered solutions. For over 16 years, we've pioneered the use of AI and advanced data science applied to unified marketing measurement, holistic business optimization and broad-ranging sustainability goals.Our goal: combine high impact with long-term business purpose.Ekimetrics is one of the world's largest...


  • Brooklyn, New York, United States Ekimetrics Full time

    Ekimetrics is a leader in data science and AI-powered solutions. For over 16 years, we've pioneered the use of AI and advanced data science applied to unified marketing measurement, holistic business optimization and broad-ranging sustainability goals.Our goal: combine high impact with long-term business purpose.Ekimetrics is one of the world's largest...


  • Brooklyn, New York, United States Cofactr Full time

    Cofactr is on a mission to make hardware as agile and scalable as software. We're leveraging better data and AI to build best-in-class tools for electronics supply chain management. Cofactr is a single platform for procurement, purchase, and management of electronic components that works seamlessly with integrated logistics to assure that the physical...

  • Sr. Data Scientist

    2 weeks ago


    Brooklyn, New York, United States Philo Full time

    Philo: TV on the Internet (TVoIP)At Philo, we're a group of technology and product people who set out to build the future of television, marrying the best in modern technology with the most compelling medium ever invented — in short, we're building the TV experience that we've always wanted for ourselves. In practice this means leveraging cloud delivery,...

  • Lead Data Scientist

    3 weeks ago


    Brooklyn, New York, United States Philo Full time

    Philo: TV on the Internet (TVoIP)At Philo, we're a group of technology and product people who set out to build the future of television, marrying the best in modern technology with the most compelling medium ever invented — in short, we're building the TV experience that we've always wanted for ourselves. In practice this means leveraging cloud delivery,...

  • Sr. Data Scientist

    3 weeks ago


    Brooklyn, New York, United States Philo Full time

    Philo: TV on the Internet (TVoIP)At Philo, we're a group of technology and product people who set out to build the future of television, marrying the best in modern technology with the most compelling medium ever invented — in short, we're building the TV experience that we've always wanted for ourselves. In practice this means leveraging cloud delivery,...

  • Lead Data Scientist

    2 weeks ago


    Brooklyn, New York, United States Philo Full time

    Philo: TV on the Internet (TVoIP)At Philo, we're a group of technology and product people who set out to build the future of television, marrying the best in modern technology with the most compelling medium ever invented — in short, we're building the TV experience that we've always wanted for ourselves. In practice this means leveraging cloud delivery,...


  • Brooklyn, New York, United States Bechtel Full time

    Requisition ID: 275197 Relocation Authorized: National/International - Single Telework Type: Full-Time Office/Project Work Location: Various Bechtel Project Locations Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the resiliency of the...


  • Brooklyn, New York, United States Bechtel Full time

    Requisition ID: 275197 Relocation Authorized: National/International - Single Telework Type: Full-Time Office/Project Work Location: Various Bechtel Project Locations Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the resiliency of the...


  • Brooklyn, New York, United States Comcast Corporation Full time

    Effectv helps businesses reach the right audience with the right message at the right time.We harness the scale and quality of Comcast data to target advertisers' audiences across linear TV, streaming, and video on demand and enabling clients to evaluate performance.A division of Comcast, we have a presence in 60+ markets and an estimated reach of 96 million...


  • Brooklyn, New York, United States Comcast Corporation Full time

    Effectv helps businesses reach the right audience with the right message at the right time.We harness the scale and quality of Comcast data to target advertisers' audiences across linear TV, streaming, and video on demand and enabling clients to evaluate performance.A division of Comcast, we have a presence in 60+ markets and an estimated reach of 96 million...


  • Brooklyn, New York, United States Motion Recruitment Full time

    My client is looking for a Founding Full-Stack Engineer to join their team during an exciting period of growth for them. They are looking for someone who is interested in building from the ground up, and will joining the founding team to work on exciting/innovative projects in the AI/ML space. The team is based in Brooklyn and is looking for someone who is...


  • Brooklyn, New York, United States Sunrise Senior Living Full time

    OverviewThe LPN Medication Care Manager is responsible for providing the highest degree of quality care and services by administering medication and treatments in a safe organized manner. Responsibilities include but are not limited to administration of medications, documentation of medication administration, conducting SHUs, and providing resident care...


  • Brooklyn, New York, United States Sunrise Senior Living Full time

    OverviewThe LPN Medication Care Manager is responsible for providing the highest degree of quality care and services by administering medication and treatments in a safe organized manner. Responsibilities include but are not limited to administration of medications, documentation of medication administration, conducting SHUs, and providing resident care...


  • Brooklyn, New York, United States Bechtel Full time

    Requisition ID: 276649 Relocation Authorized: None Telework Type: Full-Time Telework Work Location: Various Bechtel Project Locations Extraordinary teams building inspiring projects:Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the...


  • Brooklyn, New York, United States Bechtel Full time

    Requisition ID: 276649 Relocation Authorized: None Telework Type: Full-Time Telework Work Location: Various Bechtel Project Locations Extraordinary teams building inspiring projects:Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the...


  • Brooklyn, New York, United States Bechtel Full time

    Requisition ID: 276651 Relocation Authorized: None Telework Type: Full-Time Telework Work Location: Various Bechtel Project Locations Extraordinary teams building inspiring projects:Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the...


  • Brooklyn, New York, United States Bechtel Full time

    Requisition ID: 276651 Relocation Authorized: None Telework Type: Full-Time Telework Work Location: Various Bechtel Project Locations Extraordinary teams building inspiring projects:Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the...