Remote Analytics Engineer: AI-Driven Data Modeling

Prolific; United States; Remote; USD 130,000 - 170,000; Full time

Job summary

Prolific is seeking an Analytics Engineer to build complex dbt models and a semantic layer for natural language querying. You will productionise LLM-powered steps, design agentic workflows, and ensure data integrity across BI analytics.

You will mentor junior engineers, collaborate with product, engineering, and BI teams, and uphold high data quality with robust tests and documentation.

Qualifications

• Deep experience with dbt and SQL to design, build, and maintain scalable data models.
• Experience defining metrics and business logic in a semantic layer (dbt Semantic Layer/MetricFlow, Cube, LookML or similar).
• Hands-on use of LLMs in data work, with evaluation and governance of outputs that aren’t fully deterministic.
• Familiarity with AI coding assistants and agents and where they speed analytics engineering and where human review is essential.
• Strong familiarity with cloud platforms such as AWS or GCP.
• Passion for data quality through tests, assertions, evaluations, and robust documentation.
• Ability to understand business needs and communicate with non-technical stakeholders.
• Skilled at cross-functional collaboration and translating complex technical concepts into actionable insights.
• Design repeatable, scalable data transformation workflows combining automated agents with human oversight.

Responsibilities

• Build complex dbt models, custom macros, and reusable packages with robust tests.
• Design and maintain a semantic layer with defined metrics and dimensions.
• Productionise LLM-powered steps in pipelines with evaluation, cost, latency monitoring, and fallbacks.
• Create agentic workflows across analytics lifecycle, with guardrails and review processes.
• Monitor and maintain dbt workflow jobs and data models powering BI analytics.
• Write tests and assertions to validate data integrity and measure NL/LLM output accuracy.
• Document dbt processes and semantic definitions, treating metadata as a first-class asset.
• Translate technical data issues into clear business terms for stakeholders.
• Mentor junior analysts and data engineers, guiding AI tooling adoption and best practices.

Skills

dbt & SQL

Semantic modelling

Applied AI in data workflows

Agentic tooling

Cloud platforms (AWS/GCP)

Data quality & testing

Business communication

Cross-functional collaboration

Process-driven workflows

Tools

dbt

LookML

Cube

SQL tooling

Job description

Prolific is seeking an Analytics Engineer to build complex dbt models and a semantic layer for natural language querying. You will productionise LLM-powered steps, design agentic workflows, and ensure data integrity across BI analytics.

You will mentor junior engineers, collaborate with product, engineering, and BI teams, and uphold high data quality with robust tests and documentation.