Staff Analytics Engineer (AI/LLM)

Location: Hybrid in Dundee, United Kingdom; 2–3 days per week in the Dundee hub.

Company

hirify.global provides an end-to-end cyber resilience platform with AI-powered capabilities to help businesses manage, secure, and recover.

What you will do

• Design and build governed Snowflake Semantic Views with logical tables, relationships, facts, dimensions, metrics, and synonyms for AI-agent business question answering.
• Build evaluation harnesses using golden-question datasets, LLM-as-a-judge scoring, and side-by-side release-gating runs.
• Implement logging, monitoring, lineage, observability, governance, and data quality across semantic layers, upstream pipelines, and data products.
• Curate verified query repositories and custom instructions to improve answer accuracy.
• Develop dynamic Streamlit applications and lightweight data products, including modernization of legacy Tableau and Power BI dashboards.
• Cross-train BI analysts to maintain domain models and partner with data engineering and governance teams on certification, stewardship, and CDE requirements.

Requirements

• 8–12 years of experience in business analytics and data engineering, including at least 1 year building semantic models or LLM-grounded analytics.
• Track record of shipping reusable data products adopted by other teams.
• Deep SQL and dimensional or semantic modeling expertise covering facts, dimensions, metrics, and conformed entities.
• Hands-on experience with a semantic layer such as Snowflake Semantic Views, dbt Semantic Layer, LookML, or a similar technology.
• Hands-on Snowflake experience, ideally including Cortex Analyst, Cortex Agents, and Cortex Search, or comparable text-to-SQL and RAG systems.
• Strong Python and analytics-engineering fundamentals across Snowflake dynamic tables, streams, tasks, Snowpark, Git workflows, CI/CD, and automated testing.
• Experience shipping documented, maintainable, and reviewable code.
• Fluency with AI-assisted coding tools such as Snowflake Cortex Code or Claude Code as a daily delivery tool.
• Experience evaluating production LLM applications with test datasets, LLM-as-a-judge or programmatic scoring, and iterative improvement based on results.
• Experience building dynamic interactive data applications with Streamlit or a similar tool, plus sufficient Tableau and Power BI experience to migrate and modernize reporting.
• Strong communication skills, including running working sessions with BI analysts, translating ambiguous business needs into precise certified definitions, and cross-training peers.

Nice to have

• Spec-driven development experience.
• Familiarity with Monte Carlo or a similar data observability platform.

Culture & Benefits

• Hybrid working model based on trust and flexibility.
• Medical, dental, and vision coverage.
• Generous paid time off and observed holidays.
• Two paid volunteer days per year.
• Employee Stock Purchase Program.
• Learning programs, giving opportunities, and employee fundraising activities.