Senior BI Engineer
OnDeckSmall Business company
Chicago, United States$72,000-115,000Senior
First Round Capital
Khosla Ventures
RRE Ventures
Sapphire Ventures
Google Ventures
Contour Venture Partners
Data & AI
About the role
TL;DR
Senior BI Engineer to design, develop, and maintain reporting solutions and AI-driven data workflows.
- •As a Senior Business Intelligence Engineer, you will design, develop, and maintain robust reporting solutions and analytic applications that power decision-making across various business units.
- •You will partner directly with business owners to gather requirements, translate them into scalable BI solutions, and take ownership of the full project lifecycle.
- •You will also play a key role in advancing our use of AI across the BI and data development workflow.
- •Key Responsibilities Partner with stakeholders to understand data needs and deliver actionable reporting solutions.
- •Lead technical initiatives end-to-end from architecting the solution to collaborating with peers on execution.
- •Design, implement, and maintain complex SQL and Python processes for reporting and analytics.
- •Architect and enhance ETL/ELT pipelines using Astronomer Airflow and other modern orchestration tools.
- •Build, optimize, and support data marts and data warehouse solutions using Snowflake.
- •Requirements Expert-level SQL and database skills.
- •Strong experience with relational databases and cloud data warehouses (Snowflake, Databricks, BigQuery, or AWS Redshift). 4+ years designing and implementing ETL/ELT pipelines; hands-on experience with Astronomer (Apache Airflow) or similar orchestration tools. 4+ years working with enterprise BI and visualization tools
- •MicroStrategy, Tableau, Looker, PowerBI, or equivalent.
- •Experience leveraging AI tools in day-to-day work.
Required skills
SQLSnowflakeAirflowPythonTableauLookerPower BIAWSGemini APIAnthropic APIOpenAI API
Nice-to-have skills
Python
Domain expertise
fintech
Benefits & perks
Health, dental, and vision insurance including mental health benefits, 401(k) matching plus a roth option, PTO & paid holidays off, Sabbatical program, Summer hours, Paid parental leave, DEI groups, Employee recognition and rewards program, Charitable matching and a paid volunteer day
Tech stack
SQLPythonSnowflakeAirflowTableauLookerPower BIAWSAnthropic APIGemini API