
Junior Business Analyst
AllWork
full-time
Posted on:
Location Type: Remote
Location: New Jersey • United States
Visit company websiteExplore more
Salary
💰 $60,000 - $70,000 per year
Job Level
About the role
- Serve as the first point of contact for internal reporting and data requests; gather context, align on the question being asked, and deliver accurate outputs on time
- Build and maintain reporting in Sigma so stakeholders have access to reliable, up-to-date dashboards and performance views
- Create ad hoc reports and summaries that answer specific business questions for internal teams and, at times, client-facing needs
- Partner with cross-functional leaders to define metrics, align on data definitions, and document reporting logic so work is consistent and repeatable
- Support process improvements related to reporting requests, including templates, documentation, and lightweight workflow optimization
- Combine and reconcile datasets when needed, including mapping external data sources to internal reporting for analysis and trend tracking
- Assist on larger analysis and reporting initiatives by gathering requirements, validating outputs, and supporting rollout to stakeholders
Requirements
- Bachelor's degree in business Analytics, Economics, Statistics, or a related field (or equivalent practical experience)
- 0–2 years of relevant experience (internships, academic projects, and hands-on analytics work are welcome)
- Advanced Excel skills, including VLOOKUP/XLOOKUP, Pivot Tables, data cleaning, and building repeatable templates **(required)**
- Experience with a BI or visualization tool such as Sigma, Tableau, or PowerBI (Sigma is a plus)
- SQL is preferred but not required; ability to work with queries or a strong willingness to learn
- Python familiarity is a plus but not required
- Strong attention to detail and comfort working in fast-moving environments with multiple incoming requests
- Ability to communicate data findings clearly in writing for non-technical stakeholders and summarize takeaways in a straightforward way
Benefits
- Stock options
- Full medical and dental insurance
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
advanced ExcelVLOOKUPXLOOKUPPivot Tablesdata cleaningreportingdata analysisSQLPythondata visualization
Soft Skills
attention to detailcommunicationcollaborationproblem-solvingtime managementadaptabilityorganizational skillscritical thinkingstakeholder managementprocess improvement