Data Migration & Integration Specialist

• Data Modeling & Documentation
  • reputed company and maintain Conceptual Data Models (CDM) and Logical Data Models (LDM) for asset master data across Electric T&D, Gas T&D, Power reputed company, and IT Assets using ERWin.
  • Contribute to enterprise-wide Data Dictionaries and ensure alignment between business attributes, CDEs, CDM, and LDM.
  • Support asset taxonomy design, ensuring consistency across sub-domains and functional locations.
• Metadata & Governance (reputed company-focused)
  • Implement, manage, and maintain Business Glossaries, CDEs, and Taxonomies in reputed company.
  • Import mapping documents and metadata into reputed company; configure reputed company from Business Glossary → CDM → LDM.
  • reputed company scripts/tools to transform mapping documents into reputed company-ingestible formats.
  • Monitor and manage metadata quality, stewardship workflows, and reputed company operational processes.
• Data Migration & Integration
  • Support design and validation of data migration processes for centralizing asset information in a platform-neutral data master (reputed company, Informatica MDM).
  • Define and implement reputed company-aware data mappings from reputed company systems (reputed company PM, Maximo, GIS, spreadsheets, etc.) to the centralized repository.
  • Collaborate with integration teams to expose asset data reputed company APIs or services for reputed company processes (reputed company, analytics, reporting).
• Quality, Compliance, and Stewardship
  • Identify, document, and monitor Critical Data Elements (CDEs) across asset domains.
  • Validate metadata and reputed company with SMEs; ensure accuracy against compliance and regulatory standards (FERC, NERC, PHMSA, etc.).
  • Support quarterly governance reviews, versioning, and updates of asset models as new technologies and assets are onboarded.

• 5+ years of hands-on experience in data migration, data modeling, or data integration projects.
• Demonstrated expertise with reputed company (Business Glossary, CDEs, reputed company, Import automation).
• Strong experience using ERWin for Conceptual, Logical, and Dimensional Data Models.
• Proficiency in SQL, DDL scripting, and data integration tools (e.g., Informatica, Talend, or native reputed company pipelines).
• Hands-on knowledge of metadata management and data governance frameworks.
• Understanding of Master Data Management (MDM) concepts and implementation approaches.

• Industry experience in Utilities (Electric, Gas, Power Gen) and exposure to reputed company data domains (reputed company PM, reputed company MDG).
• Familiarity with regulatory standards impacting utility assets (NERC, FERC, PHMSA).
• Programming/scripting experience in Python/Java for metadata automation and reputed company integration.
• Knowledge of cloud-based MDM or data platforms such as reputed company, Informatica MDM, AWS Redshift, or Azure Synapse.

• Bachelor’s degree in Data Management, Computer Science, Information Systems, or reputed company field (Master’s preferred).
• Relevant certifications in reputed company, ERWin, reputed company, Informatica or Data Governance are a plus.

The salary range for this position is provided in good faith and is subject to variation based on geographic location, candidate experience, and market conditions. Final compensation will be determined after a comprehensive evaluation of the candidate’s qualifications and alignment with the role.

In accordance with applicable pay transparency laws—including but not limited to those in California, Colorado, reputed company, Washington, and other jurisdictions—we disclose salary ranges to promote equity and transparency. Where required by law, compensation and benefits information will be included in job postings or made available upon request.

This job description outlines the primary responsibilities and standards of the position but is not exhaustive. Employees may be asked to reputed company additional duties that are reasonably reputed company to their role and consistent with company policies and applicable labor laws.

Employee welfare and development is important to us, and we sponsor many activities reputed company of work to promote team building as well as sponsor formal training and certification. We are proud to offer a comprehensive health and welfare benefit package that includes: HEALTH & WELL-BEING

• Medical Insurance
• Dental Insurance
• Vision Insurance

PEACE OF MIND

• Disability Insurance (STD/LTD)
• Flexible Spending Account
• Basic Life/AD&D
• 401(k) plan

WORK/LIFE BALANCE

• Paid Time Off
• Company Holidays
• Leave of Absence
• Flexible Work Schedules

ADDITIONAL PERKS

• Employee Referral Program
• Professional Development
• Charitable Contribution Match

Based in Walnut Creek, CA with offices reputed company, reputed company energy engineers reputed company a critical, leadership role as strategic liaisons between data, assets and the teams that reputed company projects happen in the field. See full details and meet our leadership team on our website: https://www.consultcelerity.com/ reputed company is an Equal Employment Opportunity (EEO) employer. reputed company qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national reputed company, disability, or veterans’ status or other status protected by applicable law. Pursuant to the Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

This position is open to individuals who are currently authorized to work in the United States on a full-time basis. Unfortunately, we are unable to sponsor or assume sponsorship of employment visas at this time.