Senior Business Analyst

About Us

JP Ecommerce has been named one of the top-ten fastest-growing businesses in Minnesota by Inc. 5000 for the past
four years in a row
. We provide customers with high-quality bedding through our brand Bare Home. As a $100M e-commerce textile company, we source premium products from China, India, Pakistan, and Turkey while also manufacturing cotton products in the USA.

We've grown from a small startup to a team of 87 employees, and we're continuing to expand as we scale our operations to support 30% year-over-year growth. Our collaborative, entrepreneurial culture means your analytical work directly impacts business decisions across finance, operations, pricing, and supply chain.

Position Overview

We're adding a second
Senior Business Analyst
to support our rapid growth and data-driven decision making. This role requires someone who can hit the ground running with
advanced Power BI and SQL skills
to build dashboards, analyze complex multi-channel pricing strategies, and provide financial insights around COGS, landed costs, and profitability optimization.

You'll work with messy, multi-source data across 18 websites and 7,000 SKUs, transforming it into clean, actionable insights. This isn't a role where you'll wait for perfect data—you'll dig in, troubleshoot, clean it up, and build solutions that make the business more efficient.

What You'll Do

Analytics & Reporting

• Design and build interactive Power BI dashboards that drive business decisions across the organization
• Write and optimize SQL queries to extract, transform, and clean data from multiple sources
• Troubleshoot data integrity issues and automate reporting processes to eliminate manual work
• Create executive-level presentations with clear insights and actionable recommendations

Financial Analysis

• Analyze pricing strategy across 18 websites and 7,000 SKUs while maintaining channel agreements (e.g., Amazon MAP compliance)
• Calculate and track COGS, landed costs, tariff impacts, and shipping cost variations to optimize profitability
• Build financial models for forecasting, margin analysis, and scenario planning
• Support sourcing decisions by analyzing cost implications of tariffs, shipping routes, and supplier changes

Cross-Functional Partnership

• Partner with finance, supply chain, sourcing, and marketing teams to deliver data-driven recommendations
• Translate business questions into analytical solutions
• Present findings to leadership in ways that drive action

What You Need

Must-Haves

• Bachelor's degree
  in Finance, Accounting, Business Analytics, Economics, or related field
• 4-7 years of hands-on experience
  in business analytics, financial analysis, or FP&A roles
• Advanced Power BI skills
  : dashboard design, DAX, data modeling—you build solutions, not just reports
• Strong SQL proficiency
  : query writing, data extraction, database management
• Solid financial understanding
  : COGS, landed costs, margin analysis, pricing strategy
• Advanced Excel skills
  : pivot tables, financial modeling, complex formulas
• Experience in e-commerce, retail, or manufacturing environments
• Proven ability
  to work with large, complex datasets from multiple systems

Highly Valued

• Experience with multi-channel e-commerce pricing strategies and marketplace dynamics (Amazon, Walmart, Target)
• Understanding of international supply chain costs, tariffs, and duty calculations
• Background in costing, pricing analytics, or FP&A
• Experience with ERP systems (
  NetSuite experience a plus
  )
• Finance or accounting experience (CPA/CFA helpful but not required)
• Track record of building analytics solutions that delivered measurable business impact

Compensation & Benefits

Salary:
$95,000 - $115,000 (based on experience and skill set)

Comprehensive Benefits Package:

• Medical, Dental, and Vision Insurance
• Short-Term Disability (at no cost to employees)
• Life Insurance starting at $25,000 (at no cost to employees, with option to purchase additional coverage)
• Paid Family and Medical Leave Act (PFMLA) - Paid Maternity and Paternity Leave
• 401(k) Retirement Plan with Company Match
• Paid Time Off and Holidays
• Career advancement opportunities in rapidly growing company

Location & Requirements

This position is 100% on-site
at our Forest Lake/Columbus, Minnesota headquarters. Standard hours are Monday-Friday, 8:00 AM-4:30 PM with some flexibility based on business needs.

We are only considering candidates who:

• Currently live in Minnesota or the immediate surrounding area
• Can reliably commute to our Forest Lake/Columbus location daily
• Are available for in-person interviews at our office

Application Process

To be considered for this opportunity, please submit:

• Resume highlighting your Power BI, SQL, and financial analysis experience with specific examples of analytical projects and business impact in e-commerce or retail environments
• Cover letter explaining your experience with cost analysis, pricing strategy, and why you're excited about this growth opportunity

Submit your application to:
or

Visit us:

At Bare Home, we strive to create a culture where all people come first. We are committed to attracting and retaining a diverse workforce. Therefore, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Bare Home is an equal-opportunity employer, and by doing so, we aim to sustain and promote an inclusive culture that supports future growth for all.

Salary : $95,000 - $115,000