What are the responsibilities and job description for the Data Engineer (Snowflake) 2 position at ChaTeck Incorporated?
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.
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.