Looking for "Physical Data Modeler" at Boston, MA (Fully Onsite) - CG

Role: Data Modeler

Locations: Boston, MA (Fully Onsite)

Duration: 12 Months Contract

Note: Candidate needs to be in the office 5 Days every week. Local or candidates from Nearby states only.

Job Purpose:

Senior Physical Data Modeler role will be part of the Chief Data Office function.

It is a critical role to deliver on vision

To be at the heart of a clean, fair and affordable energy future.

She / he will 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.

She / he will play a pivotal role in operationalizing the most-urgent data and analytics initiatives for digital business initiatives.

This role presents an opportunity for someone with a passion for data modelling to work within our data interoperability team.

It has several facets:

Business coordination & data analysis to gain the necessary level of understanding for the data definition and usage

Production of the physical data models working with Logical Data Modelers, Business SME s, Data Architects, Business Systems Analysts, Data Engineers, and others

Physical implementation of critical data use cases

Key Accountabilities:

Design, implement, and document physical data modeling solutions, which include the use of relational, NoSQL, and dimensional databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

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.

Work with Platform engineering teams to drive automation by guiding them through data modeling activities.

Provide oversight and advice to other data modelers who are undertaking the design of data models and support the management of data dictionaries and ontologies.

Participate in the evaluation of data models and databases for variances and discrepancies to ensure

data is represented correctly.

Familiarity with industry standard models, preferably for the utility industry, is a plus.

Experience Required

Strong experience building, managing and working with cross-functional teams in a dynamic business environment.

Expected to be highly creative and collaborative. The successful candidate will also be required to have regular discussions with data consumers on optimally refining the data models developed in non-production environments and deploying them in production.

Required to have the accessibility and ability to interface with, and gain the respect of, stakeholders at all levels and roles within the company.

Is a confident, curious, energetic self-starter and self-motivated with strong interpersonal skills. Able to work independently with minimal supervision.

Has good judgment, a sense of urgency and has demonstrated commitment to high standards of ethics, regulatory compliance, customer service and business integrity.

Technical Skills:

Extensive knowledge and experience with conceptual, logical, and physical data models. Deep knowledge of 3NF and creating data models using relational and dimensional design.

Experience and knowledge of Snowflake databases.

Knowledge of working with the integration of large Heterogeneous datasets.

ETL/ELT

Data replication/CDC

Message-oriented data movement

API design and access

Data virtualization

Streaming data

Knowledge of data life cycle and data development process.

Strong experience:

Creation of complex conceptual, logical and physical data models using 3NF, NoSQL, and dimensional design.

Hands on experience with Data modelling tools such as ER / Studio, Erwin, Power Designer etc is a MUST.

Evaluating implemented data systems for variances, discrepancies, and efficiency.

Troubleshooting and optimizing data systems.

Experience in Database capabilities such as ..

[SQL, PL/SQL, others] for relational databases

Snowflake databases.

Analytics, and BI software tools like [Tableau, Qlik, PowerBI and others] for semantic-layer-based data discovery.

Working with the business and analytics teams to gather implementation requirements for the data model and database design. Working with data requirements documents to implement the data model.

Metrics for Evaluation

On-time and on-scope delivery of data models in alignment with the business and/or data and analytics and/or data science / engineering team(s).

Ability work effectively and closely with business in creating and delivering data models as part of a data strategy.

Ability to network and be recognized as a data expert across a variety of business and IT roles.

Education and Training:

A bachelor's or master's degree in computer science, statistics, applied mathematics, data management, information systems, information science or a related quantitative field is required.

The ideal candidate will have a combination of IT skills, data governance skills, analytics

Previous Experience:

At least TEN years or more of work experience in physical data modeling disciplines including data integration, model optimization, and/or other areas directly relevant to data modelling responsibilities and tasks.

Ideally FIVE 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.

Ideally TWO years of experience working with Snowflake in creating and implementing physical database designs.