Data Engineer

HireTalent - Staffing & Recruiting Firm; Lake Forest (IL); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading staffing and recruiting firm is seeking a Senior Data Engineer to lead complex data pipelines and optimize performance across various systems. The ideal candidate will have over 10 years of experience in data engineering, with advanced skills in SQL and Python. You will design data models, extract data efficiently, and utilize platforms like Snowflake and Databricks. This role offers a unique opportunity to drive impactful analytics and application development in a collaborative environment.

Qualifications

• Minimum of 10 years of professional experience in data engineering, database administration, or a related field.
• Expertise in building and maintaining scalable data pipelines.
• Proficiency in performance optimization strategies for data loads.

Responsibilities

• Build and maintain scalable data pipelines to extract data from various source systems.
• Design, develop, and tune complex data models for business intelligence needs.
• Manage stored procedures and data loads for optimal performance.

Skills

SQL

Python

Data Modeling

Performance Optimization

Data Engineering

Education

Bachelor's degree in any major

Tools

Snowflake

Databricks

S/4HANA

SAP

Streamlit

Job description

We are seeking a highly experienced and technical Senior Data Engineer to lead the end-to-end lifecycle of our data ecosystems. This role focuses on sophisticated scripting, robust data modeling, and performance optimization across a modern data stack. The ideal candidate is a problem-solver who can extract data from complex source systems and transform it into actionable intelligence through high-performance stored procedures and optimized data loads.

Key Responsibilities

• Data Extraction & Engineering: Build and maintain scalable data pipelines to extract data from various source systems, ensuring integrity and efficiency.
• Modeling & Analysis: Design, develop, and tune complex data models to support business intelligence and analytical needs.
• Performance Optimization: Expertly manage stored procedures and data loads, identifying bottlenecks and implementing performance-tuning strategies to ensure low latency.
• Application Development: Utilize Python and Streamlit to build interactive data tools and internal applications.

Technical Requirements

Must-Haves

• Education: Bachelor’s degree in any major.
• Experience: Minimum of 10 years of professional experience in data engineering, database administration, or a related field.
• Core Technical Stack: Advanced proficiency in:
  • Languages: SQL and Python.
  • Platforms: Snowflake and Databricks.
  • ERP Systems: S/4HANA and SAP.
  • Visualization/Apps: Streamlit.

Nice-to-Haves

• Experience with Infrastructure as Code (IaC) using Terraform.
• Experience with data transformation workflows using dbt.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.