BI Engineer (Data Analyst)

About the role

APPLY is an Agentic Customer Experience partner for consumer and entertainment brands, working with companies such as Arc'teryx, NFL, Lululemon and Kraft Heinz. It is looking for a BI Engineer (Data Analyst) to design, build and maintain BI dashboards and reports that turn raw platform data into actionable insights for business and marketing stakeholders. The role is hybrid/remote-friendly, with candidates expected to be based in Latin America and aligned to PT or ET hours; those in Santiago, Chile can work from the Santiago office.

Key responsibilities

• Build and maintain BI dashboards and reports in Looker Studio and Power BI.
• Partner with Data Engineering to migrate and validate dashboard data models during the GCP-to-Azure/Snowflake migration, keeping metrics consistent.
• Run exploratory data analysis on BigQuery and Snowflake datasets and write and optimise SQL, including dbt models.
• Collaborate on Dagster-orchestrated pipelines, understand their lineage and help design data models.
• Prototype agentic AI and data science solutions such as LLM-powered analysis and propensity modelling.
• Apply data governance principles, including privacy and retention deletion workflows (OneTrust) and handling of PII across CRM and MarTech integrations (Customer.io, Twilio Segment).
• Own the end-to-end reporting lifecycle, from requirements gathering to stakeholder walkthroughs, and fix data quality issues with Data Engineering.

Required profile

• Bachelor's degree in a related field or equivalent practical experience.
• 4+ years of experience in business intelligence, data analytics or analytics engineering.
• Strong SQL skills and hands-on dashboard experience in Looker Studio and/or Power BI.
• Excellent communication skills to explain data findings to non-technical stakeholders.

Required skills

• SQL across BigQuery and/or Snowflake, including CTEs and window functions.
• dbt for data modelling and transformation.
• Pipeline orchestration tools, Dagster preferred, Airflow or similar acceptable.
• Data governance and privacy compliance, ideally with OneTrust exposure.
• CRM/MarTech data sources such as Customer.io or Twilio Segment.
• Some data engineering skills (Python, pipeline debugging, schema design) are a strong plus; cloud migration experience is a plus.

What we offer

• Work on international brand engagements with a focus on Agentic AI upskilling and training budgets.
• A generous vacation policy and flexible work arrangements, from remote to in-office.
• An inclusive, safe environment.