Junior Data Warehouse Engineer — GCP & Looker

Babel Street, Inc.; Somerville, Northern (MA, KY); Hybrid; USD 70,000 - 80,000; Full time

Benefits offered by this job

Health benefits

401(k) match

Unlimited flexible leave

Paid federal holidays

Tuition reimbursement

Job summary

Babel Street, Inc. is seeking a Software Engineer I in Somerville, MA to join the data team. You will build and maintain data warehouse solutions on Google Cloud, translate reporting needs into clean data models, and develop Looker dashboards.

This entry-level role suits a self-starter with strong SQL skills and business-analytic mindset. You will collaborate with analysts and stakeholders, ensure data quality, and learn performance optimizations like partitioning and clustering in BigQuery.

Qualifications

• Foundational SQL skills covering joins, aggregates, and window functions.
• Solid understanding of relational databases, ETL/ELT concepts, and data warehousing structures.

Responsibilities

• Data Pipelines & Modeling: Build and maintain data models/tables in Google BigQuery and update SQL transformations.
• Business Analysis & Collaboration: Translate stakeholder data needs into structured tables and views.
• BI / Looker: Create and optimize Looker dashboards and reports for business users.
• Data Quality: Write validation queries and row-count checks to ensure data integrity.
• Pipeline Monitoring: Monitor daily data loads and Cloud Composer DAGs in Python.
• Performance Basics: Apply partitioning and clustering to improve query performance.

Skills

SQL

Data warehousing

Looker BI

Python basics

Git

Attention to detail

Analytical mindset

Self-starter

Tools

BigQuery

Airflow/Cloud Composer

Job description

Babel Street, Inc. is seeking a Software Engineer I in Somerville, MA to join the data team. You will build and maintain data warehouse solutions on Google Cloud, translate reporting needs into clean data models, and develop Looker dashboards.

This entry-level role suits a self-starter with strong SQL skills and business-analytic mindset. You will collaborate with analysts and stakeholders, ensure data quality, and learn performance optimizations like partitioning and clustering in BigQuery.