Babel Street is hiring a Data Warehouse Software Engineer I for its data team in Somerville, Massachusetts. This entry-level opportunity is ideal for candidates who enjoy working with SQL, data warehouses, business intelligence, and cloud technologies. You’ll help build and maintain data models in Google BigQuery, support Looker dashboards, monitor data pipelines, and collaborate with analysts and business stakeholders. The role offers a $70,000–$80,000 annual salary and a hybrid work arrangement.
Job Overview
| Field | Details |
|---|---|
| Company Name | Babel Street |
| Role | Data Warehouse Software Engineer I |
| Qualification | Strong SQL skills; knowledge of relational databases, ETL/ELT and data warehousing; Looker or similar BI experience; basic Python and Git |
| Job Location | Somerville, Massachusetts, USA |
| Salary | $70,000–$80,000 per year |
| Work Type | Hybrid |
| Job Type | Full-time |
| Job Level | Entry Level |
| Industry | Software Development / Technology |
Job Description
We are looking for a motivated Software Engineer I to join our data team! In this role, you will help build, maintain, and support our core data warehouse solutions on Google Cloud Platform (GCP). You will collaborate closely with data analysts and business stakeholders to translate reporting requests into clean data models and Looker dashboards. This is an entry-level position perfect for a self-starter who possesses strong foundational SQL skills, an eye for business analysis, and sharp attention to detail. This would be a hybrid role out of our Somerville, MA office
- 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.
Job 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.
Selection Process
- Application Submission – Submit your resume/CV and required application information.
- Application Screening – Babel Street reviews your qualifications and relevant technical experience.
- Technical Assessment/Interview – Candidates may be evaluated on SQL, data warehousing, Python, analytics, and problem-solving skills.
- Hiring Interviews – Selected candidates may meet with technical team members and hiring managers.
- Final Selection & Offer – Successful candidates receive an offer and complete the hiring process.
How to Apply
- Review the Data Warehouse Software Engineer I requirements.
- Prepare an updated resume/CV highlighting SQL, Python, Git, databases, ETL/ELT, and BI experience.
- Open the official Babel Street job posting.
- Click “Apply Now.”
- Complete the required application fields and upload your resume/CV.
- Provide the requested employment eligibility and sponsorship information.
- Submit your application and wait for further communication from Babel Street.
