Babel StreetRemote
Data Warehouse Software Engineer I
United States of America
Full Time
2 hours ago
$70,000 - $80,000 USD
H1B Sponsor Likely
Key skills
SQLGoogle BigQueryData WarehousingETL/ELTLookerTableauPower BIPythonGitApache AirflowCloud ComposerAnalytical NatureETLELTAnalyticsBIBigQueryAirflowBabelGoogle CloudcomposerVersion Control
About this role
Babel Street is the trusted technology partner for advanced identity intelligence and risk operations. They are seeking a Software Engineer I to join their data team, where the candidate will help build and maintain core data warehouse solutions on Google Cloud Platform and collaborate with data analysts to translate reporting requests into effective data models.
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
Requirements:
- Strong command of SQL (joins, aggregations, and familiarity with window functions)
- A solid conceptual understanding of relational databases, ETL/ELT concepts, and standard data warehousing structures (tables, views, and data lakes)
- Hands-on experience or academic exposure to building dashboards in Looker (or similar BI tools like Tableau/PowerBI)
- Familiarity with Python for basic scripting/automation and comfort using Git for version control
- A proactive learner who takes initiative to solve problems and figures out how things work
- The ability to look at a business problem, analyze the underlying data requirements, and implement a structured solution
- Deep care for data quality—you are someone who double-checks your query results and takes pride in data accuracy