Retail Business Analyst

Business AnalystThe Business Analyst partners with cross-functional teams across J.Jill, including Real Estate, Marketing, Retail Operations, and Merchandising, to provide data-driven insights that support strategic business decisions. This role performs end-to-end business analysis by translating business questions into actionable recommendations through SQL queries, Excel spreadsheets, and data visualization. The Business Analyst evaluates business performance, analyzes A/B testing results, develops automated reporting solutions using BI tools such as Qlik Sense and Databricks AI/BI, and presents findings through clear, impactful presentations and reports. Additionally, the role supports real estate strategy by developing sales forecasts for new store locations, closures, and transfers to help drive profitable growth.ResponsibilitiesBuilds partnerships and operates cross functionally to provide analytical decision support to leaders to increase revenue and profit of various initiatives.Takes an active role in conception, design, execution, and analysis of corporate-wide testing activities.Understands key performance indicators that drive company results and determines how these metrics track against overall business strategies, goals and objectives.Takes initiative acting as a subject matter expert on analytics, quantification, and process automation and provides advanced analytics to support longer-range plans and initiatives.Provides recommendations for improvements to tools, scorecards, KPIs & benchmarks.Performs end-to-end business analytics: 1) Understands business question 2) Structures Excel spreadsheet 3) Builds accurate SQL queries (validating results) 4) Summarizes analytical insights and business recommendations into a PowerPoint deck and/or email.Performs data analysis tasks, evaluation of A/B Tests, etc. to develop recommendations that will improve decision making across the organization.Develops automated self-service business reporting through BI tools including Qlik Sense and Databricks AI/BI.Calculates sales estimates for potential new store locations as well as store closure and store transfer estimates for existing stores.QualificationsAdvanced SQL skills required; experience with statistical predictive analytics tools like R and Python preferred.Natural analytical curiosity is essential.Must demonstrate attention to detail and accuracy, a high degree of organization, and have pride in work.Desire to continuously learn, ability to learn quickly and confidence to ask questions to gain clarity are required.Strong aptitude with MS Office tools, especially advanced Excel skills.Experience with BI tools (e.g., Qlik Sense, Power BI, or Tableau) preferred.Self-motivated with an ability to both work independently as well as collaboratively across functions and business areas.Ability to not only retrieve and report data, but to also analyze the implications and make recommendations on various key business questions.Excellent written and verbal communication/follow-up skills (follow up with project partners to ensure accurate and timely completion of deliverables).Exposure to retail metrics (sales, inventory, UPT, conversion rates, etc.) preferred.Ability to manage multiple assignments and consistently meet deadlines.Education & Experience:3+ years of business experience in an analytical or technical role.Advanced Excel and SQL skills required.Statistical analysis and predictive modeling (R, Python) experience preferred.Reporting and analysis experience in a retail environment preferred.Bachelor's degree in business or quantitative discipline (statistics, math) preferred.The above statements are intended to describe the general nature and level of work being performed by associates assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of this position.Our BrandAt J.Jill, we're redefining what it means to dress and live with ease. As a women-led, Boston-based lifestyle brand with 200+ stores nationwide, we design thoughtful, inspired apparel and accessories that celebrate the totality of all women. We're entering an exciting chapter of growth — expanding our footprint, reaching new customers, and deepening long-standing relationships. We're seeking bold thinkers and doers to join us. With competitive pay and benefits, a supportive culture, and the chance to make a real impact, this is more than a job, it's an opportunity to bring our ethos keep it simple, make it matter to life in new and inspiring ways.