Business Intelligence Engineer

Location: Remote

Engagement Type: Full-Time Contract-Based Role

Compensation Range: PHP45,000 - PHP60,000 ($950 - $1,190) / month (commensurate with Experience)

About the Role

The Business Intelligence Engineer is a critical, hands-on role responsible for designing, building, and maintaining the data infrastructure and reporting systems that power business decision-making. You will support the full lifecycle of ETL pipelines and data models, from ingesting raw data to delivering polished, reliable dashboards and reports.

This role requires deep proficiency in Apache Airflow, SQL, dbt, Python, and modern data warehousing with BigQuery and ClickHouse, with reporting delivered through Looker Studio and Metabase. You will work closely with stakeholders across the organization to translate business questions into scalable data solutions and clearly communicate the insights they surface, with marketing and sales performance reporting supported through HubSpot Reporting.

KEY RESPONSIBILITIES

Data Pipeline Engineering & Orchestration

• Design, build, and maintain robust ETL/ELT pipelines using Apache Airflow to orchestrate data ingestion, transformation, and loading across multiple sources, ensuring reliability, scalability, and timely data delivery.
• Develop and enforce data quality checks within pipelines, monitoring for failures, anomalies, and discrepancies to ensure trustworthy data reaches downstream systems.
• Troubleshoot and resolve pipeline issues, implementing alerting and retry logic to minimize data downtime.

Data Modeling & Warehousing

• Develop and maintain dbt data models for BigQuery and ClickHouse, enforcing consistent business logic, documentation, and testing across the data warehouse.
• Write and optimize complex SQL queries across BigQuery and ClickHouse for data extraction, transformation, and ad-hoc analysis, ensuring query performance and data accuracy.
• Define and manage data schemas, naming conventions, and modeling standards to keep the warehouse organized, scalable, and well-documented.

Reporting & Visualization

• Build, maintain, and continuously improve interactive dashboards and reports in Looker Studio and Metabase, visualizing key performance indicators (KPIs) and delivering actionable insights to stakeholders.
• Extract and analyze marketing and sales performance data using HubSpot Reporting, identifying opportunities for optimization across campaigns and customer journeys.
• Perform ad-hoc data analysis to support specific business initiatives and answer critical questions from leadership and client stakeholders.

Stakeholder Communication & Collaboration

• Collaborate with cross-functional teams (marketing, sales, product, client success) to understand their data needs, define metrics, and deliver data-driven recommendations.
• Communicate insights and findings clearly to both technical and non-technical audiences, translating complex data into concise, impactful narratives.
• Manage and track data engineering and reporting tasks, projects, and deadlines, ensuring efficient workflow and clear communication with the team.
• Stay current with best practices in data engineering, BI tooling, and analytics workflows to continuously improve the organization's data capabilities.

REQUIRED SKILLS

Technical & Tool Proficiency

• SQL: Advanced proficiency writing complex, performant SQL for data extraction, transformation, and analysis.
• BigQuery: Hands-on experience with data warehousing, querying, and modeling within Google BigQuery.
• ClickHouse: Working experience querying and optimizing data for analytical workloads.
• dbt: Proficiency building data models, tests, and documentation.
• Apache Airflow: Building and orchestrating ETL/ELT pipelines.
• Python: Proficiency for data manipulation, transformation, automation, and analysis.
• Looker Studio: Proven experience developing, maintaining, and customizing interactive dashboards and reports.
• Metabase: Experience building and managing dashboards, questions, and self-serve reporting.
• HubSpot Reporting: Strong experience extracting, analyzing, and reporting on marketing and sales data.
• ClickUp: Experience using project management tools for organizing tasks, tracking progress, and collaborating cross-functionally.

Core Competencies

• Analytical & Problem-Solving Mindset: Approaches problems systematically, identifies root causes, and proposes data-driven solutions.
• Attention to Detail: Meticulous in pipeline design, data validation, and reporting accuracy.
• Communication: Excellent English verbal and written skills, able to present complex data insights clearly to technical and non-technical stakeholders, including client-facing interactions.

PREFERRED SKILLS

• GitHub: Version controlling and collaborating on ETL pipeline code, dbt models, and other data assets.
• CI/CD: Experience with CI/CD workflows for data pipelines or dbt projects.
• Cloud Environments: Exposure to GCP, AWS, or Azure.
• Healthcare Data: Familiarity with healthcare data or patient engagement metrics.
• Event Streaming: Experience with Confluent Cloud or similar platforms for real-time data ingestion and processing.
• Workflow Automation: Familiarity with n8n, Make, or similar tools for building and managing automated business and data workflows.