Data Engineer
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 Were 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 Recommended Skills Agile Methodology Amazon Redshift Amazon Web Services Architecture Automation Business Intelligence Apply to this job. Think you're the perfect candidate? Apply on company site $(document).ready( function() $(#ads-desktop-placeholder).html(
n
n
n Estimated Salary: $20 to $28 per hour based on qualifications.
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 Were 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 Recommended Skills Agile Methodology Amazon Redshift Amazon Web Services Architecture Automation Business Intelligence Apply to this job. Think you're the perfect candidate? Apply on company site $(document).ready( function() $(#ads-desktop-placeholder).html(
n
n
n Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
