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.
