Analytics Engineer - Remote Work | REF#305695

BairesDev; Bogotá ciudad; Remote; COP 254,639,000 - 381,959,000; Full time

Benefits offered by this job

Remote work

USD compensation

Home office setup

Flexible hours

Parental leave

Mentorship & growth

Job summary

BairesDev is seeking an Analytics Engineer to bridge data engineering and analytics, building clean, tested, and documented data models so analysts and data scientists have reliable, self-service structures for informed decisions.

You will design robust dbt models, optimize SQL, collaborate with data engineers and analysts, and help maintain a scalable data warehouse across Snowflake and BigQuery, while enjoying 100% remote work and flexible hours.

Qualifications

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

Responsibilities

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

Skills

Analytics Engineering

Data Modeling

SQL

dbt

Snowflake

BigQuery

English

Tools

Snowflake

BigQuery

dbt

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.

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

Join a global team where your unique talents can truly thrive and make a significant impact!