Business Intelligence Engineer Jobs

About The Position

Requirements

• At least 5 years of experience in data engineering, analytics engineering, or BI engineering.
• Bachelor’s degree in Finance, IT, Information Systems, Engineering, or a related field, or equivalent experience.
• Advanced SQL and dbt skills, with a solid grasp of dimensional modeling and data warehousing concepts.
• Deep hands-on Snowflake experience, including performance tuning, access control, and cost management.
• Strong Power BI skills, including DAX, data modeling, and publishing and managing workspaces.
• Git and CI/CD experience for analytics code.
• Working fluency with AI tools in analytics or engineering work, and sound judgment about their limitations, including inaccurate or ungrounded answers.
• Clear communication with technical and non-technical audiences; ability to translate business needs into technical requirements and carry them through deployment; and strong attention to detail.

Nice To Haves

• Experience building ELT pipelines and data ingestion using Fivetran or similar tools, including API-based sources.
• Python for scripting and automation.
• Experience with orchestration tools such as Airflow, Dagster, or similar.
• Infrastructure-as-code experience, such as Terraform, for Snowflake.
• Hands-on experience with Snowflake Cortex Analyst, semantic views, or similar natural-language-to-SQL tools.
• Familiarity with data governance, cataloging, and lineage tooling.
• Background in finance, FP&A, or sales analytics.
• Exposure to Tableau or other BI tools.

Responsibilities

• Maintain the BI Snowflake environment, including schemas, roles and access, performance tuning, warehouse sizing, and cost monitoring.
• Build and optimize Power BI semantic models and dashboards, including star schemas, DAX measures, and row-level security; tune DirectQuery and Import models against Snowflake.
• Translate business requirements, KPIs, and metric definitions into technical designs.
• Set engineering standards for naming, code review, CI/CD, and documentation.
• Partner with the integrations team to define BI platform requirements for landed data and resolve upstream issues.
• Own data quality in the transformation layer through testing, monitoring, reconciliation, and root-cause analysis.
• Write complex, performant SQL to model, transform, and validate data.
• Develop and maintain dbt staging, intermediate, and mart models with tests, documentation, and version control.
• Set up and tune Snowflake Cortex Analyst and Semantic Views so natural-language questions return accurate answers.
• Evaluate, test, and pilot AI-enabled analytics, including natural-language querying over semantic models, AI-generated commentary, and automated variance explanation.
• Mentor analysts and stakeholders on data models and self-service.
• Build Power BI reports and dashboards when needed.

Benefits

• Comprehensive healthcare options, including medical, dental, and vision coverage.
• Flexible spending accounts.
• 401(k) with company matching.
• Generous parental and maternity leave policies.
• Technology stipends.
• Wellness reimbursement programs.
• Annual bonus.