Experienced Full Stack Business Analyst – Merchandise Planning and Analytics for Retail Operations at Blithequark

Join Blithequark as a Remote Business Analyst and Drive Retail Excellence Blithequark, a global leader in retail pharmacy, is seeking a highly skilled and detail-oriented Business Analyst to join our Merchandise Planning Analytics team on a 6-month contract with the opportunity for extension or conversion. As a Remote Analyst, you will play a critical role in supporting our Merchandising team by managing reporting, analysis, and tool building to optimize performance across our Front End (non-Pharmacy) businesses. About Blithequark and Our Industry Blithequark operates in the dynamic retail pharmacy sector, where data-driven insights are crucial for driving business success. Our Merchandise Planning Analytics team is at the forefront of this effort, working closely with merchants and planners to analyze sales trends, optimize inventory levels, and develop strategies to enhance customer experience. By joining our team, you will have the opportunity to work with a talented group of professionals who are passionate about using data to drive business outcomes. Work Environment We offer a flexible, 100% remote work arrangement for this role, requiring you to work in Central Standard Time (CST). Your schedule will be 8am-5pm, with a one-hour lunch break from 12pm-1pm. While there is some flexibility in your hours, you will need to work a minimum of 30 hours per week to meet business needs. Key Responsibilities Develop and maintain comprehensive reports, analyses, and tracking for Own Brand (private label) products, including ad-hoc analysis based on business requirements. Conduct item-level historical analysis and recapping to inform business decisions. Create item-level future-looking forecasts to support strategic planning. Work with thousands of Own Brand items at the item level, using Excel as the primary system/tool. Apply complex Excel formulas and synthesize large data sets into meaningful executive recaps. Collaborate with Merchandising, Planning, Finance, and other stakeholders to develop effective working relationships. Manage and prioritize multiple assignments, meeting tight deadlines while maintaining high-quality work. Work independently and adapt to changing work priorities in a fast-paced environment. Essential Qualifications and Skills To succeed in this role, you will need: A Bachelor's Degree in a relevant field such as analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising. At least 3-5 years of experience in analytics, data science, or a related field, with a strong understanding of retail merchandising basics and organization structures and processes. Outstanding analytical and problem-solving skills, with the ability to communicate complex insights effectively. Proficiency in Microsoft Excel, with intermediate to advanced skills in using formulas (SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP), Macros, and Pivot tables. Excellent verbal and written communication skills, with experience using Microsoft PowerPoint. Ability to manage multiple assignments, prioritize tasks, and meet deadlines. Retail math background, with skills such as item-level forecasting based on demand patterns or sell-through/sales/profit goals. Preferred Qualifications and Skills While not required, the following skills and qualifications are highly desirable: MBA or a degree in Science, Technology, Engineering, Mathematics (STEM), or a related quantitative analytical field. Experience in data science, retail, or a related industry. SQL coding, Microsoft Access, or macro building skills. Career Growth Opportunities and Learning Benefits At Blithequark, we are committed to the growth and development of our employees. As a Business Analyst, you will have the opportunity to: Work with a talented team of professionals who are passionate about using data to drive business outcomes. Develop your analytical and problem-solving skills, with access to training and resources to support your growth. Contribute to strategic planning and decision-making, with a focus on driving business excellence. Enhance your communication and collaboration skills, working with cross-functional teams across the organization. Work Environment and Company Culture At Blithequark, we value flexibility, innovation, and teamwork. Our remote work arrangement allows you to work from anywhere, while our collaborative culture encourages open communication and idea-sharing. We offer: A dynamic, fast-paced work environment that is both challenging and rewarding. Opportunities for professional growth and development, with a focus on employee success. A culture that values diversity, equity, and inclusion, with a commitment to creating a workplace where everyone can thrive. Compensation, Perks, and Benefits We offer a competitive compensation package, with perks and benefits that support your well-being and success. These may include: Competitive salary and benefits package. Opportunities for professional development and growth. Flexible work arrangements, including remote work options. Access to cutting-edge technology and tools. Conclusion If you are a motivated and detail-oriented Business Analyst with a passion for retail and data analysis, we encourage you to apply for this exciting opportunity at Blithequark. As a Remote Analyst, you will play a critical role in driving business excellence and optimizing performance across our Front End (non-Pharmacy) businesses. Join our team and contribute to our mission of delivering exceptional customer experiences through data-driven insights. Apply now to take the first step towards a rewarding career at Blithequark! Apply for this job