Data Vault Architect – Data Platform Migration Lead
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Platform Migration Lead overseeing data migration and modernization for clients in LatAm. Blending expertise in Data Vault and Snowflake engineering with program leadership.
Responsibilities:
- 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
Similar Jobs
Data Warehousing Architect
Data Warehousing Architect leading the data warehouse development and data flow execution for health and wellness company. Ensuring data structures support business initiatives across various domains.
Principal Architect – Cloud and Observability
Principal Architect managing observability and hybrid cloud at CVS Health. Leading architecture, standards, and technical direction across multi-cloud infrastructure.
Senior Principal Architect
Senior Principal Architect at Hewlett Packard Enterprise, focusing on AI solutions and networking. Collaborating with partners to optimize infrastructures and support AI Grid initiatives.
ITSM/ITIL Architect
ITSM/ITIL Architect at Miratech designing process architecture for large-scale network consolidation. Experienced professionals needed for enterprise IT service management in a hybrid work culture.
Solutions Delivery Architect
Solutions Delivery Architect at Iron Mountain serving as a design authority for customer solutions. Leading technical designs and ensuring integrity of implementations in digital transformation.
Snowflake Architect
Snowflake Architect designing and implementing enterprise data platforms at a global AI consulting firm. Lead data strategy and collaborate with engineering teams for analytics solutions.
Builder – Architect – Engineer Expert Consultant, Part-Time Contractor
Part-Time Consultant helping shape AI in the permitting process. Seeking experienced builders, developers, and architects to validate AI outputs in Florida, Texas, or California.
SOC Architect
SoC Architect leading design of next-generation AI-focused silicon for AI models. Collaborating with cross-functional teams and driving architectural specifications from definition to productization.
Mid-level Solutions Architect – Exclusive for Candidates with Disabilities (PwD)
Arquiteto(a) de Soluções Pleno analisando e implementando soluções de datacenter na Vivo. Planejando e gerenciando infraestruturas para equipamento na nuvem com equipe colaborativa.
Project Architect
Project Architect leading the development of construction documents for residential and light commercial projects. Requires proficiency in AutoCAD and Revit, focusing on precise detailing and consultant coordination.
Architectural Coordinator
Architectural Coordinator supporting the Architect of Record in overseeing compliance for commercial real estate projects. Collaborating with internal and external teams for successful permit submissions and documentation.
Architecture Tutor
Tutor Me Education seeking remote tutors with architecture expertise for flexible online instruction. Provide engaging lessons to students across the country on your schedule.
MuleSoft Architect
Senior MuleSoft Developer at Accellor designing and implementing integration solutions using MuleSoft. Collaborate with stakeholders to ensure high-quality APIs and governance of integration solutions.
Technical Solutions Architect
Cloud Solutions Architect translating business needs into scalable plans at a leading Canadian fintech company. Collaborating with cross-functional teams to enhance mortgage lending operations.
Cloud Architect
Cloud Architect evaluating and evolving cloud architecture and analytical infrastructure. Focusing on integration between on-premises and cloud environments while analyzing connectivity and performance.
Health Information Exchange Business Architect, Mid
Healthcare IT Business Architect analyzing and optimizing VHIE system architecture and data flows. Supporting the VA with data-driven recommendations for health information exchange.
Arquitecto/a de soluciones
Software Architect designing scalable solutions for digital transformation at Periferia IT Group. Working remotely, collaborating with teams across Latin America and the United States.
Specialist, Architect — Market Communication (Energy Industry)
Software Architect for market communication in energy sector. Develop innovative solutions and collaborate in a strong team environment.
Specialist, Architect Energy Data Management – Energy Sector
Spezialist / Architekt Energiedatenmanagement bei CEREBRICKS. Entwickeln innovativer Softwarelösungen für die Energiewirtschaft.
Consultant, Programme Architect
Consultant developing programmatic models for the World Code Against Cancer Framework. Enhancing cancer prevention strategies through innovative methodologies and stakeholder mobilization.