Scentsy is looking for a Data Engineer to provide innovative modernization and ensure the availability, reliability, and performance of Scentsy’s Data Analytics eco-system.

This job worked at our home office in Meridian, ID.

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

What You Will Do:

• Serve as part of our Data Engineering and Analytics team, providing data analytics capabilities for various Scentsy Business partners and customers
• Influence and evangelize analytical methodologies to support business partner’s needs
• Act as a technical lead for designing and implementing custom reports and dashboards 
• Assess requirements and assist with developing data eco-system infrastructure 
• Solve complex business problems through data analysis and providing data-driven solutions that help drive the business forward
• 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
• Recommend data strategies, ETL processes, and procedures for getting data in and out of the data warehouse and data lake
• Design, build, test, and maintain reliable pipelines to move and transform data accurately based on architectural standards
• Create cloud-based solutions and processes that enable data and information workers
• Ensure that the performance and cost of the data environment is optimized for the organization
• Cultivate cross-functional team and department collaborative relationships
• Design, develop, and maintain data processing in SQL Server/Snowflake
• Build required infrastructure for efficient extraction, transformation, and loading of data from various data sources using SQL technologies
• Work with collaborators, including data, design, and product teams, and assist them with data-related technical issues
• Support the data infrastructure needs of collaborators, including the Product, Data, and Design teams, while assisting with data-related technical issues
• Test reporting solutions and provide training
• Interact with technical resources from various teams within the IT department 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 Data eco-system
• 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/BI engineering/data engineering experience and/or 3 years of BI experience
• 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
• Significant knowledge of and experience with best practices for data modeling, dimensional modeling (Star schema), data ingestion, queries, and data loading options
• Wide experience of cloud data 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, and other visualization tools
• Significant experience with AWS Services like Cloud Formation, S3, Glue, State Machine, Lambda, Event Bridge, SNS and Appflow
• Ability to self-learn and lead teams into new technologies and engineering methods
• Ability to solve technical problems relevant to data engineering using programming languages (SQL and Python)
• Demonstrate the ability to solution with AWS services and provision infrastructure from code/template
• Excellent data manipulation and analysis skills
• Excellent skills in SQL, data modeling, data warehousing, data lake, and OLAP
• Excellent written and oral communication skills
• Experience in SSIS and SAP BODS
• Experience with SAP systems including table structure, field definitions, CDS views and usage, a plus
• Experience with git, a plus
• Experience with Redgate Flyway, a plus
• Familiarity with Agile Framework
• Advanced critical thinking, problem solving, and analytical skills