Data Engineer

Senior Data Engineer 📍 Preference: Near Lake Forest, IL | Open to Remote (U.S.-based candidates) Our Client is looking for a highly technical, hands-on Senior Data Engineer to help power a large-scale enterprise data ecosystem. This isn’t a reporting role — it’s a build-and-optimize role for someone who thrives in complex environments and knows how to make data move fast and reliably. If you enjoy solving performance bottlenecks, designing scalable data models, and working across modern cloud platforms like Snowflake and Databricks, this is the kind of challenge that keeps things interesting. What You’ll Be Doing • Build and maintain scalable data pipelines pulling from complex enterprise systems like SAP/S/4HANA • Design, develop, and optimize advanced data models to support business intelligence and analytics • Write and tune high-performance SQL and stored procedures to improve load times and reduce latency • Work across Snowflake and Databricks in a modern cloud data stack • Develop internal data tools and lightweight applications using Python and Streamlit • Identify performance issues, troubleshoot bottlenecks, and implement sustainable optimization strategies This role requires someone who can operate independently, think architecturally, and execute hands-on. What You Bring • 10+ years of experience in data engineering, database engineering, or related technical roles • Deep expertise in SQL (stored procedures, query optimization, performance tuning) • Strong Python skills in production data environments • Experience with Snowflake and/or Databricks • Hands-on experience working with SAP, S/4HANA, or SAP HANA data sources • Strong understanding of data modeling principles and large-scale data processing Nice to Have • Experience with Streamlit or similar Python-based data app frameworks • Exposure to Infrastructure as Code (Terraform) • Experience with dbt or modern ELT workflows Why This Role Stands Out • High visibility impact across an enterprise-scale organization • Modern cloud data stack • Real ownership over performance, modeling, and architecture decisions • Opportunity to build internal tools that teams actually use If you’re a senior-level data engineer who enjoys working deep in the stack and solving meaningful performance challenges, this could be a strong fit. Open to U.S.-based remote candidates, with preference for those near Lake Forest, Illinois.