Data Engineer

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