Principal Data Architect

About us

At National Grid, we keep people connected and society moving. But it’s so much more than that. National Grid supplies us with the environment to make it happen. As we generate momentum in the energy transition for all, we don’t plan on leaving any of our customers in the dark. So, join us as a Principal Data Architect, and find your superpower. We need you!

We want to find an innovative, adaptable, and results-oriented Principal Data Architect for our Chied Data Office function. This position is located in Waltham, MA (candidates may also reside in either Massachusets, Connecticut, New Jersey, New Hampshire, Pennsylvania, Rhode Island, Vermont, or Maine). If you yearn to be innovative, contribute new ideas, and play a critical part in our Data Architecture department, we want to hear from you!

Job Purpose

As a Principal Data Architect, you'll play a pivotal role in operationalizing the most-urgent data and analytics initiatives for National Grid digital business initiatives. The bulk of the activities would be in supporting and optimizing data pipelines, managing large finance transformation programs, and supporting the customer initiatives. This role presents an opportunity for someone with a passion for data architecture to work within our data interoperability team. It has several facets …

• Planning, designing, developing, and maintaining the data architecture and standards for various Data Integration projects. 
• Ensure new features and subject areas are modelled to integrate with existing structures. 
• Develop and maintain documentation of the data integration patterns, data flows, data standards, data architecture. 
• Provide direction on adoption of modern cloud technologies (i.e., Snowflake) and adopt industry best practices.
• Play key role in selecting enterprise data tools.
• Keen eye to deliver project deliverables that are concerned with architecture, security, and integration features.

What you'll do

• Review the architectural/ technological solutions for ongoing projects and ensure the right choice of solution.
• Work closely with IT Domain and Business units to capture requirements, identify pain areas, and propose an ideal solution.
• Design, implement, and document data architecture, which includes the use of relational, dimensional, and NoSQL databases. 
• Guarantee compliance with data governance and data security requirements while creating, improving, and operationalizing these integrated data approaches. 
• Liaise with stakeholders in building trust in the data being used for decision making. 
• Prepare architectural standards, guardrails, and best practices related to Data Integration / architecture.
• Consult about current / future industry trends and technology needs.

About you

• Bachelor's or master's degree in computer science, statistics, applied mathematics, data management, information systems, information science or a related quantitative field
• Experience with end-to-end implementation of Cloud data technologies (i.e., Snowflake).
• Expertise in data modelling, ELT and implementing complex stored Procedures.
• Expertise in various Snowflake technologies like Snowpark, SnowPipe, SnowPipe Stream, Dynamic Tables, Document AI, Cortex Analytics, Unistore etc.
• Expertise in Snowflake cost and query optimization including experience with CapitalOne Slingshot.
• Expertise in advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understanding of how to use these features.
• Experience in Data Migration from RDBMS, SAP systems, Salesforce, GIS, PI Historian to Snowflake.
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling and third normal form).
• Experience with data security and data access controls and design.
• Deep understanding of SoX, GDPR and Regulatory/CNI control environments.
• In-depth experience in providing resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.

More Information

Are you the right fit for this exciting role? You want to learn more about the position and National Grid's ambitious Digital Transformation? Then let's chat!

Rewarding work and a collaborative, team-oriented culture are just the beginning.  Review our digital benefit guide at negbenefitslivebrighter.com for full details and descriptions. 

Our organization follows a hybrid work structure in our service territory (NY & MA and adjacent states) where employees can work remotely or from the office, as needed.  Working from the office is encouraged when working on tasks that require a high degree of collaboration.  We work with our employees to foster a flexible work schedule.

#LI-CL1 #LI-HYBRID

Salary

$162,000 - $191,000 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. 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.