AI-Driven BI Engineer — Dashboards & Data Ops (Remote)

APPLY; Colombia; Remote; COP 190,967,000 - 286,451,000; Full time

Benefits offered by this job

Flexible work arrangements

Generous vacation policy

AI upskilling budget

Job summary

APPLY is seeking a data-driven BI professional to design, build, and maintain dashboards and reports using Looker Studio and Power BI. You will work with Data Engineering on migrations, model validation, and governance while exploring advanced analytics, AI-enabled insights, and data pipelines to empower business stakeholders across LATAM operations.

You will leverage SQL on BigQuery/Snowflake, dbt models, and orchestration tools like Dagster or Airflow, contributing to a robust, compliant

Qualifications

• 4+ years of experience in business intelligence, data analytics, or a hybrid analytics engineering role.
• Strong SQL skills across BigQuery and/or Snowflake — comfortable with complex queries, CTEs, and window functions.
• Hands-on experience building dashboards and reports in Looker Studio and/or Power BI.
• Working knowledge of dbt for data modeling and transformation.
• Familiarity with pipeline orchestration tools — Dagster preferred, Airflow or similar also acceptable.
• Understanding of data governance and privacy compliance concepts, ideally with exposure to OneTrust or a similar consent/privacy management platform.
• Experience working with CRM/MarTech data sources such as Customer.io, Twilio Segment, or comparable CDP/ESP platforms.
• Some hands-on data engineering skills (Python, pipeline debugging, schema design) are a strong plus.

Responsibilities

• Design, build, and maintain BI dashboards and reports (Looker Studio & Power BI) that turn raw platform data into clear, actionable insights for business and marketing stakeholders.
• Partner with Data Engineering to migrate and validate dashboard data models through the GCP-to-Azure/Snowflake migration, ensuring metric parity and no regression in reporting accuracy.
• Perform exploratory data analysis across BigQuery/Snowflake datasets to identify trends, anomalies, and opportunities the business isn’t already looking at.
• Write and optimize SQL across BigQuery and Snowflake, and build/maintain dbt models to support scalable, governed data marts.
• Collaborate on Dagster-orchestrated data pipelines — understanding lineage and dependencies well enough to troubleshoot issues and contribute to data model design, not just consume the output.
• Explore and prototype agentic AI and data science solutions (e.g., LLM-powered analysis, automated insight generation, predictive/propensity modeling) to accelerate how the team surfaces and acts on data.
• Apply data governance principles in day-to-day work: support privacy and retention deletion workflows (OneTrust), and ensure PII is handled correctly across CRM/MarTech data integrations (Customer.io, Twilio Segment).
• Own the end-to-end reporting lifecycle — requirements gathering, data modeling, dashboard build, validation, and stakeholder walkthroughs.
• Identify data quality issues and partner with Data Engineering to resolve root causes rather than patching symptoms downstream.
• Stay current on BI and analytics tooling and proactively recommend improvements to the platform’s reporting stack.

Skills

SQL

Looker Studio

Power BI

Python

Data Modeling

Data storytelling

Communication

Education

Bachelor’s degree in Data Science, Computer Science, Statistics, Information Systems, or related field

Tools

Dagster

Airflow

dbt

BigQuery

Snowflake

Job description

APPLY is seeking a data-driven BI professional to design, build, and maintain dashboards and reports using Looker Studio and Power BI. You will work with Data Engineering on migrations, model validation, and governance while exploring advanced analytics, AI-enabled insights, and data pipelines to empower business stakeholders across LATAM operations.

You will leverage SQL on BigQuery/Snowflake, dbt models, and orchestration tools like Dagster or Airflow, contributing to a robust, compliant