BI Engineer

About Firebolt

Firebolt is the Cloud Data Warehouse designed to handle the speed, scale, and flexibility of AI applications. By delivering ultra-low latency, high concurrency, multi-dimensional elasticity, and flexibility, Firebolt empowers organizations to build data-intensive AI applications that perform at scale. With over $270m in funding to date, a strong engineering team and highly experienced leadership, Firebolt is well positioned to revolutionize the AI data infrastructure space and help businesses unlock the full potential of their data.

Role Overview:

We’re looking for a BI Engineer to help design and build next-generation data pipelines, modeling frameworks, and dashboards that power insights across our AI-driven platform. You’ll work with advanced SQL, data ingestion pipelines, DBT, Airflow, APIs, and cloud DWH architecture. Security and governance are important, but we approach them differently – embedding them into processes rather than slowing innovation.

What You’ll Do:

Build & Maintain the Platform

• Design, build, and maintain data pipelines to ingest, transform, and model data from multiple sources.
• Build and optimize advanced SQL queries for analytics and reporting.
• Develop data models, warehouse schemas, and transformations using DBT and other tools.
• Orchestrate workflows and pipelines with Airflow.
• Integrate APIs to pull in and push out data for analytics and operational workflows.
• Collaborate with product, engineering, and analytics teams to deliver actionable insights.
• Implement innovative approaches to data security and governance, enabling fast AI-driven decision-making without compromising compliance.
• Contribute to building and scaling a cloud data warehouse optimized for AI workloads.

Deliver Business Insights

• Coordinate with the business to identify our most pressing business questions, and translate these questions into metrics & technical specifications.
• Design & maintain the Firebolt business intelligence platform (Firebolt datawharehouse, Present.io).
• Create & maintain dashboards, visualizations & reports for regular topics & requested projects.
• Develop and execute database queries and conduct analyses
• Partner closely with the business to build & maintain the Firebolt data dictionary and data catalog.