Business Data Analyst
Role Overview
Turns operational and product data into analysis supporting growth, finance, customer operations, and product decisions.
Works across SQL-based data warehouses, BI tools, and curated reporting models to define metrics, investigate performance, and deliver trusted insights.
Partners with stakeholders to structure ambiguous business questions and improve data visibility through useful dashboards and datasets.
Key Skills for This Role
Full Job Posting
Role overview
Turns operational and product data into analysis supporting growth, finance, customer operations, and product decisions.
Works across SQL-based data warehouses, BI tools, and curated reporting models to define metrics, investigate performance, and deliver trusted insights.
Partners with stakeholders to structure ambiguous business questions and improve data visibility through useful dashboards and datasets.
Key responsibilities
- Analyze product, customer, revenue, and operational data with SQL to identify trends, anomalies, and performance drivers.
- Build and maintain dashboards and recurring reports with clear metric definitions and documented data sources.
- Translate stakeholder questions into analytical requirements, measurable KPIs, scoped deliverables, and timelines.
- Partner with analytics engineers to improve dbt models, transformations, and downstream reporting reliability.
- Validate datasets and reports using reconciliation checks, anomaly detection, and documented quality-control processes.
- Present findings and recommendations to technical and non-technical stakeholders.
- Automate recurring analysis and reporting with Python, spreadsheet scripting, or scheduled warehouse queries.
Requirements and qualifications
- 2–4 years of experience in business analysis, data analysis, product analytics, operations analytics, or a related quantitative role.
- Advanced SQL skills, including complex joins, CTEs, window functions, aggregations, and query-performance fundamentals.
- Hands-on experience with a modern data warehouse such as Snowflake, BigQuery, Redshift, or Databricks SQL.
- Experience building production dashboards and self-service reporting in Looker, Tableau, Power BI, or a comparable platform.
- Working knowledge of data modeling, dimensional schemas, metric definitions, and transformation frameworks such as dbt.
- Strong communication skills for explaining findings, assumptions, and limitations to business and technical audiences.
- Bachelor’s degree in analytics, statistics, economics, computer science, business, or a related quantitative discipline.
- Bonus experience includes Python, experimentation or A/B testing, dbt, Amplitude, Mixpanel, or SaaS business metrics.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career