Data Engineer - COL

Deckard; Perímetro Urbano Medellín; Presencial; COP 60.000.000 - 90.000.000; Jornada completa

Descripción de la vacante

Deckard Technologies is seeking a Data Engineer to join our Medellín, Colombia office. You will monitor database health, oversee end-to-end data pipelines, and develop scalable analytics tools within Snowflake and Sigma Computing.

You’ll design dashboards, collaborate with Implementation, Data, and Client Experience teams to ensure data integrity, and deliver self-service reporting assets that drive customer value.

Formación

• 2–4 years of hands-on experience in data engineering, data analysis, BI development, or database monitoring.
• Advanced SQL—proficient in writing and optimizing complex queries across Snowflake, BigQuery, PostgreSQL, or Redshift.
• Experience with Sigma Computing or dashboards in Tableau/Power BI/Looker.
• “English (min B2) and Spanish” proficiency required for cross-border collaboration.
• Bachelor’s degree in a quantitative field or equivalent practical experience.

Responsabilidades

• Monitor SQL and cloud data warehouse pipelines, staging tables, and automated data ingestion for high availability and data integrity.
• Design, build, and maintain interactive dashboards and reporting tools within Sigma and other BI platforms.
• Transform and model data, write robust SQL, and prepare datasets for BI consumption.
• Identify bottlenecks and data quality issues; troubleshoot anomalies across pipelines.
• Collaborate with Implementation, Program Managers, and Data Engineers to support client data workstreams and documentation.

Conocimientos

Snowflake

Sigma Computing

SQL

Data modeling

Data pipelines

ETL/ELT

Data governance

Bilingual EN/ES

Educación

Bachelor’s degree in Statistics, Economics, Computer Science, Engineering, or Information Systems

Herramientas

Tableau

Power BI

Looker

Sigma Computing

Descripción del empleo

Note: To be eligible for this role, you must be based in Medellín, Colombia and able to work from our office three days per week. Working hours are 10:00 a.m. to 6:30 p.m. (Colombia time), Monday to Friday a schedule designed to provide overlap with our teams across multiple U.S. time zones.

About Deckard Technologies

Deckard Technologies is a GovTech data company helping local governments address residential property-related challenges, with a focus on compliance and tax collection. Founded in 2018, we operate globally with offices in the U.S., Colombia, and Australia.

Trusted by over 400 jurisdictions worldwide, our scalable, cost-effective products leverage patented processes and combine best-in-class data collection with intuitive, AI-powered solutions, transforming how local governments monitor and manage properties.

Joining us means you’ll be working with a diverse group of inspiring people from industry experts and extraordinary technology and data operations teams to innovative product leaders in a down-to-earth and supportive culture.

Role Overview

We are seeking a Data Engineer to join our operational office in Medellín, Colombia. In this role, you will be responsible for monitoring database health, overseeing end-to-end data pipeline flows, and developing scalable analytics tools, dashboards, and operational workflows within Snowflake and Sigma Computing.

You will work closely with cross-functional Implementation, Data, and Client Experience teams to ensure data integrity, streamline business intelligence delivery, and build self-service reporting assets that drive customer value.

Key Responsibilities

• Database Monitoring & Data Flow Quality/Oversight: Proactively monitor SQL and cloud data warehouse pipelines, staging tables, and automated data ingestion to ensure continuous availability, high performance, and data integrity.
• Sigma BI Development: Design, build, and maintain interactive dashboards, complex data workbooks, and custom internal and external reporting tools within Sigma.
• Data Transformation & Modelling: Write efficient, robust SQL queries, data models, and transformation scripts to prepare raw, multi-source datasets for BI consumption.
• Troubleshooting & Anomaly Detection: Quickly identify, isolate, and resolve pipeline bottlenecks, data synchronisation failures, broken schemas, or report calculation discrepancies.
• Cross-Functional Collaboration: Partner with Implementation Coordinators, Program Managers, and Data Engineers to structure client-specific data workstreams, including legacy records and spatial data assets.
• Documentation & Standards: Document data dictionary definitions, metric logic, workflow automations, and reporting best practices to support team scalability.

