Data Analytics Engineer

Ruby Labs; United States; Remote; USD 110,000 - 165,000; Full time

Job summary

Ruby Labs is seeking a Data Analytics Engineer to build and maintain the analytical data layer that powers decision making across the organization. You will transform business requirements into clean, well‑modeled datasets using dbt, SQL, and cloud warehouses such as BigQuery and ClickHouse.

You will design data models, implement data quality tests, document datasets and lineage, and collaborate with analysts, engineers, and product teams to ensure reliable reporting and governance across the

Qualifications

• Strong SQL experience with a deep understanding of analytical modeling concepts.
• Hands-on experience with dbt (models, tests, docs, macros)
• Experience working with cloud data warehouses such as BigQuery or ClickHouse
• Understanding of data modeling patterns
• Familiarity with data engineering concepts (ELT/ETL, orchestration, version control, CI/CD)
• Experience with data quality frameworks or implementing validation logic
• Ability to translate complex business processes into clean analytical datasets.
• Strong documentation skills and attention to detail
• Experience collaborating with cross-functional teams and supporting analysts with reliable data
• Knowledge of Python is a plus (but not required)

Responsibilities

• Design, build, and maintain dbt models (staging, core, marts) based on business needs
• Develop scalable SQL transformations and ensure efficient, cost‑effective query performance
• Implement data quality tests (dbt tests, custom checks, anomaly detection) and maintain high data reliability
• Create and maintain documentation for datasets, data lineage, business logic, and transformation rules
• Collaborate with Data Engineers on improving raw data structures, ingestion patterns, and source readiness
• Partner with Data Analysts, Product Managers, and Marketing teams to translate business requirements into clean, reusable data models
• Monitor data pipelines and marts, resolve issues, and prevent inconsistencies in reporting
• Support governance initiatives: naming conventions, taxonomy, schemas, metric definitions, and standardization
• Contribute to continuous improvement of our data modeling frameworks, performance tuning, and technical decision‑making

Skills

SQL

dbt

Data modeling

Data quality

Documentation

Cross-functional collaboration

Python (optional)

BigQuery

ClickHouse

Tools

BigQuery

ClickHouse

dbt

Job description

About usRuby Labs is a leading tech company that creates and operates innovative consumer products. We offer a diverse range of opportunities across the health, education, and entertainment industries. Our innovative teams are driving the future of consumer-led products, and we're always looking for passionate individuals to join us. Learn more about our story at: https://rubylabs.com/about-us

About the role

We are looking for a Data Analytics Engineer to build, optimize, and maintain the analytical data layer that powers decision‑making across the organization. You will transform business requirements into reliable, well‑modeled datasets using dbt, SQL, and cloud data warehouses (BigQuery, ClickHouse). This role combines data modeling, documentation, data quality design, and close collaboration with analysts, engineers, and product teams to ensure consistent, trustworthy reporting. You will serve as the bridge between raw data ingestion and analytics — shaping how data is structured, validated, and delivered.

Responsibilities

• Design, build, and maintain dbt models (staging, core, marts) based on business needs
• Develop scalable SQL transformations and ensure efficient, cost‑effective query performance
• Implement data quality tests (dbt tests, custom checks, anomaly detection) and maintain high data reliability
• Create and maintain documentation for datasets, data lineage, business logic, and transformation rules
• Collaborate with Data Engineers on improving raw data structures, ingestion patterns, and source readiness
• Partner with Data Analysts, Product Managers, and Marketing teams to translate business requirements into clean, reusable data models
• Monitor data pipelines and marts, resolve issues, and prevent inconsistencies in reporting
• Support governance initiatives: naming conventions, taxonomy, schemas, metric definitions, and standardization
• Contribute to continuous improvement of our data modeling frameworks, performance tuning, and technical decision‑making

Requirements

• Strong SQL experience with a deep understanding of analytical modeling concepts
• Hands‑on experience with dbt (models, tests, docs, macros)
• Experience working with cloud data warehouses such as BigQuery or ClickHouse
• Understanding of data modeling patterns
• Familiarity with data engineering concepts (ELT/ETL, orchestration, version control, CI/CD)
• Experience with data quality frameworks or implementing validation logic
• Ability to translate complex business processes into clean analytical datasets.
• Strong documentation skills and attention to detail
• Experience collaborating with cross‑functional teams and supporting analysts with reliable data
• Knowledge of Python is a plus (but not required)

Nice To Haves

• Experience with orchestration tools (Airflow, Dagster)
• Experience working with marketing, product, or billing datasets
• Exposure to metric layers, semantic layer design, or BI governance
• Basic understanding of observability tooling (Grafana, Prometheus, ... )
• Experience optimizing BigQuery costs or ClickHo