Senior Business Intelligence Engineer

About the role

The Senior Business Intelligence Engineer plays a crucial role in the BI team, focusing on developing and maintaining analytics solutions and supporting BI Analysts. This position requires collaboration with business stakeholders, data engineers, and BI analysts to deliver BI products and reporting data pipelines.

Responsibilities

• Support the development and maintenance of BI assets in the central data hub
• Optimize SQL, Tableau, and data models
• Collaborate with Data Engineers on ingestion, transformations, and Snowflake/dbt modeling using GitHub based CI/CD processes
• Trussleshoot data quality, lineage, and performance issues
• Build automated data quality checks and monitor BI product and pipeline performance to recommend data-driven improvements
• Design and build Tableau dashboards that deliver actionable insights and support strategic business goals
• Work closely with stakeholders to understand needs, refine requests, and ensure dashboards and BI products are performant, action-oriented, and broadly impactful
• Perform other duties as assigned

Requirements

• Bachelor's Degree in analytics, computer science, statistics, or related field
• 4-6 years Experience in BI, analytics engineering, or analytics-focused roles
• 4-6 years Developing, troubleshooting, and optimizing advanced SQL logic
• 4-6 years Experience with data visualization tools
• 1-3 years Experience working with Snowflake or similar cloud data warehouses
• 1-3 years Experience leveraging Python for data analysis and pipeline development
• 1-3 years Hands-on experience with dbt
• 1-3 years Experience using GitHub for version control and CI/CD

Preferred

• Advanced proficiency in industry-leading BI tools such as Tableau, Power BI, or similar platforms
• Ability to work collaboratively with cross-functional teams and stakeholders to effectively design and deliver high ROI solutions
• Strong understanding of the analyst’s workflow as it relates to both structured and unstructured datasets
• Advanced knowledge and experience with core SQL concepts, including window functions, CTEs, nested queries, and other similar techniques
• Experience with cloud data warehouses (e.g., Snowflake, Redshift, BigQuery) and relational databases
• Experience transforming and analyzing data at all layers of the warehouse (i.e., staging to mart layer)
• Ability to collaborate through code-management/version control tools like GitHub
• Experience contributing to a BI semantic layer and key data marts using tools like dbt, Snowflake, Fivetran
• Python proficiency for data transformation, quality automation, and analytical workflows, with hands-on experience building interactive data apps, such as Streamlit, and applying strong data visualization/analysis skills