Data Engineer II: Build Scalable Pipelines & Data Solutions

Gilbane Building; Boston (MA); On-site; USD 140,000 - 170,000; Full time

Benefits offered by this job

Health benefits

401k plan

Profit-sharing

Job summary

You will own end-to-end data solutions, optimize pipelines, implement automated testing, and mentor junior engineers while applying governance and security standards. This role offers a competitive compensation package and strong growth opportunities within Gilbane's data platform practice.

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.

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

Strong SQL

Python

Scala/Java

Education

Bachelor's degree in CS/related field

Tools

Cloud data platform

Orchestration tool

CI/CD

Job description

You will own end-to-end data solutions, optimize pipelines, implement automated testing, and mentor junior engineers while applying governance and security standards. This role offers a competitive compensation package and strong growth opportunities within Gilbane's data platform practice.