Quick overview
SeniorityMid Senior
Work modeHybrid
LocationChicago, IL, United States
DockerSQLShellApache SparkETLBashDatabricksPythonVaultAzureKubernetesLinuxAzure Data Factory
Job description
Position Title: Lead Data Architect
Location: Chicago (hybrid work)
Responsibilities
We are looking for Data Architect who will be responsible for designing a solution for a big retail company. The main focus is to support processing of big data volumes and integrate solution to current architecture.
Readiness to work until 8.00 pm CET (no need to do overtimes)
Overall years of experience required 8+ (at least 1+ year in an Architect position)
Strong, recent hands-on expertise with Azure Data Factory and Synapse is a must (3+ years).
Strong expertise in designing and implementing data models, including conceptual, logical, and physical data models, to support efficient data storage and retrieval.
Strong knowledge of Microsoft Azure, including Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, and Azure Databricks, pySpark for building scalable and reliable data solutions.
Extensive experience with building robust and scalable ETL/ELT pipelines to extract, transform, and load data from various sources into data lakes or data warehouses.
Ability to integrate data from disparate sources, including databases, APIs, and external data providers, using appropriate techniques such as API integration or message queuing.
Proficiency in designing and implementing data warehousing solutions (dimensional modeling, star schemas, Data Mesh, Data/Delta Lakehouse, Data Vault)
Proficiency in SQL to perform complex queries, data transformations, and performance tuning on cloud-based data storages.
Experience integrating metadata and governance processes into cloud-based data platforms
Certification in Azure, Databricks, or other relevant technologies is an added advantage
Experience with cloud-based analytical databases.
Experience with Azure MI, Azure Database for Postgres, Azure Cosmos DB, Azure Analysis Services, and Informix.
Experience with Python and Python-based ETL tools.
Experience with shell scripting in Bash, Unix or windows shell is preferable.
Demonstrated ability to lead cross-functional engineering teams, define technical strategy and architecture, drive delivery of complex data platforms, mentor engineers, and effectively communicate with stakeholders at all organizational levels.
Nice to have
Experience with Elasticsearch
Familiarity with containerization and orchestration technologies (Docker, Kubernetes).
Troubleshooting and Performance Tuning: Ability to identify and resolve performance bottlenecks in data processing workflows and optimize data pipelines for efficient data ingestion and analysis.
Collaboration and Communication: Strong interpersonal skills to collaborate effectively with stakeholders, data engineers, data scientists, and other cross-functional teams.
Ability to plan, estimate and track progress of implementing features
Computer Science and data science academic and education credentials
Similar jobs
- RA

AI & Data Architect (Databricks | Lakehouse | AI)Recently posted
RADcube · United States · Hybrid 🇺🇸
AWSETLMLflow+5TechnologySalary not listed - CY

Jr. Data Architect/EngineerRecently posted
cyberThink, Inc. · Plano, TX · On-site 🇺🇸
OracleSQLMicrosoft Excel+17TechnologySalary not listed - AT
Data ArchitectRecently posted
Altitude Technology Solutions Inc · Houston, TX · On-site 🇺🇸
OracleSQLApache Spark+2TechnologySalary not listed - BF
Snowflake ArchitectRecently posted
Biz Fusion Inc. · United States · Remote 🇺🇸
SQLGitAWS+8TechnologySalary not listed - AC
Snowflake Data Architect Healthcare Claims MigrationRecently posted
Alltech Consulting Services, Inc. · United States · Hybrid 🇺🇸
SQLAWSETL+4TechnologySalary not listed - SI

(ONSITE) DATA ARCHITECTRecently posted
Siri Infosolutions Inc · Frisco, TX · Hybrid 🇺🇸
SQLShellETL+1TechnologySalary not listed - VE
Sr. Data Modeler Auto Apply
Versant · New York, NY · Hybrid 🇺🇸
UnityEngineering$165k - $195k/yr - B2
Senior Profisee MDM & Microsoft Fabric Data Architect - R01572927Recently posted Auto Apply
Brillio 2 · Austin · On-site 🇺🇸
Technology$170k - $180k/yr - PH

Director Data Management Auto Apply
Pedestal Health · United States · Hybrid 🇺🇸
GCPOracleClinical Trials+7TechnologySalary not listed - MT

Director, Data Management Auto Apply
Maze Therapeutics · South San Francisco · Hybrid 🇺🇸
OracleClinical TrialsMental Health+1TechnologySalary not listed - LB
Sr. Manager, Data and AnalyticsRecently posted Auto Apply
LOTTE BIOLOGICS USA, LLC · Syracuse · Hybrid 🇺🇸
Stakeholder ManagementSQLETL+11Salary not listed - LI
Data 360 Enablement Architect Auto Apply
ListEngage, LLC · United States · Remote 🇺🇸
SQLCurriculum DevelopmentInstructional Design+1Salary not listed