Job Description

Business Analyst

Bare Home | Forest Lake, Minnesota, United States (On-site)

About Us:

JP Ecommerce (dba Bare Home) 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 leading textile retail company, we source premium products from key regions including China, India, Pakistan, and Turkey. Our commitment to excellence has earned us a reputation as an industry leader in sustainable and ethical textile sourcing.

Position Overview:

As a Business Analyst , you'll serve as a critical data intelligence resource for our $100M+ bedding and mattress business, transforming complex data into actionable insights that drive strategic decisions across all business functions. This role requires a versatile analytical professional with exceptional Excel, SQL, and Power BI expertise who can analyze business performance across financial operations, supply chain management, multi-channel ecommerce, and marketing effectiveness. You'll design and maintain sophisticated dashboards and reports while providing data-driven recommendations that directly impact profitability.

This position offers exceptional growth opportunities for an experienced analyst ready to take ownership of critical business intelligence initiatives in a high-growth environment where your analytical expertise shapes strategic business decisions and drives company performance.

Key Responsibilities:

Advanced Analytics & Data Intelligence:

• Build and maintain complex Excel models, financial analysis tools, and automated reporting frameworks for business performance tracking
• Write advanced SQL queries to extract, transform, and analyze data from multiple databases including ecommerce platforms, marketing systems, and operational data sources
• Develop comprehensive analytical frameworks to measure and optimize business performance across 6,000+ SKUs and multiple sales channels
• Conduct detailed analysis of business metrics including revenue trends, margin analysis, operational efficiency, and performance variance identification

Multi-Platform Business Intelligence & Dashboard Development:

• Design, build, and maintain executive and operational dashboards using Power BI that provide real-time visibility into business performance
• Create interactive visualizations and reporting solutions that communicate complex data insights to stakeholders across all business functions
• Develop automated reporting frameworks that track KPIs across financial performance, operations, marketing effectiveness, and channel productivity
• Monitor and report on marketing campaign effectiveness across 18+ marketing platforms with detailed ROI analysis and attribution modeling
• Support multi-channel operational analysis including channel profitability, fulfillment performance, and resource allocation optimization

Financial & Operational Analytics:

• Analyze financial performance including revenue, margins, COGS trends, and P&L impact across product lines and sales channels
• Support budgeting, forecasting, and financial planning processes with accurate data analysis and predictive insights
• Track and report on supply chain and inventory metrics including stock levels, turnover rates, aging analysis, and procurement efficiency
• Evaluate operational performance across warehousing, fulfillment, and logistics with data-driven recommendations for process improvements
• Conduct profitability analysis by channel, product category, SKU, and market segment to inform strategic resource allocation

Cross-Functional Collaboration:

• Partner with finance, operations, inventory, procurement, marketing, and sales teams to understand analytical needs and deliver actionable insights
• Translate business questions into analytical frameworks and data requirements while ensuring alignment with organizational objectives
• Present complex analytical findings to leadership teams with clear, actionable recommendations that drive decision-making
• Collaborate across departments to ensure data accuracy, consistency, and integrity in all reporting and analysis
• Support ad-hoc analytical requests and special projects that require deep-dive investigation and data exploration

Qualifications & Experience:

Required Experience:

• Bachelor's degree in Business Analytics, Information Systems, Finance, Economics, Business, Statistics, or related quantitative field - Equivalent combination of education and experience will be considered
• 3-7 years of business analyst, data analyst, or business intelligence experience with progressive responsibility in analytical roles
• Proven track record of delivering high-impact analytical solutions that drove measurable business improvements and strategic decisions
• Strong understanding of ecommerce and retail business models including multi-channel operations, marketplace dynamics, and online retail metrics
• Experience analyzing financial statements, P&L impact, profitability metrics, and business performance indicators
• Demonstrated ability to work in fast-paced, dynamic environments where priorities shift and flexibility is essential

Technical Skills* - Must Have:

• Expert-level Excel proficiency including advanced formulas (VLOOKUP, INDEX-MATCH, SUMIFS), pivot tables, complex financial modeling, data manipulation, and macro development for automated reporting
• Advanced SQL skills for data extraction, complex queries, joins, subqueries, aggregations, and database manipulation across multiple data sources
• Power BI expertise for dashboard creation, data visualization, DAX formulas, data modeling, and interactive reporting solutions
• Strong understanding of data integrity, validation techniques, and troubleshooting data quality issues across multiple systems
• Ability to integrate and analyze data from multiple marketing platforms and operational systems to create comprehensive business views

*Note: Applicants may be asked to take a short test on any of the follow areas of Excel, Power BI, and SQL skills on the day of the on-site interview

Business Acumen & Analytical Capabilities:

• Deep understanding of ecommerce and retail business operations including sales channels, fulfillment, customer acquisition, and revenue models
• Strong knowledge of supply chain metrics, inventory management principles, and operational KPIs that drive business efficiency
• Solid grasp of financial concepts including revenue recognition, margin analysis, COGS, landed costs, and profitability calculations
• Analytical mindset with ability to identify patterns, trends, and anomalies in complex datasets and translate findings into business recommendations
• Experience with business process analysis and ability to understand how different functions interconnect to drive overall business performance

What Makes You Successful:

• Versatile analytical mindset with ability to seamlessly shift between financial analysis, operational metrics, marketing performance, and supply chain analytics
• Strong business acumen balanced with technical excellence to connect data insights directly to business outcomes and strategic priorities
• Exceptional attention to detail with ability to ensure accuracy and identify discrepancies in large, complex datasets across multiple systems
• Self-starter mentality with ownership mindset and ability to work independently while proactively identifying opportunities for improvement

Work Environment:

• Collaborative, entrepreneurial culture where your ideas quickly become action
• Direct access to leadership with high visibility and impact across the organization
• Fast-paced environment where analytical insights drive real business decisions and strategic direction
• Small company atmosphere requiring flexibility, cross-functional thinking, and ability to wear multiple hats

Compensation & Benefits:

• Competitive salary: $75,000 to $95,000 (based on a Experience)
• Medical, Dental, and Vision Insurance
• STD and Life Insurance
• 401(k) with Company Match
• Paid Time Off and Holidays

Application Process:

Location & Interview Requirements:

• We do not provide relocation assistance or relocation packages
• Our interview process is conducted in-person at our office location
• We are unable to accommodate remote or virtual interviews as part of our standard process
• If you require a reasonable accommodation due to a disability during the application or interview process, please contact us to discuss available options

To be considered for this opportunity, please submit:

• Detailed resume highlighting Excel, SQL, and Power BI experience with specific examples of analytical projects and business impact
• Brief cover letter describing your approach to solving complex business problems through data analysis and your understanding of ecommerce/retail operations
• Examples or descriptions of dashboards, reports, or analytical frameworks you've built (portfolio links welcome but not required)

Submit your application to: [email protected] or [email protected]

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

Job Tags

Similar Jobs