Required Skills, Qualifications & Experience

• Snowflake and Sigma Computing: Demonstrated practical experience working with cloud data warehouses and building dashboards and calculation models in Sigma Computing or deep expertise in platforms such as Tableau, Power BI, or Looker, with a strong ability to quickly master Sigma. Experience with cloud data warehouse platforms such as Snowflake, BigQuery, PostgreSQL, or Amazon Redshift is valued, with direct Snowflake experience being highly regarded.
• Experience: 2–4 years of hands‑on experience in data engineering, data analysis, BI development, or database monitoring in a production environment.
• Advanced SQL—Essential: Strong, hands‑on SQL capability is essential for this role. Candidates must be proficient in writing and optimising complex queries using CTEs, window functions, joins, and aggregations across cloud data warehouses such as Snowflake, BigQuery, PostgreSQL, or Amazon Redshift.
• Data Flow & Pipeline Knowledge: Solid understanding of ETL/ELT principles, database schema design, and tracking data lineage from ingestion through to dashboard display.
• English and Spanish Language Proficiency: A minimum B2 level of English proficiency, both verbal and written, is required, alongside native or fluent Spanish. This role involves regular communication and collaboration with English-speaking colleagues across the United States and Australia.
• Problem-Solving: Strong analytical mindset with rigorous attention to detail regarding data accuracy and quality assurance.
• Analytical & Model Literacy: Comfort working with the outputs of predictive and classification models, such as booked-versus-blocked night inference and occupancy estimates. This includes understanding confidence thresholds, precision and recall trade-offs, known failure modes, and representing predicted values as distinct from observed values in dashboards and client‑facing reporting.
• Data Governance & Confidentiality: Sound judgment when handling sensitive client data and public records containing personally identifiable information, including address-level and parcel-level data. Familiarity with access controls, row-level security, and the principle of exposing only the minimum data a given report or user requires.
• Communication & Data Storytelling: Ability to explain data limitations, methodology, and confidence levels to non-technical partners, Implementation Coordinators, Program Managers, and client stakeholders in clear terms. You’ll be the person who explains what a number does and does not support and translates a schema change or data gap into what it means for a client’s deliverable.
• Education: Bachelor’s degree in a quantitative field such as Statistics, Economics, Computer Science, Engineering, or Information Systems—or equivalent practical experience.

Preferred Qualifications

• DBT Experience: Experience working with DBT would be an asset, demonstrating exposure to large-scale, modern SQL pipelines and structured data transformation practices.
• Familiarity with scripting languages for data automation, such as Python, R, or Bash.
• Experience with GIS or spatial data layers, such as Esri ArcGIS integrations.
• Prior experience in a SaaS, civic technology, GovTech, or data‑intensive analytics start‑up environment.
• Experience working directly with U.S.-based distributed teams.

English-Language Requirement

As this role works closely with colleagues across the United States and Australia, candidates must have a minimum B2 level of English proficiency and be comfortable participating in meetings, discussing technical matters, and communicating clearly in writing.

Equal Opportunity

At Deckard Technologies, we select candidates solely on merit, experience, and suitability for the role, in line with Article 13 of the Political Constitution of Colombia and Law 931 of 2004. The English-language requirement for this position is directly related to the operational responsibilities of the role and the need to collaborate with English-speaking colleagues across the United States and Australia.

We do not discriminate based on age, sex, race, national or family origin, language background, religion, or political or philosophical opinion.

We welcome applications from persons with disabilities and will make reasonable adjustments to our selection process upon request, in keeping with Law 361 of 1997. Deckard is committed to providing a workplace free from harassment and workplace violence, in line with Law 1010 of 2006 and supported by our Comité de Convivencia Laboral.

If you’re interested in this role but don’t meet 100% of the requirements listed, we encourage you to apply anyway.