Snowflake Data Engineer

Job Title: Snowflake Data Engineer

Job Location: Chilicothe IL / Mossville IL

Position’s Contributions to Work Group:

• The position fills the Database Administrator (DBA) role for a small analytics team, maintaining the intended data architecture (including for other team members), implementing data governance, creating and managing database objects, and documenting the architecture and program-specific flows.
• Own end-to-end user access management: triage access requests, obtain approvals/denials, communicate results, grant access, and administer role-based access controls to keep users accountable and compliant.
• Serve as the Data/Product Owner for multiple analytics programs and datasets, collaborating continually with the team where data sets and end-users often overlap to ensure consistent architecture and user experience.
• Support the Analytics team's modernization initiative, migrating from a legacy SAS central platform to a modern reporting framework.
• Coordinate, test, and implement changes to Snowflake databases, correcting errors and modifying databases/DBMS as needed.
• Author, troubleshoot, and performance-tune SQL views and queries, and build and maintain data pipelines (ETL) and job orchestration, including cloud scheduling such as AWS Lambda.
• Build and improve data sets and reporting for owned programs, and support customer inquiries on available data, enhancements, and general support.
• Advise and support the data needs of Data Specialists / Scientists and report builders, and perform joint planning to avoid duplicative or conflicting outputs.

 Typical task breakdown:

• Review and process access requests for data and reporting
• Build or improve data sets or reporting for responsible programs
• Manage data architecture for other members of the team
• Support customer inquiries for support, available data to consume, and enhancements to existing tools
• Assist team members with tasks to help balance workloads

 Interaction with team:

• Advise and support data needs for the rest of the team of Data Specialists / Scientists and report builders
• Perform joint planning to avoid duplication of efforts or conflicting outputs
• Assist the management of the footprint of technology (Snowflake, SAS, Oracle, Teradata, SQL Server, Power BI, Tableau)
• Frequent and detailed communication is needed on a daily basis

Team Structure

• Team of 6

Work environment:

• In office collaberation

Education & Experience Required:

• Years of experience: 2-4 years
• Degree requirement: Associate's degree in computer programming or relevant field required. Bachelor's degree preferred.
• Do you accept internships as job experience:  if skills can be showcased, yes
• Are there past or additional job titles or roles that would provide comparable background to this role:

Top 3 Skills

• Snowflake Database Administration (implementing, debugging/troubleshooting/tracing, issue resolution)
• Data Governance and Architecture
• Strong SQL and query engineering / Data pipeline / ETL development - (view/query authoring, troubleshooting, performance tuning)

Additional Technical Skills Required

• Strong SQL (query/view authoring, troubleshooting, and performance tracing)
• Python (scripting and automation)
• Data pipeline / ETL and job orchestration (including cloud scheduling such as AWS Lambda)
• Role-based Access Controls
• Documentation of architecture and Program specific flows
• Version Control Systems and Code Review processes

Desired

• BI tooling (Power BI and/or Tableau)
• SAS familiarity
• Non-Snowflake source integration (DB2, Oracle, Teradata, SQL Server, NAS, SharePoint)
• Snowflake cost and storage optimization (warehouse sizing, compute/storage tuning)
• GitHub Copilot / Agentic AI experience
• LeanIX (architecture and dependency cataloging)

Soft Skills Required

• Strong verbal and written communication
• Customer-service and stakeholder orientation
• Independent time management and self-direction
• Cross-team collaboration and joint planning
• Attention to detail

 Desired

• Comfort with ambiguity during transition and modernization
• Ownership mindset
• Documentation and knowledge-transfer discipline
• Mentoring and peer-support skills

 Disqualifiers/Red Flags/Overqualifications:

• Remote work

 Must Have Required Technologies For This Position

• Snowflake Database Administration (implementing, debugging/troubleshooting/tracing, issue resolution)
• Data Governance and Architecture
• Strong SQL and query engineering / Data pipeline / ETL development - (view/query authoring, troubleshooting, performance tuning)
• Strong SQL (query/view authoring, troubleshooting, and performance tracing)
• Python (scripting and automation)
• Data pipeline / ETL and job orchestration (including cloud scheduling such as AWS Lambda)
• Role-based Access Controls
• Documentation of architecture and Program specific flows
• Version Control Systems and Code Review processes