Sign upLog in
See more jobs

Data Engineer (Snowflake) 2

The AES Group
  • Chillicothe, IL
  • Quick Apply
1 day ago

Job Description

Role: Data Engineer (Snowflake)
Location: Chillicothe, IL 61523 (Onsite 5 Days/Week)

Let's create our future together at The AES Group!

About The AES Group

The AES Group is a premier technology and engineering consulting company that has been bringing businesses and talent together for over 20 years to deliver innovative solutions that have the greatest positive impact on society. AES has helped over 40 business enterprises, including Fortune 500 companies, engage their customers, empower their employees, and transform their business operations with the power of cloud, data, AI, engineering, and other emerging technologies.
Position Overview

Seeking a Data Engineer (Snowflake) to join the clients team supporting enterprise analytics and data initiatives. Ideal candidate will combine Snowflake administration, strong SQL, ETL/data engineering, data integration, and troubleshooting skills. The position will support the development and maintenance of foundational data solutions used by business users, analytics teams, applications, and reporting platforms.

Key Responsibilities

  • Provide Snowflake administration and development support, including database objects, access grants, permissions, and create statements.
  • Develop, maintain, troubleshoot, and optimize SQL queries, views, and data solutions.
  • Investigate and trace data, query, and system issues across multiple enterprise platforms.
  • Build and maintain ETL/data pipelines for integrating, transforming, and normalizing data from multiple sources.
  • Support data orchestration, job scheduling, and automated data processes.
  • Monitor and help maintain data freshness, availability, reliability, and quality.
  • Integrate and normalize datasets across enterprise data platforms.
  • Design and build data objects and solutions rather than relying solely on pre-existing code or procedures.
  • Review data solutions for efficiency, performance, compute usage, and storage costs, particularly within Snowflake.
  • Manage user access and role-based permissions while supporting data governance requirements.
  • Support the modernization of analytics and reporting capabilities across the organization.
  • Document database architecture, data flows, processes, and program-specific solutions.
  • Collaborate with data engineers, data specialists, scientists, enterprise technology teams, and internal business customers.
  • Support users consuming enterprise data through Power BI, applications, analytics platforms, and other solutions.
  • Respond to internal data requests and help users identify, access, and consume the appropriate datasets.
  • Help establish consistent data engineering practices and develop scalable, optimized solutions.

Required Qualifications

  • 2 4 years of relevant experience preferred. Candidates with additional experience may also be considered based on skill alignment and interest in the role.
  • Associate's degree in Computer Programming, Computer Science, Information Technology, or a related field required; Bachelor's degree preferred.
  • Strong hands-on Snowflake experience.
  • Strong SQL development and troubleshooting skills.
  • Experience with ETL/data engineering and data pipelines.
  • Experience integrating and normalizing data from multiple sources.
  • Strong troubleshooting, data analysis, and issue-resolution capabilities.
  • Understanding of database administration, access management, and permissions.
  • Experience with data orchestration and job scheduling.
  • Ability to independently build, troubleshoot, and support data solutions.
  • Strong verbal and written communication skills.
  • Ability to work independently while collaborating effectively with technical and business stakeholders.

Top 3 Technical Skills

1. Snowflake

Hands-on Snowflake administration/development, access management, database objects, troubleshooting, performance, and cost considerations.

2. SQL

Strong ability to independently develop, analyze, troubleshoot, and optimize SQL queries and views.

3. ETL / Data Engineering

Experience building or supporting data pipelines, data integration, normalization, orchestration, scheduling, and reliable data delivery.

Strongly Preferred

  • Snowflake DBA experience
  • Advanced SQL/query engineering
  • Cross-platform data integration
  • Data normalization and transformation
  • ETL/data pipeline development
  • Data orchestration and job scheduling
  • Enterprise data environment experience
  • Snowflake performance and cost optimization
  • Role-based access control and data governance
  • Experience troubleshooting data issues across multiple systems

Nice-to-Have Skills

  • Python scripting and automation
  • AWS services/accounts
  • Power BI or data visualization experience
  • SAS or other legacy analytics technologies
  • Experience with enterprise databases such as Oracle, Teradata, SQL Server, DB2
  • Snowflake Cortex
  • GitHub Copilot
  • Agentic AI development tools
  • Experience using AI-assisted development tools such as those integrated with VS Code
  • Architecture/dependency management tools such as LeanIX

Ideal Candidate Profile

The ideal candidate is a Snowflake-focused Data Engineer / Database Analyst who can operate across both database administration and development.

A strong candidate will bring: Snowflake + Strong SQL + ETL/Data Engineering + Troubleshooting + Data Integration.

Numbers & Facts

LocationChillicothe, IL

Skills

  • Access Controlunmatched
  • Amazon Web Services (AWS)unmatched
  • Analysis Skillsunmatched
  • Artificial Intelligence (AI)unmatched
  • Business Operationsunmatched
  • Cloud Computingunmatched
  • Communication Skillsunmatched
  • Computer Programmingunmatched
  • Computer Scienceunmatched
  • Cost Controlunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Setsunmatched
  • Data Visualizationunmatched
  • Database Administrationunmatched
  • Database Analysisunmatched
  • Database Architectureunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Programmingunmatched
  • Emerging Technologyunmatched
  • Engineering Consultingunmatched
  • Fortune 500 Customersunmatched
  • GitHubunmatched
  • IBM DB2unmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • Microsoft Access Databaseunmatched
  • Microsoft SQL Serverunmatched
  • Multiplatform/Cross-Platformunmatched
  • NCR Teradataunmatched
  • Oracleunmatched
  • Oracle SQLPlusunmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Presentation/Verbal Skillsunmatched
  • Problem Solving Skillsunmatched
  • Process Flowunmatched
  • Programming Toolsunmatched
  • Python Programming/Scripting Languageunmatched
  • Query Optimizationunmatched
  • Reporting Skillsunmatched
  • SQL (Structured Query Language)unmatched
  • Scalable System Developmentunmatched
  • Scripting (Scripting Languages)unmatched
  • Snowflake Schemaunmatched
  • Software Engineeringunmatched
  • Statistical Analysis System (SAS)unmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder