Job Description

Orgvue is an organizational design and planning platform that empowers businesses to transform their workforce by understanding the work people do and the skills they have. Our platform connects strategy to structure, providing clarity of vision, so leaders can build a more adaptable, better performing organization that thrives in a constantly changing world of work.

The world’s largest and best-known enterprises and consulting firms use Orgvue to visualize and model current and future states of the organization and make faster, more informed decisions. The company is headquartered in London, with offices in Philadelphia, The Hague, Toronto, and Sydney.

The Data & Insight Engineer will build and own an AI-native analytics environment where insights are generated automatically from data rather than manually through dashboards and reports.

This role combines data engineering, analytics engineering, and AI-enabled insight generation. Responsibilities include building semantic data models, developing automated insight pipelines, and integrating Snowflake Cortex capabilities to support conversational analytics and AI-driven business intelligence.

Responsibilities

Data Pipeline Engineering

• Build and maintain robust data ingestion and transformation pipelines
• Integrate data from operational systems into the analytics platform
• Maintain data quality frameworks and validation checks
• Optimise performance of data processing and analytics workloads

AI Insight Pipeline Development and ownership

• Automate recurring analysis traditionally performed manually
• Enable natural-language analytics across curated datasets
• Develop systems that translate business questions into structured data queries

Semantic Data Modelling

• Design and maintain curated business data models that support reliable analytics and AI-driven insights
• Define core business entities, metrics, and KPI definitions
• Build and maintain semantic layers within Snowflake

Governance and Quality Assurance

• Monitor model performance, accuracy, and cost usage
• Implement safeguards to ensure reliable and explainable outputs
• Maintain governance standards for AI-enabled analytics workflows

Requirements

• Strong SQL and data modelling expertise
• Experience working with Snowflake
• Experience with analytics engineering tools such as dbt
• Proficiency with Python or similar languages for data workflows
• Experience building and maintaining data pipelines
• Experience translating business questions into analytical models and metrics
• Experience working with analysts, product teams, and business stakeholders to support decision-making

Preferred but not essential

• Experience working with large language models (LLMs) or AI-enabled analytics platforms
• Familiarity with prompt design or AI-assisted analytical workflows
• Familiarity with Snowflake Intelligence

Benefits

• Hybrid working - 2 days a week in the London office
• Wellbeing: Sanctus Coaching, Virtual fitness sessions, Wellbeing webinars, Annual Wellbeing day

• Subsidised Gym Membership
• Private Medical Insurance (including Dental and Vision) and Life Assurance
• 25 days holiday (increasing to 30 days at a rate of 1 extra day per year)
• Employer pension contribution of 5% of your gross salary, if you contribute a minimum of 3%
• Season ticket Loan
• Cycle to Work Scheme
• Annual Discretionary Bonus

Here at Orgvue we promote individualism and a diverse workforce to build on our future success