Lead Data Architect
Contract W2
Contract Corp To Corp
1 Year
No Travel Required
On-site
$60 - $65/hr
Goldenpick Technologies LLC
Fitment
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Azure Data Factory
- Synapse
- Databricks
- PySpark
- SQL
- Python
- ETL/ELT
- Data Modeling
- Data Warehousing
- Azure
- Data Architecture.
Summary
Position Details:
Role: Lead Data Architect
Location: Chicago, Illinois (Hybrid only, 2-3 days office attendance)
Location: Chicago, Illinois (Hybrid only, 2-3 days office attendance)
Must have
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91164342
- Position Id: 998-36890-1792001460
- Posted 1 day ago
Company Info
About Goldenpick Technologies LLC
GoldenPick Technologies is a cutting-edge career search and leadership hiring firm that leverages innovative recruitment solutions to deliver exceptional talent. With over 20 years of industry expertise, we provide our clients with a high-caliber resource pool through our intelligent search and selection process. Our robust internal processes ensure precise candidate matching for current and future requirements. We prioritize client satisfaction, delivering prompt solutions with diligence, continuous feedback, and personal accountability.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.