Analytics Engineer - Remote Work | REF#304633

BairesDev; Colombia; Remote; COP 286,451,000 - 413,762,000; Full time

Benefits offered by this job

Remote work

USD compensation

Home-office setup

Flexible hours

Paid leaves and holidays

Mentorship and growth

Job summary

BairesDev in Colombia is seeking an Analytics Engineer to bridge data engineering and analytics by building clean, tested data models for self-service reporting.

You will design robust dbt models, optimize SQL for Snowflake or BigQuery, and collaborate with analysts and engineers to define key metrics. This fully remote role offers flexible hours and competitive USD compensation.

Qualifications

• 4+ years in Analytics/Data Engineering or related field.
• Proficiency in SQL and experience with Snowflake or BigQuery.
• Hands-on dbt experience transforming data and bridging engineering and analytics.
• Advanced proficiency in English.

Responsibilities

• Design and implement data models with dbt to transform raw data into insights.
• Write and optimize SQL for high-performance data processing in Snowflake or BigQuery.
• Apply software engineering best practices to data transformations with version control, testing, and documentation.
• Collaborate with data engineers to streamline ingestion and with analysts to define key metrics.
• Maintain and improve the data warehouse architecture to support scalable reporting and analytics.

Skills

Analytics engineering

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.

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!