Data Engineer - Meridian, United States - Scentsy Inc

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% % %%techsoftware%%