Data Engineer

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).