Skip to main content

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?