Junior Business & Data Analyst
Upgrade, Inc. · San Francisco, CA · 2 wk ago
RemoteRemoteAnalyst$75k–$95k/yrFull-time
About the role
We are looking for a curious, detail-oriented Junior Business and Data Analyst to join our growing analytics team. You will bring at least 2 years of experience in an analytics or data-focused role.
Responsibilities
- Analyze data to identify trends, patterns, and anomalies. Support root cause analysis and performance investigations.
- Aid in KPI tracking, data quality checks, and governance processes.
- Build and maintain business intelligence reports and apply statistical analysis fundamentals.
- Serve as the data resource for the commercial and account management teams.
- Write and maintain SQL queries using joins, CTEs, and window functions. Support query optimization and performance improvements.
- Work within existing data models and warehouse structures to extract and transform data for reporting needs.
- Document data logic and query definitions to support data validation and reconciliation efforts.
- Help enhance and maintain scenario models under guidance. Track and report on forecast accuracy.
- Build and maintain dashboards and standard reports. Develop clear, accurate data visualizations following best practices.
- Support QBR preparation and executive reporting. Contribute to automated reporting solutions.
Requirements
- 2 or more years of experience in an analytics or data-focused role.
- SQL proficiency including joins, CTEs, and window functions. You do not need to be a data engineer but you need to write and maintain real queries.
- Experience with Tableau, Microsoft Excel, Redshift, and Databricks.
- You use AI tools like Claude or ChatGPT as a real part of your workflow, not as a novelty.
- Genuinely curious about data and what it means. When something looks off, you go find out why rather than waiting to be told. You ask questions before starting a project, not after.
- Ability to gather and document business requirements, collaborate cross-functionally, and contribute to business case development.
- Ability to present findings clearly, translate data outputs into plain-language summaries, and develop supporting materials for executive presentations.
- Comfortable forming and testing hypotheses with guidance and developing critical and structured thinking skills.
- Identify patterns and trends in structured datasets, flag anomalies, and contribute observations that inform strategic recommendations.
Qualifications
- Education: A degree without hands-on experience is not a substitute.
Skills
- Data Analytics and Business Intelligence
- Data Visualization
- SQL Proficiency
- Tableau
- Microsoft Excel
- Redshift
- Databricks
- Forecasting
- Reporting
- Collaboration
- Communication
Benefits
- Competitive salary
- 100% paid coverage of medical, dental and vision insurance
- Flexible PTO
- Competitive 401(k)
- Professional growth and development opportunities
- Paid parental leave
- Health & wellness initiatives
Pay
The compensation range of this position in San Francisco, CA is USD $75,000-$95,000 plus equity and benefits. Within this range, an individual's pay will be dependent on a variety of factors, including without limitation, job-related knowledge, skills, education, and experience.
Schedule
Not specified
Application Instructions
Not specified
Equal Opportunity Employer
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.