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
30+ days ago