Data Engineer II: Build Scalable Data Pipelines & Products

Gilbane Building Company; Chicago (IL); On-site; USD 140,000 - 170,000; Full time

Benefits offered by this job

Health and welfare benefits

Profit-sharing/401k

Gilbane University training

Job summary

Gilbane Building Company seeks a Data Engineer II in Chicago, IL to design, build, test, deploy, and support scalable data pipelines and analytics components. This role translates business and analytical requirements into secure, reliable solutions and partners with data, technology, and business teams to improve data accessibility and quality.

You will mentor junior engineers and contribute to reusable data engineering patterns, while applying strong SQL and Python skills to ETL/ELT pipelines

Qualifications

• Bachelor's degree or higher in a related field.
• 3-5 years of relevant data engineering or related experience.
• Experience building production ETL/ELT pipelines and data models.
• Strong SQL and proficiency in Python, Scala, or Java.

Responsibilities

• Own defined data engineering solutions from requirements and design through deployment, monitoring, and support.
• Build and optimize ETL/ELT pipelines, integrations, data models, APIs, and batch or near-real-time workflows.
• Translate business rules and source-system behavior into maintainable technical designs and mappings.
• Implement automated testing, reconciliation, observability, alerting, metadata, and lineage for assigned solutions.
• Tune data pipelines, storage, and queries for reliability, scalability, performance, and cost effectiveness.
• Troubleshoot production incidents, perform root-cause analysis, remediate defects, and prevent recurrence.
• Apply CI/CD, version control, code review, documentation, security, privacy, and governance standards.
• Partner with analytics, BI, data science, architecture, product, and business teams to deliver usable data products.
• Identify opportunities to automate manual flows and create reusable engineering patterns.
• Mentor junior engineers through technical guidance, code review, and knowledge sharing.

Skills

SQL

Python

Scala/Java

Data pipelines

Education

Bachelor's degree in computer science / information systems / engineering / mathematics / statistics

Tools

Cloud data platform

Orchestration tool

CI/CD

Job description

Gilbane Building Company seeks a Data Engineer II in Chicago, IL to design, build, test, deploy, and support scalable data pipelines and analytics components. This role translates business and analytical requirements into secure, reliable solutions and partners with data, technology, and business teams to improve data accessibility and quality.

You will mentor junior engineers and contribute to reusable data engineering patterns, while applying strong SQL and Python skills to ETL/ELT pipelines