Data Warehouse Software Engineer at Babel Street

Somerville, Massachusetts, United StatesFull-timeProduct DevelopmentPosted about 2 months ago

About the Role

<div class="content-intro">Babel Street is the trusted technology partner for the world’s most advanced identity intelligence and risk operations. We deliver advanced AI and data analytics solutions providing unmatched, analysis-ready data regardless of language, proactive risk identification, 360-degree insights, high-speed automation, and seamless integration into existing systems. Babel Street empowers government and commercial organizations to transform high-stakes identity and risk operations into a strategic advantage.  <span class="NormalTextRun SCXW87951667 BCX0" data-ccp-charstyle="ui-provider" data-ccp-charstyle-defn="{"ObjectId":"725404ee-fdf0-4ab9-84d3-4e5e881c471f|34","ClassId":1073872969,"Properties":[469775450,"ui-provider",201340122,"1",134233614,"true",469778129,"ui-provider",335572020,"1",469778324,"Default Paragraph Font"]}">The actionable insights we deliver safeguard lives and protect critical assets around the world.  Babel Street is headquartered in Reston, Virginia, with regional offices in Boston, MA and Cleveland, OH, and international offices in Australia, Canada, Israel, Japan, and the U.K. For more information, visit <a class="Hyperlink SCXW87951667 BCX0" href="http://www.babelstreet.com/" target="_blank">www.babelstreet.com</a>. </div>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 <ul> <li data-leveltext="" data-font="Symbol" data-listid="20" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">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.</li> <li data-leveltext="" data-font="Symbol" data-listid="20" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">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.</li> <li data-leveltext="" data-font="Symbol" data-listid="20" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Business Intelligence: Build, manage, and optimize Looker dashboards and reports, ensuring business users can easily access actionable data.</li> <li data-leveltext="" data-font="Symbol" data-listid="20" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">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.</li> <li data-leveltext="" data-font="Symbol" data-listid="20" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Pipeline Monitoring: Help monitor and maintain basic Apache Airflow (Cloud Composer) DAGs written in Python, ensuring daily data loads run smoothly.</li> <li data-leveltext="" data-font="Symbol" data-listid="20" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Performance Basics: Learn and apply standard query optimization techniques, including BigQuery partitioning and clustering best practices. </li> </ul> Job Requirements:  <ul> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Foundational SQL Skills: Strong command of SQL (joins, aggregations, and familiarity with window functions).</li> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Data Warehouse Exposure: A solid conceptual understanding of relational databases, ETL/ELT concepts, and standard data warehousing structures (tables, views, and data lakes).</li> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">BI / Looker Experience: Hands-on experience or academic exposure to building dashboards in Looker (or similar BI tools like Tableau/PowerBI).</li> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Basic Python & Git: Familiarity with Python for basic scripting/automation and comfort using Git for version control.</li> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">The Mindset (Self-Starter): A proactive learner who takes initiative to solve problems and figures out how things work.</li> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Analytical Nature: The ability to look at a business problem, analyze the underlying data requirements, and implement a structured solution.</li> <li data-leveltext="" data-font="Symbol" data-listid="21" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Attention to Detail: Deep care for data quality—you are someone who double-checks your query results and takes pride in data accuracy. </li> </ul> Benefits at Babel Street (just to name a few...) <ul> <li>Health Benefits: Babel Street covers 85-100% monthly premium costs for Medical, Dental, Vision, Life & Disability insurances – for you and your family!</li> <li>Retirement Plans: Babel Street offers both a Traditional and Roth 401(K) with a very competitive match.</li> <li>Unlimited Flexible Leave: We trust our employees to manage their own time and balance their personal and work lives.</li> <li>Holidays: Babel Street provides employees with 12 paid Federal Holidays</li> <li>Tuition Reimbursement: We are committed to investing in our employees. One way we do that is with our Tuition Reimbursement Program for continuing education.                 </li> </ul> Babel Street is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. Further, Babel Street will not discriminate against applicants for inquiring about, discussing or disclosing their pay or, in certain circumstances, the pay of their co‐worker, <a href="https://www.dol.gov/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf">Pay Transparency Nondiscrimination</a>. In addition, Babel Street's policy is to provide reasonable accommodation to qualified employees who have protected disabilities to the extent required by applicable laws, regulations and ordinances where a particular employee works. Upon request, we will provide you with more information about such accommodations.  <div class="content-pay-transparency"><div class="pay-input"><div class="title">Range for this position based on qualifications and experience</div><div class="pay-range">$70,000—$80,000 USD</div></div></div><div class="content-conclusion">     </div>

About the Role

Related Roles