Title: Data Migration & Integration Specialist
Employment Type: Contract-to-Perm (full-time – benefits eligible) opportunity. This role offers the potential to transition into a permanent position based on performance and business needs. Initial contract duration is approximately 6 months.
Location: Remote (US based)
Position Summary
We are seeking a Data Migration & Integration Specialist with proven hands-on experience in Collibra, ERWin, and enterprise data modeling to support the creation of a centralized Enterprise Asset Master Data Model. This role is critical for establishing a single, system-agnostic source of truth for asset information, covering all classifications, families, and hierarchies.
The specialist will design, document, and implement high-quality data migration, integration, and lineage processes across systems such as Snowflake and Informatica MDM, ensuring consistency, neutrality, and adaptability. The individual will be instrumental in defining business glossaries, taxonomies, conceptual/logical data models, and lineage in Collibra to enable trusted enterprise-wide use of asset information.
Key Responsibilities
Employment Type: Contract-to-Perm (full-time – benefits eligible) opportunity. This role offers the potential to transition into a permanent position based on performance and business needs. Initial contract duration is approximately 6 months.
Location: Remote (US based)
Position Summary
We are seeking a Data Migration & Integration Specialist with proven hands-on experience in Collibra, ERWin, and enterprise data modeling to support the creation of a centralized Enterprise Asset Master Data Model. This role is critical for establishing a single, system-agnostic source of truth for asset information, covering all classifications, families, and hierarchies.
The specialist will design, document, and implement high-quality data migration, integration, and lineage processes across systems such as Snowflake and Informatica MDM, ensuring consistency, neutrality, and adaptability. The individual will be instrumental in defining business glossaries, taxonomies, conceptual/logical data models, and lineage in Collibra to enable trusted enterprise-wide use of asset information.
Key Responsibilities
- Data Modeling & Documentation
- Develop and maintain Conceptual Data Models (CDM) and Logical Data Models (LDM) for asset master data across Electric T&D, Gas T&D, Power Generation, 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 (Collibra-focused)
- Implement, manage, and maintain Business Glossaries, CDEs, and Taxonomies in Collibra.
- Import mapping documents and metadata into Collibra; configure lineage from Business Glossary → CDM → LDM.
- Develop scripts/tools to transform mapping documents into Collibra-ingestible formats.
- Monitor and manage metadata quality, stewardship workflows, and Collibra operational processes.
- Data Migration & Integration
- Support design and validation of data migration processes for centralizing asset information in a platform-neutral data master (Snowflake, Informatica MDM).
- Define and implement lineage-aware data mappings from source systems (SAP PM, Maximo, GIS, spreadsheets, etc.) to the centralized repository.
- Collaborate with integration teams to expose asset data via APIs or services for downstream processes (SAP, analytics, reporting).
- Quality, Compliance, and Stewardship
- Identify, document, and monitor Critical Data Elements (CDEs) across asset domains.
- Validate metadata and lineage 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.
Qualifications & Skills
Must Have:
- 5+ years of hands-on experience in data migration, data modeling, or data integration projects.
- Demonstrated expertise with Collibra (Business Glossary, CDEs, Lineage, 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 Snowflake 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 SAP data domains (SAP PM, SAP MDG).
- Familiarity with regulatory standards impacting utility assets (NERC, FERC, PHMSA).
- Programming/scripting experience in Python/Java for metadata automation and Collibra integration.
- Knowledge of cloud-based MDM or data platforms such as Snowflake, Informatica MDM, AWS Redshift, or Azure Synapse.
- Bachelor’s degree in Data Management, Computer Science, Information Systems, or related field (Master’s preferred).
- Relevant certifications in Collibra, ERWin, Snowflake, 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, New York, 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 perform additional duties that are reasonably related 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 outside 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
- Health Savings 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 nationwide, Celerity energy engineers perform a critical, leadership role as strategic liaisons between data, assets and the teams that make projects happen in the field.
See full details and meet our leadership team on our website: https://www.consultcelerity.com/
Celerity is an Equal Employment Opportunity (EEO) employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, 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.
Experience Requirements
Experienced
Apply Now