Remote Analytics Engineer | Data Modeling & dbt Expert

BairesDev; Bogotá; Remote; COP 289,911,000 - 418,760,000; Full time

Benefits offered by this job

Remote work 100%

Competitive USD or local currency pay

Hardware and software setup for home

Flexible hours

Parental leaves, vacations, holidays

Multicultural environment

Mentorship and career growth

Job summary

BairesDev is seeking an Analytics Engineer to bridge data engineering and analytics, building clean, tested data models and self-service structures for analysts and data scientists. You will design robust data models with dbt, optimize SQL for Snowflake or BigQuery, and apply engineering practices to data transformations.

Ideal candidates have 4+ years in analytics/data engineering, strong SQL, and English proficiency, with remote work offered 100% and compensation in USD or local currency.

Qualifications

• 4+ years of analytics engineering or data engineering experience.
• Proficient in data modeling, testing, and documentation.
• Strong SQL skills and experience with Snowflake or BigQuery.
• Proficient in English.

Responsibilities

• Design and implement robust data models using dbt to transform raw data into actionable insights.
• Write and optimize SQL queries for high-performance data processing in Snowflake or BigQuery.
• Apply software engineering practices to data workflows, including version control, testing, and documentation.
• Collaborate with data engineers and analysts to define metrics and dimensions.
• Maintain and improve data warehouse architecture to support reliable reporting.

Skills

Data modeling

SQL

dbt

English

Tools

Snowflake

BigQuery

Job description

BairesDev is seeking an Analytics Engineer to bridge data engineering and analytics, building clean, tested data models and self-service structures for analysts and data scientists. You will design robust data models with dbt, optimize SQL for Snowflake or BigQuery, and apply engineering practices to data transformations.

Ideal candidates have 4+ years in analytics/data engineering, strong SQL, and English proficiency, with remote work offered 100% and compensation in USD or local currency.