27 days ago
Remote, United KingdomSenior
Responsibilities
- Build and optimize complex dbt models, custom macros, reusable packages, and SQL transformations.
- Design and maintain a semantic layer with reliable metrics, dimensions, business logic, and descriptions for BI and natural-language querying.
- Build and productionize LLM-powered data transformations such as text categorization and record enrichment.
- Develop agentic workflows for model generation, documentation, test coverage, code review, and incident triage with appropriate guardrails.
- Monitor and maintain dbt workflow jobs, data refreshes, pipelines, BI models, and company-level reporting data.
- Create tests, assertions, and evaluation sets to validate data integrity and LLM- or natural-language-driven output accuracy.
- Document and standardize dbt processes, semantic definitions, and metadata.
- Translate complex data concepts and issues into actionable information for non-technical stakeholders.
- Mentor junior analysts and data engineers on experimentation platforms, AI tooling, and data practices.
- Collaborate with product, engineering, and BI teams to support business and AI-driven product needs.
Requirements
- Deep experience with dbt and SQL for designing and maintaining scalable data models.
- Experience defining metrics, entities, and business logic in a semantic layer such as dbt Semantic Layer/MetricFlow, Cube, or LookML.
- Hands-on experience using LLMs in data workflows for classification, extraction, enrichment, or similar transformations.
- Understanding of evaluating, testing, and governing non-deterministic outputs.
- Familiarity with AI coding assistants and agents such as Claude Code, Cursor, and MCP-based tooling.
- Strong familiarity with cloud platforms such as AWS or GCP.
- Experience with data quality testing, assertions, evaluations, documentation, and reliable transformation workflows.
- Ability to understand commercial and business needs and communicate effectively with non-technical stakeholders.
- Skill in cross-functional collaboration and translating technical concepts into actionable insights.
- Proficiency designing repeatable, scalable workflows that combine automated agents with human oversight.
Benefits
- Competitive salary and benefits are offered.
- Remote working is available.
- The role provides access to Prolific’s human data platform and opportunities to work on AI innovation and research.
Tech Stack
Categories
Data Engineering
About Prolific
Prolific builds an online marketplace to recruit verified participants and collect human data for academic research, product studies, and AI model development. Researchers and companies design studies and tasks, pay participants, and Prolific charges platform and service fees; the company also supports data labeling and AI training workflows through managed and self-serve tools. Founded in 2014 and headquartered in London, it is privately held and used by tens of thousands of organizations worldwide.