Data Engineer

Apply

Description

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