Data Engineer

Scentsy Inc•Meridian, ID

About The Position

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.

Requirements

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
Advanced critical thinking, problem solving, and analytical skills
Familiarity with Agile Framework

Nice To Haves

Experience with SAP systems including table structure, field definitions, CDS views and usage, a plus
Experience with git
Experience with Redgate Flyway

Responsibilities

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