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

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