Data Engineer II — AI-Driven Analytics & Dashboards (Remote)

Doist; New York (NY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive salary range

Healthcare

Remote/hybrid options

Personal development budgets

18 days PTO

10 paid sick days

Job summary

Scan.com is looking for a data-driven professional to own end-to-end data workflows, from raw sources to decision-ready assets. You will transform data with dbt, build reliable pipelines in Snowflake, and deliver Tableau dashboards used across operations and product teams.

You will partner with stakeholders, maintain data quality, and contribute to CI/CD data infra while potentially tackling data science projects as needed. Hybrid/remote options available in the US.

Qualifications

• Strong SQL: you write complex queries fluently, understand query performance, and don't need a template to construct a multi‑stage transformation.
• Hands‑on experience with a modern data transformation tool, ideally dbt or SQLMesh. You understand the model DAG, have written tests and documentation, and are familiar with CI/CD practices in a transformation layer
• Experience with a modern cloud data warehouse, ideally Snowflake or BigQuery — you understand how storage and compute interact and can write warehouse‑idiomatic SQL

Responsibilities

• Build and maintain dbt models that transform raw source data into reliable, well-documented, tested analytical assets used across the business
• Partner with stakeholders across Operations, Finance, Marketing, Sales, and Product to translate ambiguous business questions into precise analytical deliverables. You should be able identify if the ask needs refinement before the work begins
• Design and ship Tableau dashboards and data products that automate reporting that currently requires manual effort, permanently removing recurring analytical burden from the team
• Identify gaps in our data coverage and work with engineering or independently to close them. This can mean writing a Python ingestion pipeline or modeling a new source
• Maintain data quality standards across the warehouse: write dbt tests, monitoring for anomalies, and ensuring that the numbers stakeholders see are trustworthy
• Contribute to the team's analytical infrastructure. This means shared macros, source definitions, documentation standards, and CI/CD practices
• Stretch into various data science or data engineering projects based on business demand and based on your own personal development: pipeline development, ML feature preparation, or predictive modeling.

Skills

SQL

Python

dbt

Tableau

Snowflake

GitHub

Tools

Snowflake

Tableau

dbt

Job description

Scan.com is looking for a data-driven professional to own end-to-end data workflows, from raw sources to decision-ready assets. You will transform data with dbt, build reliable pipelines in Snowflake, and deliver Tableau dashboards used across operations and product teams.

You will partner with stakeholders, maintain data quality, and contribute to CI/CD data infra while potentially tackling data science projects as needed. Hybrid/remote options available in the US.