Data Vault Architect - Data Platform Migration Lead

Data Meaning; Brasil; Híbrido; BRL 441.000 - 663.000; Tempo parcial

Resumo da oferta

A data solutions firm in Brazil is looking for a Data Platform Migration Lead to oversee the modernization of clients' data ecosystems. The role requires expert Data Vault 2.0 architecture knowledge, strong Snowflake engineering, and a proven track record in managing complex vendor relationships. Candidates must have 10+ years in data architecture and experience in BI migrations, specifically from MicroStrategy to Tableau or Power BI. Excellent communication and program management skills are essential for this position.

Qualificações

• Expert-level Data Vault 2.0 with hands-on hub/link/satellite modeling.
• Strong Snowflake engineering and architecture background.
• 10+ years in data architecture, engineering, or enterprise data platforms.

Responsabilidades

• Lead the end-to-end modernization of customer’s data ecosystem.
• Own the migration plan from Informatica Cloud to modern solutions.
• Coordinate architectural decisions and timelines across teams.

Conhecimentos

Data Vault 2.0 expertise

Snowflake engineering

Informatica Cloud reverse-engineering

BI tools: Tableau, Power BI

Cross-functional coordination

Ferramentas

Erwin Data Modeler

dbt

MicroStrategy

Descrição da oferta de emprego

Data Platform Migration Lead

Location: LatAm

Type of contract: Contractor, temporary – TBD

About Data Meaning

At Data Meaning, we help organizations turn data into actionable insights by delivering world‑class solutions in Business Intelligence, Data Governance, and Analytics. Our consultants work across industries and geographies, enabling businesses to achieve impactful results.

Role Overview

We are seeking a highly experienced Data Platform Migration Lead ("Quarterback") to drive the end‑to‑end modernization of our customer’s data ecosystem. This role blends expert‑level Data Vault 2.0 architecture, Snowflake engineering, legacy ETL retirement, BI migration strategy, and program leadership across multiple teams and vendors.

The ideal candidate brings deep technical mastery combined with the ability to guide strategic decisions, evaluate tools, manage complex roadmaps, and orchestrate a multi‑team delivery environment.

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.
• Define modeling standards, patterns, and automation practices.
• Ensure consistent adoption of DV2.0 principles across team.

Oversee Dimensional Model Rebuild

• Rebuild core subject areas including GL, AR/AP, PO, Expenses, Time, Commissions.
• Align Business Vault outputs with downstream dimensional models and BI requirements.

Vendor Management & Tool Evaluation

• 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.

BI Migration Strategy & Estimation

• Direct sample dashboard migrations from MicroStrategy to Tableau or Power BI.
• Build cost and effort estimation models to support planning and budgeting.

Cross‑Team Coordination & Program Leadership

• 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.