BI Engineer (Data Analyst)
Business Analytics
Business Intelligence
Cloud
Cloud Data Warehouse
Data Analysis
Data Analytics
Data Integration
Data Modeling
Data Pipeline
Data Platform
Data Visualization
Data Warehouse
Data Warehousing
Dbt
Google Cloud Bigquery
Integration
Looker Studio
Power BI
Reporting and Analytics
Snowflake
SQL
Job Description
APPLY is hiring a BI Engineer / Data Analyst to support the Kraft Heinz DXP Platform team, owning the full path from raw platform data to actionable stakeholder insights during a GCP to Azure and Snowflake migration.
Responsibilities
- Design, build, and maintain BI dashboards and reports in Looker Studio and Power BI to deliver actionable insights for business and marketing stakeholders.
- Collaborate with Data Engineering to migrate and validate dashboard data models through the GCP to Azure/Snowflake transition, ensuring metric parity and no regression in reporting accuracy.
- Conduct exploratory data analysis across BigQuery and Snowflake to uncover trends, anomalies, and additional opportunities.
- Write and optimize SQL for BigQuery and Snowflake; build and maintain dbt models to support scalable, governed data marts.
- Work with Dagster (or equivalent orchestration) to understand lineage and dependencies well enough to troubleshoot and contribute to data model design.
- Explore and prototype agentic AI and data science solutions, such as LLM-powered analysis, automated insight generation, and predictive/propensity modeling.
- Apply data governance practices daily, including support for privacy and retention deletion workflows using OneTrust and correct handling of PII across CRM/MarTech integrations (e.g., 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 upstream rather than patch downstream.
- Stay current on BI and analytics tooling and recommend improvements to the reporting stack.
Requirements
- Bachelor’s degree in Data Science, Computer Science, Statistics, Information Systems, or a related field, or equivalent practical experience.
- 4+ years of experience in business intelligence, data analytics, or a hybrid analytics engineering role.
- Strong SQL skills across BigQuery and/or Snowflake, including complex queries, CTEs, and window functions.
- Hands-on dashboard and reporting experience with 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 acceptable.
- Knowledge of data governance and privacy compliance, ideally with experience using OneTrust or similar consent/privacy management tooling.
- Experience working with CRM/MarTech data sources such as Customer.io, Twilio Segment, or comparable CDP/ESP platforms.
- Some hands-on data engineering capability is a strong plus (e.g., Python, pipeline debugging, schema design) to support close partnership with Data Engineering.
- Excellent communication skills to translate findings into business insights for non-technical stakeholders.
- Cloud migration experience (GCP, Azure, or AWS) is a plus.
- Curiosity and an insight-first mindset, including proactive exploration beyond requested dashboard deliverables.
Technologies
- Looker Studio, Power BI
- BigQuery, Snowflake, SQL
- dbt
- Dagster, Airflow
- LLM-powered analysis, OneTrust
- Customer.io, Twilio Segment
- Python
- GCP, Azure, AWS
Benefits
- Generous vacation policy
- Flexible work arrangements (remote, in-office, or a blend of both)
- Agentic Delivery
- Inclusive and safe environment
- AI & Strategic Upskilling (generous training budgets and mentorship)
Location
- Hybrid/remote-friendly.
- Preferred candidate location: Latin America, ideally aligned to PT (Pacific Time) or ET (Eastern Time) working hours.
- Candidates based in Santiago, Chile may work out of the Santiago office as remote/hybrid employees.
- Candidates located outside Santiago, Chile will be fully remote employees.
Life at APPLY
- People are at the core of APPLY.
- Modern tools and systems; valuing time, safety, and health.
- Recruitment accommodations: [email protected].