Data Analyst (Entry-Level / 100% Remote)
Quick Facts & Transparency
Position Type: Full-Time, Entry-Level
Location: 100% Remote (Work from anywhere in the US)
Salary Range: $40/hr $75,000 – $85,000/year]
Why This Role is Special & Our Values
Founded in 1950, Johnson’s Real Ice Cream is a 4th-generation, family-owned Central Ohio staple. While we are deeply rooted in heritage, our multi-location business is rapidly expanding, and we rely heavily on data to guide our next steps.
As our Remote Data Analyst, your insights will directly impact how we scale our flavors, optimize our production supply chain, and expand our market reach.
Our Commitment to Diversity, Equity, & Inclusion (DEI)
We evaluate candidates based on their unique perspectives, core skills, and alignment with our mission not just their major or background. We prioritize an inclusive, supportive environment where every team member is treated like family, even from a distance.
Thriving in a Remote Team
No Islands: You will stay deeply connected through daily virtual syncs and dedicated remote mentorship with senior team members.
Trust & Autonomy: We measure success by the quality of your insights and your impact, not by watching your screen.
Skills You Bring (Qualifications)
We practice skills-based hiring. We care about your core quantitative foundational skills and your eagerness to learn, not years of corporate experience. We welcome applicants from all majors.
Technical Fundamentals: Hands-on project, coursework, or bootcamp experience writing SQL queries and navigating Microsoft Excel (advanced formulas, Pivot Tables).
Data Visualization: Exposure to building clear charts or dashboards in tools like [Tableau, Power BI, or Looker].
Communication: Ability to work autonomously and clearly explain the “story behind the numbers” over Slack and Zoom.
Skills You Will Learn on the Job (Professional Development)
We want this role to launch your career, so we will train and mentor you in:
Enterprise Retail Analytics: Learn how inventory, sales velocity, and seasonal demand data function in a fast-moving, multi-unit business.
Modern Data Stack: Gain hands-on experience navigating real-world cloud databases and production data pipelines.
Cross-Functional Leadership: Build confidence presenting data directly to company executives to solve live business challenges.
Core Responsibilities
Data Extraction: Write SQL queries to pull data from databases and data warehouses.
Data Cleaning: Clean and prepare datasets by fixing missing values, duplicates, and formatting errors.
Analysis & Trends: Analyze historical data to discover trends, patterns, and insights that drive business decisions.
Reporting & Dashboards: Design and maintain automated dashboards and visual reports using tools like Tableau, Power BI, or Looker.
Ad-Hoc Analysis: Respond quickly to specific data requests from various teams to answer live business questions.
Data Quality: Monitor data sources and maintain clear documentation to ensure data accuracy and reliability.
Cross-Functional Communication: Translate complex technical findings into plain-English insights for non-technical team leads.
Data Integrity (20%): Auditing inventory and point-of-sale data to keep our systems clean, accurate, and reliable.
Collaboration (10%): Sharing findings in team syncs to help guide business decisions.
Benefits
Health & Wellness: Comprehensive medical, dental, and vision insurance.
Future Security: 401(k).
Time to Recharge: Competitive Paid Time Off (PTO) and paid holidays.
Continuous Learning
Home Office Support: Company-issued laptop and home office setup stipend.
The Sweetest Perk: A sweet employee perk program ensuring you still get to experience the best handcrafted ice cream in Ohio!