Babel Street - Data Warehouse Software Engineer I
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). • Data Warehouse Exposure: • 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. • Basic Python & Git: • The Mindset (Self-Starter): A proactive learner who takes initiative to solve problems and figures out how things work. • The Mindset (Self-Starter): • Analytical Nature: The ability to look at a business problem, analyze the underlying data requirements, and implement a structured solution. • Analytical Nature • Attention to Detail: Deep care for data quality—you are someone who double-checks your query results and takes pride in data accuracy. • Attention to Detail • Benefits at Babel Street (just to name a few...) • 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.
Responsibilities
• 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. • Data Pipelines & Modeling: • 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 Analysis & Collaboration: • Business Intelligence: Build, manage, and optimize Looker dashboards and reports, ensuring business users can easily access actionable data. • Business Intelligence: • 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. • Data Quality & Attention to Detail: • Pipeline Monitoring: Help monitor and maintain basic Apache Airflow (Cloud Composer) DAGs written in Python, ensuring daily data loads run smoothly. • Pipeline Monitoring: • Performance Basics: Learn and apply standard query optimization techniques, including BigQuery partitioning and clustering best practices. • Performance Basics:
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT