Data Architect/ Solution Architect

Apetan Consulting LLC; Peoria (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Apetan Consulting LLC is seeking a Data Architect/Solution Architect for a 2-year onsite engagement in Peoria, IL. You will design enterprise data platforms, lead global teams, and translate complex technical plans into business value for senior leadership.

The role requires deep AWS/Snowflake expertise, strong communication, and a manufacturing-domain background to drive innovative data solutions and governance across projects.

Qualifications

• 15+ years in data engineering, data warehousing, or enterprise architecture roles.
• Build secure, scalable data solutions on AWS and Snowflake.
• Lead onshore and offshore teams to create the solution.
• Present technical plans and business value to executive stakeholders clearly.
• Implement RBAC, data masking, and encryption at rest/in transit.
• Manufacturing domain experience.

Responsibilities

• Design architectures for enterprise data platforms on AWS and Snowflake.
• Lead onshore and offshore teams to deliver solutions.
• Present plans and business value to executives.
• Apply AI to increase productivity and develop AI solutions.
• Drive data governance and security practices across projects.

Skills

Data architecture leadership

Team leadership

Executive communication

AI/ML awareness

Tools

AWS

Snowflake

Python

Git/GitHub Actions

Terraform

CloudFormation

SageMaker

Job description

Job Title: Data Architect/ Solution Architect

Duration: 2 years

Location: Peoria, IL - 5 Days/week Onsite

Key Capabilities

• Experience with designing & delivering Enterprise data Platforms and awareness of all the areas of the data ecosystem (Data Management, Integrations (Streaming/Batch), Visualizations, Analytical Platforms etc.)
• Manufacturing domain experience
• Design Architectures: Build secure, scalable data solutions on AWS and Snowflake
• Lead Teams: Lead Onshore & Offshore teams to create the solution
• Drive Innovation: Apply AI awareness to increase productivity and develop AI solutions.
• Lead Readouts: Ability to present technical plans and business value to executive stakeholders clearly.
• Communication: Exceptional verbal and written communication skills for high-level leadership readouts.

Detailed Technical Skills

• Cloud Infrastructure (AWS): Deep expertise in IAM, VPC networking, CloudWatch, S3, IAM, Lambda, Glue, and EMR.
• Data Warehousing (Snowflake): Mastery of Snowpipe, streams, tasks, dynamic tables, data sharing, and storage optimization.
• Development & Scripting (Python): Advanced skills in PySpark, Pandas, NumPy, and building optimized, object-oriented data frameworks.
• DevOps & CI/CD: Hands-on experience with Git, GitHub Actions, GitLab CI, and Infrastructure as Code (Terraform or CloudFormation).
• AI & Machine Learning Awareness: Awareness of vector databases, LLM integration, prompt engineering, and MLOps pipelines (e.g., SageMaker).
• Data Governance & Security: Proven ability to implement role-based access control (RBAC), data masking, and encryption at rest/in transit.

Required Qualifications

• Experience: 15+ years of proven experience in data engineering, data warehousing, or enterprise architecture roles.