Client: National Grid
Position: Data Analyst/ Data Modeler
Location: Waltham, MA. Remote, but must report to Waltham, MA when needed. (No Relocation)
Visa: USC/GCH
Experience: 7 to 10 years
Positions: 2
People with recent gov/state work would be perfect.
It would be awesome if you have.
A combination of IT skills, data governance skills, and analytics.
Extensive 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 NoSQL databases, Snowflake is a plus.
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 with 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.
Reviewing modifications of existing data models and systems for cross-compatibility.
Implementing data strategies and data models.
Updating and optimizing data and metadata models.
Evaluating implemented data systems for variances, discrepancies, and efficiency.
Troubleshooting and optimizing data systems.
Experience with managing data modeling, architects, data analysts.
Experience in Database capabilities such as:
[SQL, PL/SQL, others] for relational databases
NoSQL oriented databases like MongoDB, Cassandra, others] for nonrelational NoSQL databases.
Analytics, and BI software tools like [Tableau, Qlik, PowerBI and others] for semantic-layer-based data discovery.