Be at the heart of actionFly remote-controlled drones into enemy territory to gather vital information.

Apply Now

Senior Analytics Engineer/Data Engineer(for Semantic Layer)

TradingView Inc
City of London
4 days ago
Create job alert
Overview

We are seeking a talented and passionate Analytics Engineer to design, build, and own the semantic layer at the heart of our data platform. You will be the crucial bridge between our raw data infrastructure and our business users, transforming complex data into a single source of truth that is reliable, intuitive, and accessible.


Your primary focus will be on using dbt to create well-defined, performant data models and metrics to build out our dbt Semantic Layer. This will directly power our business intelligence tools and enable self-service analytics across the entire organisation. This is a high-impact role where you will define how the business measures success.


What You\'ll Do

  • Design, build, and maintain a scalable and robust semantic layer using dbt, serving as the single source of truth for all business metrics and dimensions.
  • Collaborate closely with business stakeholders from departments like Finance, Marketing, and Product to gather and define requirements, translating complex business logic into reliable and well-documented data models.
  • Develop and own our core analytics data models, applying strong knowledge of data warehouse modeling techniques. For example: Kimball, Inmon, Data Vault 2.0., Anchor Modeling (6NF approach), Activity Schema / Event Star, etc.
  • Write clean, performant, and maintainable SQL for our cloud data warehouse (Amazon Redshift & Athena).
  • Champion data quality and trust by implementing rigorous testing, data validation, and comprehensive documentation using tools like dbt test and dbt docs.
  • Partner with Data Engineers to advise on data ingestion and upstream data structures.
  • Work with Data Analysts and Metabase users to improve the usability of our BI platform and promote data literacy throughout the company.

Required Skills

  • Proven experience as an Analytics Engineer, Data Engineer with a strong focus on data modeling.
  • Expert-level proficiency in SQL and deep, hands-on experience with dbt, including Jinja, macros, and package management.
  • Demonstrated experience working with business stakeholders, gathering and defining requirements, and translating them into technical solutions.
  • Solid understanding of modern cloud data warehouses (e.g., Amazon Redshift, Snowflake, BigQuery).
  • A passion for creating order out of chaos and a drive to build systems that are trusted and easy to use.
  • Excellent communication skills and the ability to explain complex technical concepts to both technical and non-technical audiences.
  • Conversational Russian for effective communication with Russian-speaking colleagues.

Preferred Skills

  • Direct experience designing and building with the dbt Semantic Layer or LookML.
  • Hands-on experience with our specific stack: Redshift, Athena, Airflow and Metabase.
  • Familiarity with version control systems like Git.
  • Experience with Python for scripting and data analysis.

If you are passionate about building the data foundation that powers an entire organisation, we would love to hear from you!


We are ready to offer:

  • Hybrid work format
  • Relocation support
  • Working on a product used by millions of people worldwide
  • Competitive salary
  • Health insurance, 100% sick leave compensation, psychological support
  • Flexible schedule and balanced workload
  • Learning support: English classes, conferences, courses
  • Team events, corporate parties, sports, and team-building activities covered by the company


#J-18808-Ljbffr

Related Jobs

View all jobs

Senior Data Engineer

Assistant Data Engineer (Cabling)

Senior Data Engineer (Analytics & Reporting Team)

Lead Data Engineer

Lead Data Engineer

Finance Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Why Machine Learning Careers in the UK Are Becoming More Multidisciplinary

Machine learning (ML) has moved from research labs into mainstream UK businesses. From healthcare diagnostics to fraud detection, autonomous vehicles to recommendation engines, ML underpins critical services and consumer experiences. But the skillset required of today’s machine learning professionals is no longer purely technical. Employers increasingly seek multidisciplinary expertise: not only coding, algorithms & statistics, but also knowledge of law, ethics, psychology, linguistics & design. This article explores why UK machine learning careers are becoming more multidisciplinary, how these fields intersect with ML roles, and what both job-seekers & employers need to understand to succeed in a rapidly changing landscape.

Machine Learning Team Structures Explained: Who Does What in a Modern Machine Learning Department

Machine learning is now central to many advanced data-driven products and services across the UK. Whether you work in finance, healthcare, retail, autonomous vehicles, recommendation systems, robotics, or consumer applications, there’s a need for dedicated machine learning teams that can deliver models into production, maintain them, keep them secure, efficient, fair, and aligned with business objectives. If you’re hiring for or applying to ML roles via MachineLearningJobs.co.uk, this article will help you understand what roles are typically present in a mature machine learning department, how they collaborate through project lifecycles, what skills and qualifications UK employers look for, what the career paths and salaries are, current trends and challenges, and how to build an effective ML team.

Why the UK Could Be the World’s Next Machine Learning Jobs Hub

Machine learning (ML) is becoming essential to industries across the globe—from finance and healthcare to retail, logistics, defence, and the public sector. Its ability to uncover patterns in data, make predictions, drive automation, and increase operational efficiency has made it one of the most in-demand skill sets in the technology world. In the UK, machine learning roles—from engineers to researchers, product managers to analysts—are increasingly central to innovation. Universities are expanding ML programmes, enterprises are scaling ML deployments, and startups are offering applied ML solutions. All signs point toward a surging need for professionals skilled in modelling, algorithms, data pipelines, and AI systems. This article explores why the United Kingdom is exceptionally well positioned to become a global machine learning jobs hub. It examines the current landscape, strengths, career paths, sector-specific demand, challenges, and what must happen for this vision to become reality.