Senior Analytics Engineer: Data Modeling & AI

Jobtailor; Jersey City (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor seeks an experienced analytics engineer to design and implement scalable data models on BigQuery, leveraging dbt and AI-assisted workflows. You will own the semantic layer in Lightdash and define trusted metrics for the business.

Collaborate with cross-functional partners, advance governance, and enable self-serve analytics across the organization using Python, SQL, and CI/CD practices.

Qualifications

• 5+ years in analytics engineering or equivalent role.
• Proficient with dbt and software engineering practices.
• Experience with BigQuery or equivalent cloud warehouse.
• Experience with Lightdash or similar BI tools.
• Proficient in SQL and Python; familiar with CI/CD and testing.

Responsibilities

• Design and build data models and transformations in dbt on BigQuery.
• Own semantic layer in Lightdash with metrics and governed datasets.
• Lead data modeling standards, reviews, and documentation.
• Develop end-to-end with AI coding agents and AI-assisted workflows.
• Enable AI-driven analytics with governance as foundation.
• Advance metric governance and ensure auditability.
• Partner with stakeholders to gather requirements and ship models.
• Train users on self-serve analytics across the business.

Skills

Analytics engineer

dbt

Google BigQuery

SQL

Python

Data Governance

CI/CD

Testing

Tools

Lightdash

Looker

Claude Code

CI/CD Tools

Job description

Jobtailor seeks an experienced analytics engineer to design and implement scalable data models on BigQuery, leveraging dbt and AI-assisted workflows. You will own the semantic layer in Lightdash and define trusted metrics for the business.

Collaborate with cross-functional partners, advance governance, and enable self-serve analytics across the organization using Python, SQL, and CI/CD practices.