JOB DETAILS

Data Engineer

CompanyScentsy Inc
LocationMeridian
Work ModeOn Site
PostedJune 18, 2026
About The Company
Simplicity. Authenticity. Generosity. Scentsy has flourished from a small family operation to a thriving international company and a leader in the direct selling industry. But some things haven't changed. We still hold true to our core values and a dedication to contribute more than we take in our relationships with our Consultants, customers and the communities in which we live and work. At Scentsy, we're a family. We're honest and hardworking and real. We offer each other support and strive to give anyone who wants to enhance their life the best opportunity to do it. The basis for Scentsy Family's business philosophy comes from a quote by Albert Einstein — a quote that so inspired Orville Thompson as a young man he kept it posted on his bedroom wall: "Try not to become a man of success. Rather, become a man of value. A successful man takes out of life more than he puts in. A man of value will give more than he receives."​ When they launched Scentsy, the Thompsons determined from the beginning to build their business around core values of Simplicity, Authenticity and Generosity. Those key values extend to everything we do. By choosing to interact on our Scentsy Corporate social media accounts, you are agreeing to abide by our Social Media Community Guidelines: https://bit.ly/3z32enQ.
About the Role

Description

Scentsy is looking for a Data Engineer to ensure the availability, reliability, and performance of data infrastructure and analytical systems. This role pairs deep data engineering expertise with strong development capabilities, designing and building data products on AWS, S3, and other cloud data warehouse technologies.


This job is worked 100% of the time in-office at our Meridian, ID corporate office.

*Please note: We are unable to provide H-1B visa work sponsorship for this position.


What You'll Do:

  • Serve as part of our Data Engineering and Analytics team providing data analytics capabilities for various internal Scentsy business partners
  • Influence and evangelize analytical methodologies to support business partners’ needs
  • Act as a technical lead for designing and implementing custom reports and dashboards 
  • Assess requirements and assist with developing data warehouse infrastructure 
  • Confer with the immediate team on warehouse operational issues and recommend resolutions
  • Interface with data analysts to define and implement data requirements to meet their analytic needs 
  • Participate in the design and build of conceptual, logical, and physical data models to support business analytics from the data warehouse
  • Recommend data strategies, ETL processes, and procedures for getting data in and out of the data warehouse 
  • Design, develop, and deploy data pipelines, integrations, and automation solutions, applying sound software engineering practices across the development lifecycle
  • Test reporting solutions and provide training
  • Interact with technical resources from various teams within the Information Systems and Information Technology departments to define and test technical changes to the system
  • Design and implement custom reports and dashboards
  • Translate analytical program models, including but not limited to scripting, error handling, and documentation 
  • Work with users from various functional areas (sales, order processing, shipping, logistics, credit, finance, marketing, etc.)
  • Analyze processes ensuring sustainability, supportability, and automation
  • Identify new data from additional internal or 3rd party systems and transform it to work cohesively within existing Data Warehousing models
  • Participate in evaluating new technologies to ensure data and technology architecture advancement within the organization’s BI needs
  • Identify development needs to improve and streamline business operations
  • Provide stakeholders with quality data so the business can make sound, data-driven decisions and recommendations
  • Coach and mentor less experienced engineers
  • Perform all other assigned tasks and requirements as needed

We're Looking For:

  • Bachelor’s degree in business, Business Intelligence, Data Warehouse or data related field or equivalent related experience
  • 5 years of data warehouse engineering experience and/or 3 years of Business Intelligence experience
  • Significant knowledge of best practices for data modeling, dimensional modeling (Star schema), data ingestion, queries, and data loading options
  • Wide experience of cloud data warehousing tools and technologies such as Snowflake and RedShift
  • Significant experience with BI tools such as AWS QuickSight, Power BI, R, Python, SAP Business Objects and Web Intelligence (WEBI) reporting tools
  • Experience with AWS Services like AWS Quick, Cloud Formation, S3, Glue, State Machine, Lambda, Event Bridge, SNS and Appflow.
  • Excellent data manipulation and analysis skills
  • Experience in data access and delivery technologies, including familiarity with data quality assessment, data organization, metadata, and data profiling
  • Ability to take complex, ambiguous problems, break them down into smaller parts, and problem solve to come up with a whole, integrated, and strategic solution
  • Excellent skills in SQL, data modeling, data warehousing, and OLAP
  • Strong solution development capabilities, including the ability to design, build, test, and deploy production-quality code and automation
  • Excellent written and oral communication skills
  • Experience with SAP systems including table structure, field definitions, CDS views and usage, a plus
  • Experience with git
  • Advanced critical thinking, problem solving, and analytical skills
  • Familiarity with Agile Framework
  • Experience with Redgate Flyway



Key Skills
Data ModelingETLSQLAWSSnowflakeRedshiftPythonPower BIAWS QuickSightData WarehousingOLAPAgileGitSAPData PipelinesDimensional Modeling
Categories
Data & AnalyticsTechnologyEngineeringSoftware
Job Information
📋Core Responsibilities
Design, build, and maintain data infrastructure and pipelines on AWS to support business analytics and reporting. Collaborate with stakeholders to translate business requirements into technical data models and dashboards.
📋Job Type
full time
📊Experience Level
5-10
💼Company Size
4868
📊Visa Sponsorship
No
💼Language
English
🏢Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page