DaCodes.
DaCodes.
DaCodes. ir 2014. gadā dibināts tehnoloģiju uzņēmums, kas palīdz organizācijām izstrādāt programmatūru un veicināt digitālo transformāciju. Tā pakalpojumi ietver mākslīgā intelekta produktus, kvalitātes inženieriju, UX/UI dizainu, pilna cikla izstrādi un talantu piesaisti. Ar vairāk nekā 900 pabeigtiem projektiem un vairāk nekā 220 ekspertu komandu DaCodes. darbojas tādās nozarēs kā autobūve, veselības aprūpe un e-komercija, pielāgojot tehnoloģiju risinājumus katras nozares darbības vajadzībām.

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.

Apraksts

  • 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.

Prasības

  • 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.

Priekšrocības

  • 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.

Saistītās vakances

Applaudo

Temporary Data Engineer (Remote, Peru)

Applaudo

Build dependable Zuora-to-GCP ETL pipelines that support Applaudo’s AI-powered solutions. Maintain integrations, data quality, monitoring, and warehouse validation in an async distributed team.

Atvērt