Data Architect

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

Job summary

Aureon Consulting is seeking a senior data architect / data engineer to help shape enterprise data strategy and implement scalable data platforms. You will work closely with business and technology leaders to translate requirements into architectural designs and hands-on solutions.

The role blends business discovery, architecture, and engineering, offering visibility across the organization and opportunities to influence data governance and modernization efforts.

Qualifications

• Experience as a Data Architect or senior data role and ability to translate business needs into technical solutions.
• Hands-on design, development, and implementation of enterprise data solutions.
• Strong SQL, data modeling, and data governance awareness.

Responsibilities

• Partner with business and technical leaders to understand reporting, analytics, and data management needs.
• Design and implement scalable data architectures, integrations, and pipelines.
• Drive lakehouse, warehouse, and data platform strategies.
• Build and support data ingestion, transformation, and integration processes.
• Present recommendations and technical concepts to diverse audiences.

Skills

SQL expertise

Enterprise data design

Data integration & ETL/ELT

Data warehousing / lakehouse

Data modeling & architecture

Stakeholder communication

Tools

Microsoft Fabric

Azure data services

Power BI

Job description

Join a growing data organization where you'll have the opportunity to influence enterprise data strategy, partner directly with business and technology leaders, and help shape the future of a modern data platform. This is a highly visible role that blends business discovery, architecture, and hands‑on engineering.

We're seeking a senior‑level Data Architect / Data Engineer who enjoys solving complex data challenges, building scalable solutions, and acting as a trusted advisor to stakeholders across the organization. The ideal candidate can move seamlessly between understanding business needs, designing enterprise data solutions, and rolling up their sleeves to help implement them.

What You’ll Do

• Partner with business and technical leaders to understand reporting, analytics, and data management needs
• Identify systems of record and define enterprise sources of truth
• Design and implement scalable data architectures, integrations, and pipelines
• Drive lakehouse, warehouse, and data platform strategies
• Evaluate current‑state environments and recommend future‑state solutions
• Build and support data ingestion, transformation, and integration processes
• Collaborate on data governance, stewardship, and ownership initiatives
• Present recommendations and technical concepts to both technical and non‑technical audiences
• Help establish best practices for data architecture, engineering, and analytics

Required Skills & Experience

• Experience as a Data Architect, Lead Data Engineer, Principal Data Engineer, or similar senior‑level data role
• Strong SQL expertise
• Experience designing and implementing enterprise data solutions
• Hands‑on experience with data integration, ETL/ELT, and data pipeline development
• Experience with modern data warehousing and/or lakehouse architectures
• Strong data modeling and data architecture experience
• Ability to work directly with business stakeholders to gather requirements and translate them into technical solutions
• Experience evaluating, recommending, and implementing data platform solutions
• Strong communication and consulting skills with the ability to influence technical and business decisions

Preferred Skills & Experience

• Microsoft Fabric
• Azure‑based data platforms and services
• Data governance and master data initiatives
• Lakehouse architecture and Medallion design patterns
• Power BI and analytics platforms
• Experience supporting AI, advanced analytics, or modern data platform initiatives

What Makes This Role Unique

This is not a pure architect position and it's not a pure engineering position.

Success in this role requires the ability to:

• Discover business needs
• Build and implement those solutions

We're looking for someone who can influence strategy, recommend solutions, and remain technically engaged throughout the process.

If you enjoy helping organizations turn data into strategic business value while remaining close to the technology, we'd love to connect.