Data Engineer (Spanish Fluent)

Job Description

Key Responsibilities

\n

\n
• Design, develop, and maintain scalable data transformation pipelines using dbt Core and dbt Cloud.

\n

• Build and maintain reusable dbt models, macros, tests, snapshots, seeds, and packages following established development standards.

\n

• Configure and manage dbt Cloud environments, jobs, schedules, deployments, and orchestration workflows.

\n

• Configure, manage, and troubleshoot Fivetran connectors for SaaS applications, databases, files, and other supported source systems.

\n

• Understand and manage Fivetran schema changes, historical syncs, incremental loads, connector configurations, and destination behavior.

\n

• Design and develop scalable data solutions within Snowflake, including databases, schemas, tables, views, secure views, and other required data objects.

\n

• Write advanced and optimized SQL for complex data transformations, data validation, reconciliation, and analytics requirements.

\n

• Build curated, analytics-ready datasets and data marts that can support BI tools, reporting, advanced analytics, and downstream applications.

\n

• Translate business requirements and source-system structures into scalable data models and transformation logic.

\n

• Perform source-to-target mapping, data profiling, reconciliation, and validation across source systems, Fivetran, Snowflake, and dbt transformation layers.

\n

• Apply strong dimensional modeling principles, including fact tables, dimension tables, star schemas, and appropriate data-grain definition.

\n

• Use Git-based development practices including branching, pull requests, code reviews, version control, and controlled deployments.

\n

• Implement and support CI/CD processes for dbt development and deployment across development, testing, and production environments.

\n

• Design and build Snowflake Bronze/Raw, Silver/Cleansed, Gold/Business-Ready, and Semantic layers following a medallion-style architecture, with dbt used for reusable and governed transformations.

\n

• Configure and manage Fivetran ingestion pipelines, including source connections, scheduling, initial load validation, monitoring, and troubleshooting.

\n

• Use Git, Azure DevOps, and CI/CD pipelines for source control, approvals, deployment automation, and release promotion across environments.

\n

• Apply Snowflake security practices including RBAC, object-level permissions, and dynamic data masking where required.

\n

• Develop, configure, test, and refine the Snowflake CoCo AI Agent, working with business stakeholders to validate semantic definitions, business metrics, governed questions, and AI-generated responses.

\n

• Troubleshoot production data issues across the end-to-end pipeline from source → Fivetran → Snowflake → dbt → consumption layer.

\n

• Collaborate with data architects, data engineers, BI developers, analysts, and business stakeholders to deliver reliable data solutions.

\n

• Participate in technical design discussions, code reviews, solution reviews, and implementation planning.

\n

\n