Data Engineer

Aureon Consulting; West Des Moines (IA); On-site; USD 120,000 - 150,000; Full time

Job summary

Aureon Consulting seeks an experienced Enterprise Data Engineer (Systems Analyst) to design and build scalable data and integration solutions that support enterprise analytics and business operations.

In this role you will design ETL/ELT pipelines using Snowflake, SQL and dbt, develop integrations with APIs and cloud platforms, and partner with business and technical teams to implement data modeling, governance, quality controls and cost-efficient delivery.

Qualifications

• Strong experience with Snowflake, SQL, and dbt.
• Experience building enterprise-scale data pipelines and integrations.
• Hands-on experience with cloud data platforms, data warehousing, and data lakes.
• Strong knowledge of data modeling, governance, and data quality.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, and dbt.
• Build and optimize data transformations, integrations, and orchestration workflows.
• Develop integrations using APIs, messaging platforms, and cloud technologies.
• Partner with business and technical teams to translate requirements into scalable data solutions.
• Implement data modeling, governance, quality controls, and best practices.
• Monitor and improve data pipeline performance, reliability, and cost efficiency.
• Troubleshoot complex data issues and recommend effective solutions.
• Evaluate emerging technologies to enhance data delivery and integration capabilities.

Skills

Problem-solving

Communication

Stakeholder management

Multitasking

Analytical thinking

Education

Bachelor's degree in Computer Science/Information Systems or related field

Tools

Snowflake

SQL

dbt

Cloud data platforms

Data warehousing

Job description

Aureon Consulting is seeking an experienced Enterprise Data Engineer (Systems Analyst) to design and build scalable data and integration solutions that support enterprise analytics and business operations.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, and dbt.
• Build and optimize data transformations, integrations, and orchestration workflows.
• Develop integrations using APIs, messaging platforms, and cloud technologies.
• Partner with business and technical teams to translate requirements into scalable data solutions.
• Implement data modeling, governance, quality controls, and best practices.
• Monitor and improve data pipeline performance, reliability, and cost efficiency.
• Troubleshoot complex data issues and recommend effective solutions.
• Evaluate emerging technologies to enhance data delivery and integration capabilities.

Required Qualifications

• Strong experience with Snowflake, SQL, and dbt.
• Experience building enterprise-scale data pipelines and integrations.
• Hands-on experience with cloud data platforms, data warehousing, and data lakes.
• Strong knowledge of data modeling, governance, and data quality.
• Excellent problem-solving, communication, and stakeholder management skills.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Snowflake certification(s).
• Experience in financial services, insurance, or other regulated industries.
• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 8+ years of data engineering, systems analysis, or software development experience.

Key Technologies: Snowflake, SQL, dbt, ETL/ELT, APIs, Cloud Data Platforms, Data Warehousing, Data Modeling, Data Governance.