Upgrade, Inc. is a fintech company dedicated to improving customers' financial well-being by offering affordable financial products. They are seeking a Junior Business and Data Analyst to support data-driven decision making by building reports, writing SQL queries, and surfacing insights for business leaders.
Responsibilities:
- Analyze data to identify trends, patterns, and anomalies. Support root cause analysis and performance investigations
- Assist 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. You will see how the business runs day to day and where the gaps are, which directly informs how the team prioritizes its work
- 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
- You are 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
- Ability to identify patterns and trends in structured datasets, flag anomalies, and contribute observations that inform strategic recommendations