Data Modeler

About us

Job Purpose

 

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 Data Modeler, and find your superpower. We need you!

 

We want to find an innovative, adaptable, and results-oriented Data Modeler 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!

What you'll do

 

As a Data Modeler, you'll be part of the Chief Data Office function and report into our Global Data & Analytics Architecture Group. You'll be working as part of a multi-disciplinary team of data and analytics leaders, and fellow data experts to develop and manage data products that can empower our business to make decisions from data to drive growth activities and bring efficiencies to our data processes and data maturity.

You'll play an important role in operationalizing the most-urgent data and analytics initiatives for NationalGrid digital business initiatives. You'll design and build relational and analytical data models (conceptual, logical, physical) to fulfill the strategic data needs of the business. Key responsibilities include the following:

 

• Design data models for relational, NoSQL, and dimensional databases by working with Business Systems Analysts, Data Analysts, and Data Architects using business requirements documents as their guide. These designs support enterprise information management, business intelligence, machine learning, data science, and other business interests.
• Consult with multiple subject matter experts from as many departments and user bases as necessary, modeling business requirements with consistency and coordination.
• Help the business in identifying how data supports business processes and how to model those needs.  Liaise with stakeholders in building trust in the data being used for decision making.  Propose innovative data solutions that can help improve business activities.
• Work with the Domain teams as needed to create conceptual, logical, physical data models, support physical model implementation and DDL.  Synchronize data models and implemented databases to identify implementation completeness and identify any gaps.
• Collaborate with other data modelers who are undertaking the design of data models.
• Maintain data models to ensure they represent the current status of the applications or systems the model represent.  
• Ensure the consistency of the data models in following data modeling design standards, design data patterns, enterprise data standards, and data glossaries.  Evaluate data models and databases for variances and discrepancies to ensure data is represented correctly according to data standards.

What you'll need

 

• A bachelor's or master's degree in computer science, statistics, applied mathematics, data management, information systems, information science or a related quantitative field.
• 10+ years or more of work experience in data modeling disciplines including, model creation and optimization, and/or other areas directly relevant to data modeling responsibilities and tasks.
• 10+ years of experience working in cross-functional teams and collaborating with business stakeholders in utilities in support of a departmental and/or multi-departmental data management and analytics initiative.
• Strong experience with Data modeling tools such as – ER / Studio, Erwin, PowerDesigner etc.
• Experience with implementing and maintaining data models.
• Hands-on experience with third-party utility enterprise data models including electric utility business.
• Deep knowledge and experience with utility data models for the gas and electric utility business.
• Deep knowledge and experience with conceptual, logical, and physical data models.  Deep knowledge of 3NF and creating data models using relational design.  Knowledge of NoSQL database design and dimensional design.
• Experience and knowledge of Snowflake and other NoSQL databases is a plus.
• Experience in working with stakeholders who create business data requirements, and in using the requirements to drive the design of the data models.
• Experience with and knowledge of third-party utility enterprise data models including gas utility business.