Retail Business Analyst

About Us

At J.Jill, we believe our associates should be seen, valued, and celebrated. We support the advancement of our associates by harnessing their unique contributions to grow and improve, and our success is guided by a culture that values keeping it simple and making it matter. J.Jill is an equal opportunity employer and is committed to providing an inclusive and professional workplace free from discrimination and harassment.

All employment decisions at J.Jill are based solely upon business needs, job requirements and individual qualifications without regard to race, color, religion, sex, pregnancy and pregnancy related conditions, gender identity, gender expression, national origin, sexual orientation, sexual and reproductive health decisions, age, marital status, disability, genetic information, military or veteran status or any other legally protected status.

J.Jill provides reasonable accommodation to qualified individuals, in accordance with applicable laws. If you need to inquire about an accommodation to assist with completing the application process, please emai

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.

• 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, Tailored for You.

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

• Advanced 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…