Data Analytics Engineer: BigQuery & Real-Time Dashboards

Slang AI; New York (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

Slang AI in New York City is seeking a Data Analytics Engineer to build and scale our analytics infrastructure from ingestion to dashboards. You will own pipelines, transformations, and reporting layers to reveal insights about our product, customers, and business metrics.

You’ll collaborate with product engineering to instrument features, optimize data contracts, and keep the data warehouse fast and cost-efficient, with opportunities to move toward real-time analytics as the platform evolves.

Qualifications

• 5+ years of experience in data engineering, BI analytics, or software engineering.
• Expert-level SQL skills, particularly in BigQuery or comparable cloud data warehouses.
• Hands-on experience with dbt (dbt Cloud preferred) for managing transformation pipelines.
• Experience with data ingestion tools such as Airbyte, Fivetran, or similar.
• Experience with reverse ETL tools such as Hightouch or Census.
• Working knowledge of Python for data scripting, automation, and ad-hoc analysis.
• Experience building and maintaining dashboards in Looker Studio or similar BI tools.
• Strong understanding of event-driven data instrumentation and how analytics contracts should be defined alongside product features.
• Track record of optimizing data warehouse costs and query performance.
• Comfort working directly with engineering teams to define data requirements and instrumentation standards.

Responsibilities

• Build and maintain analytics pipelines in BigQuery using dbt Cloud, including staging, transformation, and mart layers.
• Manage and configure Airbyte ingestion streams and Hightouch reverse ETL syncs.
• Partner with product engineering to ensure new features follow our event‑driven instrumentation methodology and emit the right data from day one.
• Define and maintain business logic for metrics construction, serving as the source of truth for how key metrics are calculated.
• Build, update, and maintain internal dashboards in Looker Studio.
• Build and maintain BigQuery datasets, views, and scheduled queries.
• Monitor and optimize query performance and warehouse costs, proactively identifying opportunities to reduce spend.
• Design and implement data backup and redundancy strategies.
• Make occasional updates to the customer‑facing dashboard layer in the product (TypeScript).
• Perform ad‑hoc data analysis and produce one‑off data pulls for customers as needed.
• Identify recurring data requests and build automated, self‑serve solutions to replace manual fulfillment.
• Investigate BigQuery continuous queries for publishing metrics to Cloud Pub/Sub, enabling product engineering services to consume analytics data in near real‑time.
• Evaluate Cloud Dataflow for real‑time and low‑latency data processing use cases as the platform's needs evolve.

Skills

SQL

BigQuery

dbt Cloud

Airbyte

Hightouch

Python

Looker Studio

Event-driven instrumentation

Data warehousing

Cost optimization

Tools

dbt Cloud

BigQuery

Airbyte

Hightouch

Looker Studio

Python

Cloud Pub/Sub

Cloud Dataflow

Job description

Slang AI in New York City is seeking a Data Analytics Engineer to build and scale our analytics infrastructure from ingestion to dashboards. You will own pipelines, transformations, and reporting layers to reveal insights about our product, customers, and business metrics.

You’ll collaborate with product engineering to instrument features, optimize data contracts, and keep the data warehouse fast and cost-efficient, with opportunities to move toward real-time analytics as the platform evolves.