Junior Data Analyst- Data Analytics

Company Overview As a leading mattress and furniture retailer, we believe that a good night's sleep is the key to wellness. For 60 years, we’ve been passionate about creating the ultimate sleep experience for our customers. We have a fun, dynamic, and diverse team of employees who work together to make our customers' dreams come true. Building on decades of experience, City Mattress is growing and innovating across all our departments. This means opportunity for you! Why City Mattress At City Mattress, our core values — High Performance, Customer-Centricity, Trust, and Teamwork — define who we are and how we operate. We hold ourselves to the highest standards, striving for excellence in everything we do while keeping our customers at the heart of every decision. Wait, there’s more… Low turnover rate of 8% (compared to sector average of 20%*) Average tenure of over 7 years, more than double the industry average Growth is the norm - Our CEO started in the warehouse in his teen years and worked his way up! We have an atmosphere of open and effective communication We are brilliant at the basics and have a lets-get-it-done-together culture! Job Summary We are looking for a curious, detail-oriented Junior Data Analyst to join our growing analytics team. In this role, you will help collect, clean, and analyze data to support business decisions across multiple departments. This is an excellent opportunity for someone early in their analytics career who is eager to develop their skills in a collaborative, data-driven environment. Work Location This role follows our hybrid work model of four days in-office and one remote day per week at our corporate headquarters in Bonita Springs, FL, to support collaboration with the Data & Analytics team. Note We are currently only considering candidates located within commuting distance of Bonita Springs, FL. Key Responsibilities Query and extract data from relational databases using SQL to support reporting and analysis requests. Clean, validate, and organize datasets from multiple sources to ensure accuracy and reliability. Build and maintain dashboards and reports using BI tools (Power BI or Tableau) for stakeholder use. Perform basic statistical analysis to identify trends, patterns, and anomalies in business data. Translate analytical findings into clear, actionable insights for non-technical audiences. Collaborate with cross-functional teams including marketing, operations, and products to align data outputs with business goals. Support ad hoc data requests and contribute to ongoing analytics projects. Leverage AI-assisted tools responsibly to accelerate reporting, summarize findings, and support data storytelling, while ensuring all outputs are validated for accuracy before sharing with stakeholders. Required Skills & Qualifications Technical Skills SQL - Comfortable writing queries involving SELECT, WHERE, JOIN, GROUP BY, and aggregations. Excel / Google Sheets - Proficient with pivot tables, VLOOKUP/XLOOKUP, and basic formulas. Data Visualization - Familiarity with Tableau or Power BI; ability to build clear, readable dashboards. Data Cleaning - Experience identifying and handling missing values, duplicates, and inconsistencies. Statistics Fundamentals - Understanding of mean, median, distributions, and correlation. Soft Skills Clear written and verbal communication skills, including the ability to explain data findings simply. Strong attention to detail and a methodical, structured approach to problem-solving. Intellectual curiosity and a genuine interest in working with data. Willingness to learn, take feedback, and grow in a fast-paced environment. Ability to ask good clarifying questions and collaborate with stakeholders effectively. Preferred Skills (Not Required) AI Literacy - Comfortable using AI-assisted tools (e.g., Copilot in Power BI, ChatGPT, or similar) to accelerate workflows such as writing queries, summarizing dashboards, and drafting reports; understands the importance of validating AI outputs for accuracy and applying responsible, ethical use standards. Exposure to cloud platforms such as Microsoft Azure/Fabric or AWS, Google Cloud. Python or R (Basic) - Able to perform data cleaning and simple analysis using Pandas or equivalent libraries. Experience with version control tools like Git. Experience using project management or documentation tools (Asna, Jira or SharePoint). Domain knowledge in retail, finance, healthcare, or technology. A portfolio of personal or academic projects (e.g., Kaggle notebooks, GitHub repos, dashboards). Education Bachelor’s degree in Analytics, Statistics, Computer Science, Business, or a related field is preferred. Equivalent practical experience will also be considered, including certifications (e.g., Google Data Analytics, IBM Data Analyst) and demonstrated hands‑on project work such as dashboards, portfolios, or GitHub repositories. Trusted family owned company in business for 60 years Collaborative, data-driven team culture with room to grow Medical, Dental, and Vision insurance Basic and supplemental life insurance 401(k) retirement savings plan Flexible Spending Account (FSA) and Health Savings Account (HSA) options Paid vacation and PTO Parental leave Wellness incentive program Employee discount program on merchandise Employment is contingent upon successful completion of a background check. CM Management Inc. is an Equal Opportunity Employer (EEO). #J-18808-Ljbffr City Mattress