ICONMA · 2 weeks ago
Data Engineer - AI / ML
Deerfield, IL
Full-time
Onsite
Mid, Senior Level
$52.54/hr - $55.20/hr
3+ years expICONMA is a company seeking a Data Engineer - AI / ML for their client, a Retail Pharmacy company located in Deerfield, IL. The role involves writing complex SQL queries, developing scalable ELT and ML pipelines, and advising on data architecture to ensure performance and scalability.
Staffing & Recruiting
Responsibilities
Write and maintain complex SQL queries for large, real-time datasets to generate weekly data extracts
Develop scalable ELT and ML pipelines using Python and Databricks
Automate workflows and implement data quality checks across pipelines
Refactor existing pipelines to improve efficiency, maintainability, and configuration management
Configure and optimize Databricks and Snowflake environments
Migrate pipelines and data tables between environments
Build Power BI dashboards for analytics and QC monitoring
Advise on data architecture, including best practices for performance and scalability
Document system design, data flows, and integration points
Qualification
Required
3–6 years of professional experience in data engineering or related roles
Hands-on experience with Databricks, Snowflake, Azure (and related services)
Advanced SQL expertise, including query optimization and performance tuning, complex joins, window functions, CTEs, dynamic SQL, stored procedures, advanced aggregations (ROLLUP, CUBE), pivot/unpivot operations, and handling semi-structured data (JSON/XML)
Strong Python programming for analytics, automation, workflow orchestration, and pipeline development, integration with ML frameworks and APIs
Experience designing data architecture for large-scale analytics and ML workloads
Building interactive dashboards in Power BI and applications in Streamlit
Developing and deploying ML and Generative AI pipelines, including integration with model training and inference workflows
Preferred
Familiarity with Kafka and streaming data is a plus
Experience with healthcare datasets (prescriptions, insurance claims, electronic health records is a plus
Benefits
Health Benefits
Referral Program
Company
ICONMA
ICONMA: Your Partner in Global Staffing Solutions and Digital Transformation ICONMA is a globally recognized, Woman-Owned staff augmentation and technology consulting firm.
1001-5000 employees
H1B Sponsorship
ICONMA has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (34)
2024 (31)
2023 (26)
2022 (39)
2021 (37)
2020 (69)
Funding
Current Stage
Late StageLeadership Team
Claudine George
Founder and CEO of ICONMA, LLC
Company data provided by crunchbase