Sr. Data Engineer c2c contract jobs Boston, MA

Job Title
: Sr. Data Engineer
Location
: Boston, MA (Hybrid)
Type
: 6+ months Contract
 

Job Description:
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 integrationn solutions.

Key Accountabilities:

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.