Analytics Engineer - Remote Work

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

At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.

Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.

When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

Analytics Engineer at BairesDev

As an Analytics Engineer, you will bridge the gap between data engineering and analytics by building clean, tested, and documented data models. You will ensure that analysts and data scientists have access to reliable, self-service data structures that drive informed business decisions.

What You'll Do:

• Design and implement robust data models using dbt to transform raw data into actionable insights.
• Write and optimize complex SQL queries to ensure high-performance data processing across Snowflake or BigQuery environments.
• Apply software engineering best practices to data transformation, including version control, testing, and documentation.
• Collaborate with data engineers to streamline ingestion and with analysts to define key business metrics and dimensions.
• Maintain and improve the data warehouse architecture to support scalable and reliable reporting and analytics.

What we are looking for:

• 4+ years of experience in Analytics Engineering, Data Engineering, or a related field.
• Proven expertise in data modeling and building clean, tested, and documented data models.
• Proficiency in SQL and experience working with data warehouses such as Snowflake or BigQuery.
• Hands-on experience using dbt to transform data and bridge the gap between engineering and analytics.
• Advanced proficiency in English.

How we do make your work (and your life) easier:

• 100% remote work (from anywhere).
• Excellent compensation in USD or your local currency if preferred
• Hardware and software setup for you to work from home.
• Flexible hours: create your own schedule.
• Paid parental leaves, vacations, and holidays.
• Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent.
• Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities.