Premier Nutrition Company (PNC) is looking to solve challenging problems and drive decisions with data by enhancing their Enterprise Data Intelligence team's capabilities. This involves migrating, acquiring, maintaining, and evolving their data integration process and platform to support analytics, reporting, and data science use cases.
Requirements
- 5–7 years of experience as a Data Engineer working within cloud-native and SaaS-based environments, supporting enterprise data platforms built on data warehouses, data lakes, and application databases (e.g., Snowflake, Oracle, SQL Server).
- 5+ years of SQL experience with proven ability to write, optimize, and maintain complex queries and stored procedures.
- Programming experience in Python, Scala, or other scripting languages for automation, data transformation, and integration.
- Hands-on experience designing, building, and maintaining ELT/ETL data pipelines, dimensional models, and data marts using modern tools such as dbt, Fivetran, or equivalent cloud-based frameworks.
- Demonstrated experience working with SaaS data sources and APIs, integrating data from cloud-based systems such as ERP (e.g., NetSuite), CRM, and planning tools (e.g., Oracle EPM, O9, or Salesforce).
- Exposure to or hands-on experience with AI/LLM frameworks (e.g., Snowflake Cortex, MCP, or similar technologies) to enhance automation and data intelligence.
- Experience with data integration and orchestration tools (e.g., Dell Boomi, Airflow, Azure Data Factory, or equivalent).
Responsibilities
- Design, build, and maintain cloud-native data pipelines and infrastructure to support analytics, reporting, and data science use cases in a SaaS-based environment.
- Perform all stages of the data lifecycle: requirements gathering, design, ingestion, transformation, modeling, testing, deployment, monitoring, and production support.
- Implement and manage ELT pipelines using tools such as Fivetran, dbt, and Python, delivering reliable and scalable data solutions.
- Develop and maintain data models, data marts, APIs, and automation scripts to streamline analytics workflows.
- Design and deploy database schemas, tables, and views in Snowflake across multiple environments (DEV, QA/UAT, PROD).
- Collaborate with stakeholders to translate business requirements into robust technical designs.
- Monitor the production schedule, troubleshoot any failures, and ensure that the processes are running smoothly.
Other
- Hybrid work environment: expected to come in Tuesday through Thursday if living within 100 miles of the office.
- Must be willing to be on call for night/weekend production support.
- Excellent communication and collaboration skills, with the ability to work cross-functionally in a distributed SaaS organization.
- Challenger Mindset—bias for action, hungry to get after it, comfortable taking smart risks.
- Be a builder by creating for the future.
