Data Warehouse Software Engineer

Babel Street • Somerville, MA

1d • $70,000 - $80,000 • Hybrid

About The Position

Babel Street is seeking a motivated Software Engineer I to join their data team. This entry-level role focuses on building, maintaining, and supporting core data warehouse solutions on Google Cloud Platform (GCP). The engineer will collaborate with data analysts and business stakeholders to translate reporting requests into clean data models and Looker dashboards. This position is ideal for a self-starter with strong SQL skills, an aptitude for business analysis, and meticulous attention to detail. The role is hybrid and based in the Somerville, MA office.

Requirements

• 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).
• BI / Looker Experience: Hands-on experience or academic exposure to building dashboards in Looker (or similar BI tools like Tableau/PowerBI).
• Basic Python & Git: Familiarity with Python for basic scripting/automation and comfort using Git for version control.
• The Mindset (Self-Starter): A proactive learner who takes initiative to solve problems and figures out how things work.
• Analytical Nature: The ability to look at a business problem, analyze the underlying data requirements, and implement a structured solution.
• Attention to Detail: Deep care for data quality—you are someone who double-checks your query results and takes pride in data accuracy.

Responsibilities

• Assist in building and maintaining data models and tables inside Google BigQuery.
• Help write and update foundational SQL transformation logic to support business analytics.
• Partner with analysts and business stakeholders to understand their data and reporting needs, translating those requirements into clean, structured tables and views.
• Build, manage, and optimize Looker dashboards and reports, ensuring business users can easily access actionable data.
• Ensure data integrity and consistency across data marts by writing validation queries and row-count checks to catch discrepancies early.
• Help monitor and maintain basic Apache Airflow (Cloud Composer) DAGs written in Python, ensuring daily data loads run smoothly.
• Learn and apply standard query optimization techniques, including BigQuery partitioning and clustering best practices.

Benefits

• Health Benefits: Babel Street covers 85-100% monthly premium costs for Medical, Dental, Vision, Life & Disability insurances – for you and your family!
• Retirement Plans: Babel Street offers both a Traditional and Roth 401(K) with a very competitive match.
• Unlimited Flexible Leave: We trust our employees to manage their own time and balance their personal and work lives.
• Holidays: Babel Street provides employees with 12 paid Federal Holidays
• Tuition Reimbursement: We are committed to investing in our employees. One way we do that is with our Tuition Reimbursement Program for continuing education.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed