Data Engineer
Technology
Chicago, United States2 months agoUntil 10/29/2026
Service contractOn-site
Job description
Job Title : Data Engineer
Location: Chicago, IL - 60478
Duration: Long-Term Contract
Job Summary
We are seeking a skilled Data Engineer to design, develop, and optimize enterprise data platforms and cloud-based data pipelines. The ideal candidate will have strong experience building scalable ETL/ELT solutions, implementing modern data lakehouse architectures, and delivering secure, high-quality data solutions across AWS and Azure environments. This role partners closely with engineering, analytics, and business teams to enable enterprise reporting, business intelligence, and AI-driven initiatives.
Key Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines across enterprise applications, including ERP, CRM, and operational systems.
- Build, enhance, and support cloud-based data lakehouse solutions aligned with modern data architecture best practices.
- Develop and maintain data models, semantic layers, and curated datasets for analytics and business intelligence.
- Translate business requirements into scalable and efficient technical data solutions.
- Ensure data quality, integrity, governance, security, and compliance across enterprise data platforms.
- Optimize SQL queries, data pipelines, and storage performance across AWS and Azure environments.
- Support enterprise data integration initiatives involving Data Lakes, Microsoft Dynamics 365 ERP, CRM, and other business applications.
- Monitor data pipelines, troubleshoot production issues, and maintain high system availability and reliability.
- Contribute to data architecture improvements, engineering standards, and continuous process optimization.
- Enable analytics, reporting, and AI initiatives by delivering trusted, accessible, and high-quality enterprise data.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 4+ years of experience in Data Engineering or Data Platform development.
- Strong experience designing and building enterprise ETL/ELT pipelines in cloud environments.
- Hands-on experience with AWS services including S3, Redshift, Glue, and DMS.
- Experience with Azure Data Factory (ADF) and SSIS.
- Strong proficiency in SQL and relational database design.
- Solid understanding of data warehousing, data lakes, and lakehouse architecture.
- Experience processing structured, semi-structured, and unstructured data.
- Strong knowledge of data modeling, data quality, and performance optimization.
- Excellent analytical, troubleshooting, and communication skills.
Preferred Qualifications
- Experience implementing medallion architecture and lakehouse design patterns.
- Experience working in multi-cloud environments using AWS and Azure.
- Hands-on experience with Databricks, Apache Spark, or Microsoft Fabric.
- Experience with Power BI or other enterprise reporting platforms.
- Familiarity with AI/ML data enablement, including AWS Bedrock and Retrieval-Augmented Generation (RAG) concepts.
- Experience using Git, Azure DevOps, and CI/CD practices.
- Knowledge of Agile methodologies and Software Development Life Cycle (SDLC).
Keywords
monthsOfExperience: 48OCamlApache SparkMicrosoft DynamicsRedshiftDevOpsSqlApache LicenseApache Http ServerRelational grammarCI / CDBedrockAWSGitCI/CD
Interested in this role?