Data Migration & Integration Specialist

Remote
Contracted to Full Time
Business Integration Services (BIS)
Experienced

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

  • 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.
Nice to Have:
  • 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.
Education
  • 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.
Pay: $48-$60/hour

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.

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*