Data Engineer - Meridian, United States - Scentsy

    Scentsy
    Scentsy Meridian, United States

    1 month ago

    Default job background
    Description
    Data Engineer
    Meridian, ID )

    • IT
    Description

    Scentsy is looking for aData Engineerto 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