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.

What We’re Looking For:

• 3+ years in BI engineering, analytics engineering, or data engineering roles.
• Expertise in advanced SQL, data ingestion, modeling, and transformation frameworks.
• Hands-on experience with DBT, Airflow, and API integrations. Familiarity with Preset.io or Apache Superset a plus.
• Familiarity with cloud-based DWH platforms and modern data architecture.
• Strong understanding of data security, governance, and privacy – applied in creative, efficient ways.
• Ability to work in a fast-paced, collaborative environment and translate complex business needs into data solutions.
• Passion for AI and building data systems that scale for next-generation applications.

Why Firebolt:

• Work at the cutting edge of cloud data infrastructure and AI.
• High-impact role with visibility across the company.
• Collaborative, growth-oriented culture with emphasis on learning and experimentation.
• Competitive compensation and equity package.