About us National Grid is hiring a Lead Data Engineer / Data Integration Lead for our AMI Process & Performance department in any of our National Grid US locations in Upstate NY, or MA. Every day we deliver safe and secure energy to homes, communities, and businesses. We connect people to the energy they need for the lives they live. 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. Job Purpose We're hiring a Lead Data Engineer / Data Integration Lead to own and evolve the AMI Operations Center data backbone. This is a hands-on senior IC role focused on building reliable, scalable data pipelines and curated data models in Snowflake and the AMI data ecosystem (Azure + integration platforms) that power downstream analytics, operational dashboards, and automation. You will operate with high autonomyframing ambiguous problems, clarifying requirements with stakeholders, proposing solution options and tradeoffs, and delivering production-ready data products end to end (ingestion modeling quality monitoring consumption). You will design and implement ELT/ETL patterns, enforce data quality and governance controls, and partner with IT/operations teams to productionize and continuously improve data products.Key Accountabilities Design, build, and support production-grade data pipelines (batch and near real-time where applicable) to ingest AMI meter, network, and operational data into Snowflake and related data stores. star/snowflake schemas) and semantic-ready datasets to enable consistent reporting and self-service analytics without ad hoc Excel workarounds. Implement robust ELT/ETL patterns (SQL + Python) including incremental loads/CDC strategies, idempotent processing, and backfill/replay mechanisms. Build and optimize Snowflake objects and workloads (schemas, roles, warehouses, clustering/partitioning strategies, query tuning) with a focus on performance, cost, and reliability. Orchestrate and schedule pipelines using National Grid/AMI tooling (e.g., Matillion) and integration platforms/services (e.g., GoAnywhere MFT, MuleSoft, and Azure services such as Blob Storage, Logic Apps, Service Bus/Event Hub, and API Management), establishing standards for deployment, retries, alerting, and operational runbooks. Implement automated data quality controls (tests, validation rules, anomaly checks) and ensure data observability/monitoring for freshness, completeness, and SLA adherence. Partner with BI/reporting teams (e.g., Power BI) by delivering governed, well-documented datasets and semantic-friendly modelsprioritizing reusable data products over one-off reports. collaborate with Data Engineering and IT teams to align standards for security, access controls, lineage, and lifecycle management. Drive a data product mindset: proactively identify high-value AMI operational problems, translate them into clear data requirements, define success metrics/SLAs, and deliver reusable datasets that reduce manual effort and improve operational decision-making. Leverage automation (scripting, workflow tools, and approved AI assistants where appropriate) to reduce manual operational effort and improve mean-time-to-detect/resolve data issues. Qualifications Required qualifications 8+ years of hands-on data engineering experience delivering production pipelines and curated datasets (not primarily ad hoc reporting). Expert SQL skills including complex joins, window functions, performance tuning, and data profiling/validation. Strong Snowflake experience: data loading patterns, warehouse sizing/cost awareness, security (roles/grants), and performance concepts; solid grounding in relational database fundamentals. Proficiency with Python (or similar) for data engineering (APIs, file handling, transformations), and comfort working in Linux/CLI environments. Experience building and operating pipelines using modern ELT/ETL and integration tooling in the AMI ecosystem (e.g., Matillion, GoAnywhere MFT, MuleSoft, and/or Azure data/integration services). Experience designing analytical data models and enforcing data quality (tests/validation, reconciliation, documentation) for operationally critical datasets. Working knowledge of software engineering practices: version control (Git), code reviews, environment promotion, and supporting data products in production. Preferred qualifications Experience with data governance practices (metadata, lineage, access controls) and partnering with product/business stakeholders to define data products and SLAs. Hands-on experience designing/implementing integrations using MuleSoft and/or managed file transfer patterns (e.g., More Information #LI-ES1Salary Upstate NY: $126,000 - $148,000 a year Massachusetts: $142,000 - $166,000 a year 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. 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. National Grid complies with all applicable federal, state, and local anti-discrimination laws.