Overview
Skills
Job Details
Key Responsibilities
Develop and optimize complex batch and near-real-time SQL queries to meet product requirements and business needs.
Design and implement core foundational datasets that are reusable, scalable, and performant.
Architect, implement, deploy, and maintain data-driven solutions in Snowflake and Databricks.
Develop and manage data pipelines supporting multiple reports, tools, and applications.
Conduct advanced statistical analysis to yield actionable insights, identify correlations/trends, measure performance, and visualize disparate sources of data.
Required Skills and Experience
5+ years in operations, supply chain, data engineering, data analytics, and/or database administration.
Experience in design, implementation, and optimization in Snowflake or other relational SQL databases.
Experience with data cleansing, curation, mining, manipulation, and analysis from disparate systems.
Experience with configuration control (GitHub preferred) and Data DevOps practices using GitHub Actions, Jenkins, or other deployment pipelines that provide Continuous Integration and Continuous Delivery (CI/CD).
Experience with Data Extract, Transform, and Load (ETL) processes using SQL as the foundation.
Experience with database structures and modeling implementation such as third normal form.
ship.
Preferred Skills
Experience with Manufacturing, Operations, and/or Supply Chain process and systems.
Experience using MRP/ERP systems (SAP).
Experience with Python and related libraries such as Pandas for advanced data analytics.
Experience with schema deployment solutions such as SchemaChange or Liquibase.
Working knowledge of Agile software development methodologies.
Ability to filter, extract, and analyze information from large, complex datasets.
Strong verbal and written communication skills for cross-functional collaboration.
Experience with data deployment solutions such as Snowflake Tasks, Matillion, SSIS, Azure Data Factory (ADF), or Alteryx.
Experience with Snowflake Streams, Stages, and Snowpipes for data ingestion.
Experience with VS Code and GitHub Desktop for integrated development.
Experience with web application relational database models and APIs.
Knowledge of statistical modeling and machine learning methods.