Data Modeler

Title: Data modeler
Location: Remote
Duration: 6 months (Possible Extension Or Conversion)
Pay Range: $45/hr - $65/hr

The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time , paid sick and safe time , hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable)

Job Description

• Client is seeking a Data Modeler who is motivated by variety, is seeking a challenging environment for professional growth, and is interested in running large information technology projects in various customer businesses areas.


• Looking for Data Modeler/Architect from Electrical Transimission/Utilities Companies Background


• We are seeking an experienced Data Modeler who plays a critical role in establishing and sustaining a trusted, interoperable data foundation across the utility enterprise.


• Data Modeler also plays a key role in supporting data governance, acting as a steward of semantic integrity, definitions, and modeling best practices.

Location: This position is remote. Client is located in the Seattle area. Must be willing to work in the PST hours.

Responsibilities:

• Develop and maintain CIM-based logical and physical data models aligned to IEC standards (61970, 61968, 62325).
  Create and manage CIM Profiles (UML, RDF/XML, JSON-LD) tailored to utility use cases.


• Interpret and apply CIM extensions for utility-specific requirements (distribution, transmission, DER, markets).
  Ensure semantic consistency across systems using CIM as the canonical data model.


• Support system-to-system integration designs


• Map source-system schemas to CIM classes, attributes, and relationships.


• Enable analytics and AI use cases by aligning operational and business data into analytics-ready models.


• Support data-lake and lakehouse architectures with curated CIM-based data structures.


• Maintain business and technical metadata, definitions, and relationships within a data catalog.


• Define and enforce data standards, naming conventions, and modeling best practices.


• Participate in data governance activities including stewardship reviews and change control.


• Assist with data-quality rule definition and semantic validation.


• Review backlog items and modeling requests supporting data lake ingestion and integration


• Collaborate with data engineers and system SMEs to understand source-system data


• Map source-system data to CIM classes, attributes, and relationships


• Define and maintain CIM profiles used by the data lake


• Validate transformation logic against CIM semantic intent


• Support architecture and integration design discussions


• Ensure curated data models are analytics-ready and consistent


• Define and maintain business definitions and technical metadata


• Identify and resolve semantic or data-quality issues


• Document modeling decisions and participate in governance reviews

Required Education & Experience:

• Bachelor s degree in Computer Science, Information Systems, Engineering, or related field.


• 10+ years Hands-on experience with IEC CIM (61970, 61968, and/or 62325).


• Strong understanding of electric utility operations


• Experience with logical and physical data modeling techniques.


• Familiarity with UML, relational modeling, and semantic modeling concepts.


• Experience mapping operational systems (WAMS, WACS, MSCS)


• Experience supporting utility data lakes or analytics platforms (AWS, Databricks).


• Knowledge of RDF, OWL, semantic graphs, or knowledge graphs.


• Familiarity with ESRI Utility Network, Oracle Utilities, or similar utility platforms.


• Experience with metadata management and data catalog tools.


• Understanding of utility regulatory and compliance requirements.


• Excellent communication skills