Data Solutions Architect

Parmesoft Inc.
Chicago, United States of America
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Chicago, United States of America

Tech stack

Artificial Intelligence
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Business Analytics Applications
Azure
Computer Programming
Continuous Integration
Data Architecture
Information Engineering
Data Governance
Data Infrastructure
ETL
Data Security
Data Systems
Data Warehousing
Software Design Patterns
Python
Key Management
Machine Learning
Performance Tuning
Cloud Services
Azure
Azure
SQL Databases
Data Streaming
Trade Promotion Management
Google Cloud Platform
Cloud Platform System
Azure
Snowflake
Spark
Data Strategy
Data Lake
AI Platforms
PySpark
Data Analytics
Enterprise Integration
Data Management
Api Design
REST
Terraform
Databricks

Job description

We are seeking an experienced Data Solutions Architect to lead the design and delivery of enterprise-scale cloud data platforms for Retail and Consumer Packaged Goods (CPG) clients. This role combines deep technical expertise with strong consulting and stakeholder management skills to architect scalable, secure, and business-aligned data solutions. The ideal candidate will have extensive experience designing modern data platforms using Microsoft Azure and Databricks, with strong proficiency in Python, SQL, Apache Spark, and Data Modelling. The successful candidate will work closely with business leaders, enterprise architects, engineering teams, and client stakeholders to define data strategies, solution architectures, and implementation roadmaps that enable advanced analytics, AI/ML, customer insights, and operational excellence., Solution Architecture & Strategy

  • Design end-to-end cloud-native Data & AI platforms leveraging Azure, Databricks, Snowflake, AWS & Google Cloud Platform & Gemini Enterprise.
  • Define target-state data architecture aligned to business objectives and enterprise technology strategy.
  • Develop architecture blueprints, reference architectures, solution patterns, and technology roadmaps.
  • Lead architecture discussions with client executives, enterprise architects, and engineering teams.
  • Translate business requirements into scalable technical solutions.

Technical Leadership

  • Architect enterprise data lakes, lakehouses, data warehouses, and analytical platforms.
  • Define scalable ingestion, transformation, storage, and serving patterns for data & analytical products.
  • Lead architectural decisions around batch, streaming, real-time analytics, and AI-ready data platforms.
  • Establish reusable design patterns, standards, governance, and engineering best practices.
  • Guide engineering teams throughout implementation and provide technical leadership.

Retail / CPG Domain Consulting

  • Design data platforms supporting Retail and CPG use cases, such as Customer 360 & MDM, Sales & Commercial Analytics, Demand Forecasting, Supply Chain Visibility, Inventory Optimization, Trade Promotion Management, Marketing Analytics etc.

  • Collaborate with business stakeholders to identify opportunities for data-driven transformation.

Required Technical Skills

· Cloud & Data Platforms: Microsoft Azure, Databricks, Azure Data Factory, ADLS Gen2, Azure Key Vault, Azure DevOps

· Programming & Data Engineering: Python, SQL, Apache Spark (PySpark), Delta Lake, ETL / ELT,Data Modelling (Conceptual, Logical & Physical)

· Architecture: Enterprise Data Architecture, Modern Data & AI Platform Design, Data Acquisition & Integration, API-based Integration, Batch & Streaming Architectures, Data Security & Identity, Performance Optimisation, Solution Design Documentation

Preferred Skills

Databricks Unity Catalog, Federation Design, Snowflake, AWS (S3, Glue, Lambda, EMR, Redshift), Data Governance & Data Management frameworks (e.g., DAMA-DMBOK), Lakeflow Designer, Genie, Lakebase, Master Data Management (MDM), Data Quality Frameworks, Terraform, CI/CD using Azure DevOps, REST API integration, AI/ML platform architecture, GenAI and Large Language Model (LLM) integration patterns, Gemini Enterprise integration etc.

Requirements

  • 12+ years of experience in Data Analytics & AI including 8+ years relevant designing enterprise cloud data platforms.
  • Proven experience architecting Azure Databricks solutions including new Databricks offerings
  • Strong consulting and client-facing experience.
  • Experience leading geographically distributed engineering teams.
  • Experience delivering enterprise-scale transformation programs.
  • Retail or Consumer Packaged Goods (CPG) industry experience is essential.

Apply for this position