The project is a global leader in sports, music, travel, culture, and more. It creates and delivers extraordinary experiences by providing official access and premium hospitality at marquee global sporting events, global music tours, etc.
Requirements: * 5+ years building dimensional data models in production (facts and dimensions) * Expert SQL + dbt with deep understanding of materialization strategies (views, tables incremental) * Snowflake production experience * Git workflows: pull requests, code review, peer review collaboration * Code quality adherence: linting, pre-commit hooks, following team conventions * Strong data validation and quality assurance skills * Experience debugging and correcting transformation logic * Can deliver independently with minimal supervision while collaborating effectively with Analytics/Data Platform teams * Portfolio required: GitHub or similar showing dimensional modeling/dbt work
Nice to Have: * E-commerce/ticketing/transactional business experience * Experience with cross-system data reconciliation * BI platform integration knowledge (Tableau, Omni Analytics, Looker) * US Central timezone overlap availability
Key Responsibilities: * Build dimensional analytics infrastructure (dbt + Snowflake) for a high-volume live events ticketing & hospitality business. * Transform existing Snowflake source data into production-ready BI models for commercial strategy, pricing, and revenue optimization. * Significant validation and data quality work required to handle complex business logic, null handling, and cross-system reconciliation.
We offer: * Big stable project with a professional team. * Enterprise project. * Friendly and supportive work environment. * Competitive salary and benefits package. * Room for personal and professional growth. * Zero bureaucracy. * 18 business days of paid vacation + public holidays compensation. * Insurance Fund of the company. * Coverage of all professional studies. * Coverage of sick leaves, sports activities, and English language courses.
If you believe this role could be a great match for you, please send us your resume via the link — we’ll be happy to get in touch with you.