Retail Business Analyst

J.Jill • Quincy, MA

48d • $75,000 - $85,000

About The Position

The 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.

Requirements

• Advanced SQL skills required
• 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.
• 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).
• Ability to manage multiple assignments and consistently meet deadlines.
• 3+ years of business experience in an analytical or technical role.
• Advanced Excel and SQL skills required.

Nice To Haves

• experience with statistical predictive analytics tools like R and Python preferred.
• Experience with BI tools (e.g., Qlik Sense, Power BI, or Tableau) preferred.
• Exposure to retail metrics (sales, inventory, UPT, conversion rates, etc.) preferred.
• 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.

Responsibilities

• Builds 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, evalution 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.

Benefits

• 401(k) retirement plan with discretionary match and tuition reimbursement.
• Medical, dental, vision, company paid LTD/STD, and generous amount of paid time off.
• Generous associate discount; group discounts on auto, pet and homeowner insurance.
• Discount Marketplace for travel, consumer products, food, auto buying, etc.
• Associate resource groups.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level