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 performanceCreate interactive visualizations and reporting solutions that communicate complex data insights to stakeholders across all business functionsDevelop automated reporting frameworks that track KPIs across financial performance, operations, marketing effectiveness, and channel productivityMonitor and report on marketing campaign effectiveness across 18+ marketing platforms with detailed ROI analysis and attribution modelingSupport multi-channel operational analysis including channel profitability, fulfillment performance, and resource allocation optimizationFinancial & Operational Analytics :
Analyze financial performance including revenue, margins, COGS trends, and P&L impact across product lines and sales channelsSupport budgeting, forecasting, and financial planning processes with accurate data analysis and predictive insightsTrack and report on supply chain and inventory metrics including stock levels, turnover rates, aging analysis, and procurement efficiencyEvaluate operational performance across warehousing, fulfillment, and logistics with data-driven recommendations for process improvementsConduct profitability analysis by channel, product category, SKU, and market segment to inform strategic resource allocationCross-Functional Collaboration :
Partner with finance, operations, inventory, procurement, marketing, and sales teams to understand analytical needs and deliver actionable insightsTranslate business questions into analytical frameworks and data requirements while ensuring alignment with organizational objectivesPresent complex analytical findings to leadership teams with clear, actionable recommendations that drive decision-makingCollaborate across departments to ensure data accuracy, consistency, and integrity in all reporting and analysisSupport ad-hoc analytical requests and special projects that require deep-dive investigation and data explorationQualifications & 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 considered3-7 years of business analyst, data analyst, or business intelligence experience with progressive responsibility in analytical rolesProven track record of delivering high-impact analytical solutions that drove measurable business improvements and strategic decisionsStrong understanding of ecommerce and retail business models including multi-channel operations, marketplace dynamics, and online retail metricsExperience analyzing financial statements, P&L impact, profitability metrics, and business performance indicatorsDemonstrated ability to work in fast-paced, dynamic environments where priorities shift and flexibility is essentialTechnical 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 reportingAdvanced SQL skills for data extraction, complex queries, joins, subqueries, aggregations, and database manipulation across multiple data sourcesPower BI expertise for dashboard creation, data visualization, DAX formulas, data modeling, and interactive reporting solutionsStrong understanding of data integrity, validation techniques, and troubleshooting data quality issues across multiple systemsAbility to integrate and analyze data from multiple marketing platforms and operational systems to create comprehensive business viewsNote : 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 interviewBusiness Acumen & Analytical Capabilities :
Deep understanding of ecommerce and retail business operations including sales channels, fulfillment, customer acquisition, and revenue modelsStrong knowledge of supply chain metrics, inventory management principles, and operational KPIs that drive business efficiencySolid grasp of financial concepts including revenue recognition, margin analysis, COGS, landed costs, and profitability calculationsAnalytical mindset with ability to identify patterns, trends, and anomalies in complex datasets and translate findings into business recommendationsExperience with business process analysis and ability to understand how different functions interconnect to drive overall business performanceWhat Makes You Successful :
Versatile analytical mindset with ability to seamlessly shift between financial analysis, operational metrics, marketing performance, and supply chain analyticsStrong business acumen balanced with technical excellence to connect data insights directly to business outcomes and strategic prioritiesExceptional attention to detail with ability to ensure accuracy and identify discrepancies in large, complex datasets across multiple systemsSelf-starter mentality with ownership mindset and ability to work independently while proactively identifying opportunities for improvementWork Environment :
Collaborative, entrepreneurial culture where your ideas quickly become actionDirect access to leadership with high visibility and impact across the organizationFast-paced environment where analytical insights drive real business decisions and strategic directionSmall company atmosphere requiring flexibility, cross-functional thinking, and ability to wear multiple hatsCompensation & Benefits :
Competitive salary : $75,000 to $95,000 (based on a Experience)Medical, Dental, and Vision InsuranceSTD and Life Insurance401(k) with Company MatchPaid Time Off and HolidaysApplication Process :
Location & Interview Requirements :
We do not provide relocation assistance or relocation packagesOur interview process is conducted in-person at our office locationWe are unable to accommodate remote or virtual interviews as part of our standard processIf you require a reasonable accommodation due to a disability during the application or interview process, please contact us to discuss available optionsTo be considered for this opportunity, please submit :
Detailed resume highlighting Excel, SQL, and Power BI experience with specific examples of analytical projects and business impactBrief cover letter describing your approach to solving complex business problems through data analysis and your understanding of ecommerce / retail operationsExamples or descriptions of dashboards, reports, or analytical frameworks you've built (portfolio links welcome but not required)Submit your application to : or
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.