DaCodes.
DaCodes.
DaCodes. je tehnološko podjetje, ustanovljeno leta 2014, ki organizacijam pomaga razvijati programsko opremo in napredovati pri digitalni preobrazbi. Njegove storitve vključujejo izdelke, ki jih poganja umetna inteligenca, zagotavljanje kakovosti, UX/UI-oblikovanje, full-stack razvoj in razširjanje ekip z dodatnimi strokovnjaki. Z več kot 900 dokončanimi projekti in ekipo več kot 220 strokovnjakov DaCodes. deluje v panogah, kot so avtomobilska industrija, zdravstvo in e-trgovina, ter tehnološke rešitve prilagaja operativnim potrebam posamezne panoge.

Senior Snowflake and dbt Data Engineer

Build a Snowflake and dbt data platform that turns enterprise data into dependable insights. Integrate data sources, strengthen quality and access controls, and support AI solutions for DaCodes clients.

Opis

  • Build a Snowflake data warehouse that brings together databases, APIs, and files.
  • Create pipelines from SQL Server, SAP ASE/Sybase, REST APIs, and files using ODBC connections and an Openflow-based connector pattern.
  • Retain raw data and extraction timestamps so workloads can be replayed without querying source systems again.
  • Develop Bronze, Silver, and Gold layers, dimensional models, and historical tracking.
  • Create dbt transformations, including incremental models, tests, and documentation.
  • Standardize catalogs and identifiers across systems through versioned mappings and coverage checks.
  • Apply data quality rules, quarantine processes, and reconciliation against source systems and business reports.
  • Schedule overnight loads, monitor runs, and troubleshoot failures.
  • Manage Snowflake permissions and access policies while monitoring performance and credit usage.
  • Contribute semantic models, verified queries, and accuracy tests for AI agent use.
  • Document lineage, operations, and recovery procedures for handoff to the client team.
  • Work with business users and an AI engineer to define clear metrics, verify figures, and apply appropriate permissions.

Zahteve

  • At least five years building production data warehouses, including two years working with Snowflake.
  • Advanced SQL skills and experience investigating schemas and business rules in poorly documented systems.
  • Dimensional modeling experience, including star schemas, conformed dimensions, and historical tracking.
  • Experience working directly with business teams to define metrics, standardize information, and resolve discrepancies between reports and source data.
  • Strong knowledge of Snowflake warehouses, RBAC, row access policies, masking, and resource monitors.
  • Advanced dbt experience spanning transformations, declarative tests, incremental materializations, and generated documentation.
  • Ability to diagnose performance issues and manage resource consumption.
  • Experience extracting data from SQL Server and SAP ASE/Sybase.
  • Experience integrating REST APIs with authentication, token renewal, pagination, rate limits, and retries.
  • Experience orchestrating pipelines and handling monitoring, data quality, quarantine, and reprocessing.
  • Experience connecting data warehouses to LLM solutions, including semantic models, governed Text-to-SQL, and verified queries.
  • Practical knowledge of lineage, access controls, and evaluating response accuracy and repeatability.
  • Experience with Snowflake Intelligence, Cortex Analyst, Cortex Agents, or Cortex Search is a plus.
  • Experience with Openflow, Dynamic Tables, or Snowpark is a plus.
  • Experience with RAG over documents integrated with structured data is a plus.
  • Experience with Sybase- or SQL Server-based ERPs is a plus.
  • SnowPro Core or Advanced certification is a plus.
  • Intermediate English, including the ability to understand technical documentation.
  • Spanish is the working language.

Ugodnosti

  • Work with global brands and disruptive startups.
  • Remote work from home.
  • Schedule aligned with the assigned team or project.
  • Monday-to-Friday workweek.
  • Birthday day off.
  • Major medical insurance for employees in Mexico.
  • Life insurance for employees in Mexico.
  • Access to courses and certifications.
  • Virtual team events and interest groups.
  • English classes.
  • The company is Great Place to Work certified.

Sorodna delovna mesta