Description and Requirements
"At BMC trust is not just a word - it's a way of life"
Remote
Description and Requirements

BMC empowers nearly 80% of the Forbes Global 100 to accelerate business value, faster than humanly possible. Our industry-leading portfolio unlocks human and machine potential to drive business growth, innovation, and sustainable success. BMC does this in a simple and optimized way by connecting people, systems, and data that power the world’s largest organizations so they can seize a competitive advantage.

Title: Data Architect (Hands-On Builder)
Location: Mexico Remote

Data Architect will focus on the design, build, and evolve a modern, scalable data architecture that will power analytics, reporting, AI/ML use cases, and operational decision-making across the GTM business. This role will define data patterns and standards, partner with IT, and business partner teams to ensure our data platform is secure, reliable, cost-efficient, and easy to use.

This role is idóneo for someone with strong hands-on architecture depth and can define target-state architecture,



guide implementation, and ensure high-quality delivery across pipelines, integrations, and governance.

Key Responsibilities
- Build and Own Core Data Pipelines (Hands-On)
- Architect and implement end-to-end ingestion and transformation pipelines from source systems into Snowflake.
- Develop robust ELT/ETL workflows using dbt and orchestration tools (e.g., Airflow/Dagster/ADF), including:
- incremental loads, SCD handling, backfills, and reprocessing
- late-arriving data patterns and idempotent job design
- CDC-based ingestion where applicable
- Build integrations for key enterprise SaaS systems (Salesforce, Marketing Cloud, Netsuite, Zuora, Gainsight, CSOD) and internal app databases.
- Data Modeling & dbt Development
- Own the data modeling layer in Snowflake with dbt:
- design dimensional models (star schemas), marts, and curated layers
- implement dbt best practices: staging → interme

📌 Data Architect (Ciudad de México)
🏢 Bmc Software
📍 Ciudad de México