Business Intelligence Analyst Job Description Template (Free, 2026)

Job Title: Business Intelligence Analyst Department: Analytics / Data / Business Intelligence Location: [City, State] — Remote / Hybrid Reports To: Head of Analytics / VP of Data / Director of BI Employment Type: Full-Time About [Company] [Company] is a [stage/industry] company with a growing data team building the analytical infrastructure that supports [Sales / Marketing / Finance / Operations / Product — specify] decisions. Our data stack includes [Snowflake / BigQuery / Redshift] for warehousing, [Tableau / Power BI / Looker] for visualization, and [dbt / Spark — if applicable] for data transformation. About the Role As a Business Intelligence Analyst, you will own the design, development, and maintenance of BI dashboards, data models, and ad-hoc analyses that empower business teams to make data-informed decisions with confidence. You combine deep SQL skills with business acumen — understanding not just how to pull data, but which questions matter and how to communicate answers clearly to non-technical stakeholders. Key Responsibilities • Design and build production-quality BI dashboards and reports in [Tableau / Power BI / Looker] for [Sales / Finance / Operations / Marketing] stakeholders. • Write complex SQL queries across multi-table schemas to extract, transform, and validate data for analysis and reporting. • Build and maintain data models in the data warehouse using dbt or equivalent transformation tooling. • Partner with business stakeholders to gather requirements, understand analytical needs, and translate questions into structured analyses. • Ensure data quality and consistency across BI reports — own data validation, documentation, and lineage tracking. • Develop and maintain a metrics catalog: standardize definition of key KPIs (ARR, CAC, LTV, churn, cost-per-unit, etc.) across the organization. • Conduct ad-hoc analyses to answer strategic business questions; present findings to director-level and VP stakeholders. • Train and support self-service analytics users across the business — enabling teams to explore data with minimal analyst dependency. • Contribute to data infrastructure improvements: schema design, indexing optimization, and pipeline reliability. • Stay current on BI tooling capabilities and propose improvements to the analytical infrastructure. Required Qualifications • 3+ years of experience in a BI, data analyst, or analytics engineering role. • Expert-level SQL proficiency — able to write and optimize complex queries including CTEs, window functions, and multi-table joins. • Proficiency with at least one BI tool (Tableau, Power BI, Looker, or equivalent) including calculated fields, parameter controls, and performance optimization. • Experience working with a modern cloud data warehouse (Snowflake, BigQuery, or Redshift). • Strong data storytelling skills — able to translate analytical findings into clear business recommendations. • Bachelor's degree in Statistics, Mathematics, Computer Science, Economics, or a related quantitative field. Nice to Have • Experience with dbt for data transformation and modeling. • Python or R for exploratory data analysis and statistical modeling. • Experience building a metrics layer or semantic layer (LookML, AtScale, etc.). What We Offer • Base salary: $80,000 – $140,000 depending on experience • Annual performance bonus • Equity / RSU participation • Full benefits: health, dental, vision • 401(k) with company match • Learning budget for data certifications and conferences • Modern cloud data stack — no legacy BI maintenance