**Experienced Data Entry Clerk / Remote Analyst – Retail Pharmacy Analytics**

At arenaflex, we're a global leader in retail pharmacy, and we're looking for a talented and detail-oriented Remote Analyst to join our Merchandise Planning Analytics team. As a key member of our team, you'll play a crucial role in managing reporting, analysis, and tool building for our Merchandising team, supporting over 100 merchants and 40 planners to optimize performance of our Front End (non-Pharmacy) businesses.

• *About arenaflex**

arenaflex is a dynamic and innovative company that's dedicated to providing exceptional customer experiences and delivering high-quality products and services. Our team is passionate about making a difference in the lives of our customers, and we're committed to fostering a culture of collaboration, creativity, and continuous learning.

• *Work Environment**

As a Remote Analyst, you'll have the flexibility to work from anywhere in the CST time zone, with a 9-hour day (8am-5pm) and a 1-hour lunch break (12pm-1pm). While the hours can be flexible, you'll need to commit to a minimum of 30 hours per week to fulfill the business needs. This is a 6-month contract with the opportunity for extension or conversion, offering a unique chance to grow your skills and experience in a fast-paced and dynamic environment.

• *Responsibilities**

As a Remote Analyst, you'll be responsible for:

• **Own Brand Reporting**: Own and manage reporting, recapping, tracking, and analysis for thousands of Own Brand items, including ad-hoc analysis based on business needs.
• **Item Level Historical Analysis**: Conduct item level historical analysis and recapping to identify trends and patterns.
• **Item Level Future Looking Forecast**: Develop item level future looking forecasts to inform business decisions.
• **System/Tool Used**: Utilize Microsoft Excel to analyze and synthesize large data sets into meaningful executive recaps.
• **Complex Excel Formulas**: Develop and apply complex Excel formulas to extract insights from data.
• **Project Scope**: Manage a project scope of thousands of Own Brand items, with a focus on item level analysis.

• *Top Must-Have Skills**

To succeed in this role, you'll need:

• **Bachelor's Degree**: A Bachelor's degree in a relevant field, such as analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising.
• **3-5 Years of Experience**: At least 3-5 years of experience in analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising.
• **Analytical and Problem-Solving Skills**: Outstanding analytical and problem-solving skills, with the ability to synthesize complex data into actionable insights.
• **Retail Math Background**: A strong understanding of retail math, including item level forecasting, demand patterns, sell through/sales/profit goals, sales by type, and AUR impacts.
• **Microsoft Excel Skills**: Intermediate/Advanced level skills in Microsoft Excel, including SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, and Pivot tables.
• **Communication Skills**: Ability to communicate effectively and succinctly both verbally and in writing, using Microsoft PowerPoint.

• *Top Nice-to-Have Skills**

While not essential, the following skills would be beneficial:

• **MBA**: An MBA or a degree in a quantitative analytical field, such as Science, Technology, Engineering, and Mathematics (STEM).
• **Data Science Experience**: Experience in data science, including data analysis, machine learning, and data visualization.
• **Retail Experience**: Experience in retail, including merchandising, assortment planning, and inventory management.
• **SQL Coding**: Knowledge of SQL coding and experience with Microsoft Access.
• **Macro Building**: Experience in building macros and automating tasks in Microsoft Excel.

• *Education / Experience Requirements**

To be considered for this role, you'll need:

• **3-5 Years of Experience**: At least 3-5 years of experience in analytics or data science, with a background in merchandising.
• **Bachelor's Degree**: A Bachelor's degree in a relevant field, such as analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising.

• *What We Offer**

As a Remote Analyst at arenaflex, you'll have the opportunity to:

• **Grow Your Skills**: Develop your skills and experience in a fast-paced and dynamic environment.
• **Work Remotely**: Enjoy the flexibility of working from anywhere in the CST time zone.
• **Collaborate with a Talented Team**: Join a team of talented and dedicated professionals who are passionate about making a difference in the lives of our customers.
• **Enjoy Competitive Compensation and Benefits**: Receive competitive compensation and benefits, including a comprehensive benefits package and opportunities for career growth and development.

• *How to Apply**

If you're a motivated and detail-oriented individual with a passion for analytics and data science, we encourage you to apply for this exciting opportunity. Please submit your application through our website, including your resume, cover letter, and any relevant certifications or credentials. We can't wait to hear from you!