Analytics Engineer - Build Scalable Data Models (Remote)

BairesDev; Peru (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

BairesDev is a global technology services company enabling teams to deliver cutting-edge data solutions. As an Analytics Engineer, you will bridge data engineering and analytics, building clean, tested, and documented data models to empower analysts and data scientists with reliable, self-service data structures.

You will design robust data models with dbt, optimize SQL for Snowflake or BigQuery, and apply software engineering practices to ensure scalable, well-documented data pipelines.

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 for high-performance data processing in Snowflake or BigQuery.
• 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 metrics and dimensions.
• Maintain and improve the data warehouse architecture to support scalable reporting and analytics.

Skills

Data modeling

SQL

Data warehousing

English proficiency

Tools

dbt

Snowflake

BigQuery

Version control

Job description

BairesDev is a global technology services company enabling teams to deliver cutting-edge data solutions. As an Analytics Engineer, you will bridge data engineering and analytics, building clean, tested, and documented data models to empower analysts and data scientists with reliable, self-service data structures.

You will design robust data models with dbt, optimize SQL for Snowflake or BigQuery, and apply software engineering practices to ensure scalable, well-documented data pipelines.