Title and Location

Data Architect (Hands-On Builder)

Location: Mexico Remote

Overview

BMC empowers nearly 80% of the Forbes General 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.

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 to intermediate to marts, modular models, macros, packages
- Define metric-ready datasets (e.g., ARR/NRR, pipeline, churn, product usage) with consistent definitions
- Optimize for performance and cost (clustering, warehouse sizing, query patterns, caching, micro-partitioning awareness)

Cloud Platform Enablement (AWS + Azure)
- Implement secure, scalable data platform components across AWS and Azure: landing zones, storage (S3/ADLS), networking, secrets management, and compute integration patterns
- Secure connectivity to Snowflake (PrivateLink/peering patterns where relevant)
- Work with technology teams to implement RBAC, role hierarchy, masking policies, row access policies, and data sharing patte

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