Senior Analytics Engineer/Data Engineer, TradingView

• 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
• If you are passionate about building the data foundation that powers an entire organisation, we would love to hear from you!

Desirable

• 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
• 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