Business Analyst Sql R Python Jobs in Franklin, MA

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 email Talent.Acquisition@jjill.com.

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

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