Babel Street

Data Warehouse Software Engineer

Who can apply: Only open to applicants in: Massachusetts.
Location as listed by the employer: “Somerville, Massachusetts, United States; Somerville, MA - Hybrid”
Apply on Babel Street's site ↗

Opens the employer's official application page.

Generate a CV for this job

A CV tailored to this job's requirements in one click — boosted with testimonials from people who know your work.

Generate my CV

About this role

Babel Street is hiring for a Data Warehouse Software Engineer role. See the official posting for full details.

Requirements

  • Data Pipelines & Modeling: Assist in building and maintaining data models and tables inside Google BigQuery. Help write and update foundational SQL transformation logic to support business analytics.
  • Business Analysis & Collaboration: Partner with analysts and business stakeholders to understand their data and reporting needs, translating those requirements into clean, structured tables and views.
  • Business Intelligence: Build, manage, and optimize Looker dashboards and reports, ensuring business users can easily access actionable data.
  • Data Quality & Attention to Detail: Ensure data integrity and consistency across data marts by writing validation queries and row-count checks to catch discrepancies early.
  • Pipeline Monitoring: Help monitor and maintain basic Apache Airflow (Cloud Composer) DAGs written in Python, ensuring daily data loads run smoothly.
  • Performance Basics: Learn and apply standard query optimization techniques, including BigQuery partitioning and clustering best practices.
  • Foundational SQL Skills: Strong command of SQL (joins, aggregations, and familiarity with window functions).
  • Data Warehouse Exposure: A solid conceptual understanding of relational databases, ETL/ELT concepts, and standard data warehousing structures (tables, views, and data lakes).

Summarized from the employer's posting — check the full posting for every requirement.