Data Engineer II

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

Data Engineer II

Job Locations

US-RI-Providence | US-MA-Boston | US-GA-Atlanta | US-FL-Orlando | US-IL-Chicago | US-OH-Columbus | US-NC-Charlotte | US-CT-Glastonbury

The Data Engineer II independently designs, builds, tests, deploys, and supports scalable data pipelines, integrations, models, and reusable platform components. This role translates defined business and analytical requirements into secure, reliable solutions and partners across data, technology, and business teams to improve data accessibility and quality.

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.

Qualifications

• Bachelor's degree in computer science, information systems, engineering, mathematics, statistics, or a related field.
• 3-5 years of relevant experience in data engineering, software engineering, business intelligence, analytics engineering, or data platform development.
• Experience building and supporting production ETL/ELT pipelines, data models, warehouses, lakes, or lakehouses.
• Strong SQL and proficiency in Python, Scala, Java, or a similar language.
• Experience with a cloud data platform, orchestration tool, and automated testing or CI/CD preferred.
• Or equivalent combination of education and experience.

Visa Sponsorship: This position is not eligible for employment visa sponsorship. Applicants must be authorized to work in the United States without current or future sponsorship.

Salary to be determined based on factors such as geographic location, skills, education, and/or experience of the applicant, as well as the internal equity and alignment with the team.

The pay ranges from $140,000.00-$170,000.00 plus benefits and retirement program.

Gilbane offers an excellent total compensation package which includes competitive health and welfare benefits and a generous profit-sharing/401k plan. We invest in our employees' education and have built Gilbane University into a top training organization in the construction industry. Qualified applicants who are offered a position must pass a pre-employment substance abuse test.

Gilbane is an Affiratively Action/Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, color, national origin, race, religion, sex, sexual orientation, gender identity, protected veteran status, or disability status. Click here to view the physical demands and working conditions required to perform this role. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential job functions.