Data Scientist

Bare Home • Full-time • Forest Lake, MN, US • $70k - $90k / year • 4d ago

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 Data Engineer, you'll serve as the technical backbone for our $100M+ bedding and mattress business, building and maintaining the data infrastructure that powers business decisions across our organization. This role requires a hands-on technical professional with strong SQL and Power BI expertise who can extract, transform, and manage large data files from various e-commerce marketplaces, internal Excel spreadsheets, and operational systems. You'll design efficient data pipelines, create impactful dashboards and reports, and ensure data accuracy across multiple platforms.

This position offers exceptional growth opportunities for an associate-level professional ready to take ownership of critical data engineering initiatives. You'll work alongside our analytics and forecasting team in a high-growth environment where your technical expertise directly impacts company performance. We're looking for someone who can hit the ground running within the first few months and has the drive to continuously expand their skills while helping teammates leverage data more effectively.

Key Responsibilities:

Data Pipeline & Infrastructure Development:

Build and maintain automated data pipelines that extract, transform, and load data from multiple e-commerce platforms (Amazon Seller Central, Shopify, direct website) into centralized reporting systems
Write advanced SQL queries to extract, manipulate, and analyze large datasets from multiple sources including marketplace APIs, internal databases, and operational systems
Design and implement data validation processes to ensure accuracy, consistency, and reliability across all data sources
Manage and optimize data storage solutions, including Excel-based data files and database structures, for performance and scalability
Support future ERP integration initiatives (NetSuite) as the company's data infrastructure evolves

Power BI Dashboard & Reporting Development:

Design, build, and maintain interactive Power BI dashboards that provide real-time visibility into business performance metrics
Create automated reporting frameworks that track KPIs across sales channels, inventory, operations, and marketing effectiveness
Develop DAX formulas and data models within Power BI to enable complex calculations and dynamic visualizations
Transform raw data into clear, actionable visualizations that communicate insights to stakeholders across all business functions
Maintain and improve existing Excel-based reporting while transitioning critical reports to Power BI platform

Data Management & Quality Assurance:

Establish and maintain data governance standards to ensure data integrity across 6,000+ SKUs and multiple sales channels
Perform data cleansing, deduplication, and standardization across disparate data sources
Monitor data pipelines for errors and proactively troubleshoot issues before they impact business operations
Document data processes, workflows, and system architectures for team knowledge sharing
Identify opportunities to automate manual data processes and improve operational efficiency

Cross-Functional Collaboration & Training:

Partner with analytics, forecasting, and business intelligence team members to understand data requirements and deliver technical solutions
Assist in training other team members on how to leverage data tools, query databases, and interpret reports
Translate technical data concepts into business-friendly language for non-technical stakeholders
Support ad-hoc data requests and special projects requiring data extraction, transformation, or analysis
Collaborate across departments to ensure data consistency and support data-driven decision-making

Qualifications & Experience:

Required Experience:

Bachelor's degree in Computer Science, Information Systems, Data Science, Mathematics, Statistics, or related technical field – Equivalent combination of education and demonstrated technical skills will be considered
2-4 years of experience working with SQL, Power BI, and large datasets in a professional or academic setting – strong skills are prioritized over years of experience
Demonstrated ability to work with data from multiple e-commerce platforms and integrate disparate data sources
Strong understanding of e-commerce and retail data structures, including sales transactions, inventory data, and marketplace reporting
Track record of building reports, dashboards, or data solutions that solved real business problems
Self-motivated learner with proven ability to quickly master new systems, programs, and technical tools

Technical Skills – Must Have:

Advanced SQL proficiency including complex queries, joins, subqueries, aggregations, CTEs, window functions, and performance optimization for large datasets
Power BI expertise for dashboard creation, data visualization, DAX formula development, data modeling, and automated report generation
Expert-level Excel skills including advanced formulas (VLOOKUP, INDEX-MATCH, SUMIFS, array formulas), pivot tables, Power Query, and macro development for data automation
Strong understanding of data structures, database design principles, and ETL (Extract, Transform, Load) processes
Ability to work with APIs and data feeds from e-commerce platforms (Amazon, Shopify, etc.)
Experience managing and processing large data files (100K+ rows) while maintaining performance and accuracy

Note: Applicants may be asked to complete a technical assessment on SQL, Power BI, and Excel skills during the on-site interview process.

Nice to Have:

Experience with ERP systems (NetSuite is a plus)
Familiarity with Python or other scripting languages for data automation
Knowledge of cloud data platforms or data warehousing concepts
Experience with version control systems (Git)

What Makes You Successful:

Strong work ethic with ownership mentality and commitment to delivering high-quality, accurate work
Quick learner who can rapidly adapt to new systems, tools, and business processes with minimal hand-holding
Problem-solving mindset with ability to think critically and develop efficient solutions to complex data challenges
Attention to detail with commitment to ensuring data accuracy and identifying discrepancies in large, complex datasets
Collaborative nature with ability to work effectively alongside other analysts and team members while also contributing to their technical growth
Clear communicator who can explain technical concepts to non-technical colleagues and document processes for knowledge sharing
Adaptable and flexible in a fast-paced environment where priorities shift and new challenges emerge regularly
Self-starter who proactively identifies opportunities for improvement and takes initiative without constant direction

Work Environment:

Collaborative, entrepreneurial culture where your technical contributions quickly become business impact
Direct access to leadership with high visibility across the organization
Fast-paced environment where data infrastructure supports real business decisions and strategic direction
Work alongside experienced analytics and forecasting professionals
Small company atmosphere requiring flexibility, cross-functional thinking, and willingness to wear multiple hats
Opportunities to expand your skills into new areas and help shape the company's data strategy as we continue to grow

Compensation & Benefits:

Competitive salary: $70,000 to $90,000 (based on experience and demonstrated skills)
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 SQL, Power BI, and Excel experience with specific examples of data projects and technical solutions
Brief cover letter describing your approach to solving complex data problems and your experience working with e-commerce or retail data
Examples or descriptions of dashboards, reports, or data pipelines you've built (portfolio links welcome but not required)

Submit your application to: mfreeman@barehome.com or wyeargan@barehome.com

Come see us: https://barehome.com/

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.