Business Intelligence Engineer

Location: Remote

Engagement Type: Full-Time Contract-Based Role

Compensation Range: $1,500 - $3,000 / 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 reaching 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 (e.g., 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.

Tool Proficiency:

• SQL: Advanced proficiency in writing complex, performant SQL for data extraction, transformation, and analysis.
• Python: Proficiency in Python for data manipulation, transformation, automation, and analysis
• dbt: Proficiency building data models, tests, and documentation with dbt.
• ClickHouse: Working experience querying and optimizing data within ClickHouse for analytical workloads.
• BigQuery: Hands-on experience with data warehousing, querying, and modeling within Google BigQuery.
• Apache Airflow: Building and orchestrating ETL/ELT pipelines with Apache Airflow.
• Metabase: Experience building and managing dashboards, questions, and self-serve reporting within Metabase.

Analytical & Problem-Solving Mindset: Ability to approach problems systematically, identify root causes, and propose data-driven solutions.

Attention to Detail: Meticulous attention to detail in pipeline design, data validation, and reporting accuracy.

Communication: Excellent English verbal and written communication skills, with the ability to present complex data insights clearly and concisely to both technical and non-technical stakeholders, including client-facing interactions.

Preferred Qualifications:

While not strictly required, candidates possessing the following will be highly regarded:

• Familiarity or proficiency with GitHub for version controlling and collaborating on ETL pipeline code, dbt models, and other data assets.
• Experience with CI/CD workflows for data pipelines or dbt projects.
• Exposure to cloud environments (GCP, AWS, Azure).
• Familiarity with healthcare data or patient engagement metrics.
• Experience with Confluent Cloud or similar event streaming platforms for real-time data ingestion and processing.
• Familiarity with workflow automation tools such as n8n or Make for building and managing automated business and data workflows.
• Familiarity with healthcare data or patient engagement metrics.
• ClickUp: Experience using project management tools for organizing tasks, tracking project progress, and collaborating with cross-functional teams.
• Looker Studio: Proven experience developing, maintaining, and customizing interactive dashboards and reports.
• HubSpot Reporting: Strong experience extracting, analyzing, and reporting on marketing and sales data within the HubSpot platform.