Senior Analytics Engineer – Snowflake / SQL - Remote Work | REF#302902

BairesDev; Chile; Remote; CLP 116,618,000 - 174,927,000; Full time

Benefits offered by this job

Remote work

Competitive USD salary

Home office setup

Job summary

BairesDev in Chile (remote) is seeking a Senior Analytics Engineer to consolidate messy, multi-source vulnerability data into clean Snowflake models, surface risk metrics and dashboards for executive, operational, and engineering audiences.

You will write advanced SQL at scale, build ELT pipelines, design semantic layers, and leverage Snowflake features such as streams and time travel. Strong English and 5+ years of analytics or data engineering are required.

Qualifications

• 5+ years of experience in analytics or data engineering.
• Strong Snowflake expertise for data and analytics engineering.
• Advanced SQL skills including window functions and performance tuning.
• Experience with ELT and data modeling to consolidate heterogeneous data.
• Experience with BI, dashboards, and semantic-layer design for audiences.
• Snowflake-native features such as streams, time travel, or MV.
• Background in data quality, telemetry, and pipeline monitoring.
• Advanced proficiency in English.

Responsibilities

• Write advanced SQL on multi-million-row datasets with performance tuning.
• Build ELT pipelines and data models from heterogeneous data sources.
• Design BI dashboards and semantic layers for executives, operations, and engineering.
• Leverage Snowflake features for near-real-time ingestion and analytics.
• Monitor data quality and pipeline telemetry as part of DataOps.

Skills

Analytics/Data engineering experience

Snowflake expertise

Advanced SQL

ELT & data modeling

BI/dashboarding

Data quality/telemetry

English proficiency

Tools

Python

BI tools

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.

Senior Analytics Engineer – Snowflake / SQL at BairesDev

In this role, you'll consolidate messy, multi-source vulnerability data into clean, query-ready models using Snowflake, then surface risk metrics and dashboards that different audiences can actually use. Working with very large datasets, you'll apply advanced SQL to answer business-aligned questions. This is your opportunity to be the SQL expert who turns complex, heterogeneous data into trustworthy metrics, working at a scale where performance tuning genuinely matters.

What You'll Do

• Write advanced SQL at scale, including window functions, CTEs, and performance tuning on multi-million-row datasets.
• Build ELT pipelines and data models to consolidate heterogeneous vulnerability data into query-ready structures.
• Design BI dashboards and semantic layers tailored to executive, operational, and engineering audiences.
• Use Snowflake-native features for near-real-time ingestion and historical analysis.
• Monitor data quality and pipeline telemetry as part of ongoing DataOps practices.
• Define and defend risk, severity, and SLA metrics.

What We Are Looking For

• 5+ years of experience in analytics or data engineering.
• Strong expertise in Snowflake for data and analytics engineering.
• Advanced SQL skills at scale, including window functions, CTEs, and performance tuning on very large datasets.
• Experience with ELT and data modeling, consolidating heterogeneous data into clean, query-ready models.
• Experience with BI, dashboarding, and semantic-layer design for different audiences.
• Experience with Snowflake-native features such as streams, dynamic tables, time travel, or materialized views.
• Background in data quality, telemetry, and pipeline monitoring.
• Experience defining and validating metrics such as risk, severity, or SLA metrics.
• Advanced proficiency in English.

Nice To Have

• Vulnerability management domain knowledge, including CVSS, EPSS, KEV, or mean-time-to-patch.
• Proficiency in Python for analytics and automation.
• Familiarity with AI/LLM-assisted analytics tooling.
• Financial services or regulated-industry experience.

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!