Data Meaning

Data Vault Architect – Data Platform Migration Lead

Data Meaning

contract

Posted on:

Location Type: Remote

Location: Remote • 💃 Anywhere in Latin America

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

CloudETLInformaticaSQLTableauVault

About the role

  • Lead the Informatica Retirement Initiative.
  • Own the migration plan from Informatica Cloud to a modern landing/replication solution.
  • Reverse-engineer existing Informatica mappings and translate them into Snowflake SQL, dbt, or Erwin Data Vault structures.
  • Redesign ingestion patterns to support a scalable, ELT-driven architecture.
  • Architect & Govern Data Vault 2.0 Implementation.
  • Lead the design of Raw Vault and Business Vault layers using Erwin DI or dbt.
  • Ensure consistent adoption of DV2.0 principles across team.
  • Oversee Dimensional Model Rebuild.
  • Align Business Vault outputs with downstream dimensional models and BI requirements.
  • Lead evaluations of ingestion/replication tools, semantic layers, and BI platforms.
  • Conduct pricing, roadmap, and capability discussions with vendors.
  • Guide tool selection decisions aligned with strategic architecture goals.
  • Direct sample dashboard migrations from MicroStrategy to Tableau or Power BI.
  • Build cost and effort estimation models to support planning and budgeting.
  • Align architectural decisions, timelines, and delivery expectations across distributed teams.
  • Provide executive-level communication and ensure clear visibility into program progress.

Requirements

  • Expert-level Data Vault 2.0 (DV2) with hands-on hub/link/satellite modeling.
  • Strong Snowflake engineering and architecture background.
  • Demonstrated experience modernizing ETL → ELT pipelines.
  • Proven ability to reverse-engineer Informatica Cloud mappings.
  • Experience with ingestion/replication tools such as Fivetran, CData, Precog, etc.
  • Erwin Data Modeler + Erwin DI automation experience.
  • Exposure to dbt modeling (nice-to-have).
  • Experience with semantic layers and BI tools: Tableau, Power BI, AtScale, Kyvos, Snowflake Semantic Views.
  • 10+ years in data architecture, engineering, or enterprise data platforms.
  • Experience with BI migrations, especially MicroStrategy → Tableau/Power BI.
  • Comfort working in cross-organizational architecture governance environments.
  • Experience leading technology evaluations, vendor negotiations, and platform strategy.
  • Strong delivery ownership and roadmap/program management skills.
  • Ability to coordinate cross-functional and distributed teams.
  • Executive-level communication and stakeholder engagement skills.
Benefits
  • Health insurance
  • Professional development
  • Flexible work arrangements

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Data Vault 2.0Snowflake SQLdbtErwin Data VaultETLELTInformatica CloudDimensional ModelingBI migrationshub/link/satellite modeling
Soft skills
delivery ownershipprogram managementexecutive-level communicationstakeholder engagementcross-functional coordinationleadershipstrategic architecture alignmentvendor negotiationteam governancevisibility into program progress