Jobs at Snowflake, Inc in United Kingdom

At EFG (ESL FACEIT Group) we create worlds beyond gameplay where players and fans become community. We pride ourselves in having a corporate social responsibility which is that "IT'S NOT GG, UNTIL IT'S GG FOR ALL". We are passionate about the culture we foster that ultimately helps to create and shape the world of esports, gaming tournaments, leagues, events and holistic ecosystems staged for our millions of players, fans and heroes.

The Team

The Data team is responsible for scaling and shaping EFG's data and information strategy across the organization. They ensure effective data utilization, quality, and lifecycle management to create substantial business value.

We're looking for an accomplished Analytics Engineer who knows that the true mark of intelligence and experience is kindness, and has the responsibility to use it to level up everyone around you. We need an engineer who is passionate about data modeling and performance optimization, and who understands that building scalable, well-structured datasets that reflect real world business processes empowers decision-making across the organization.

You'll be joining an Insights Analytics team whose mission is to increase and simplify access to meaningful data and improve every decision we make at EFG. This is a unique opportunity to shape our data foundations, optimize our dbt models on Snowflake, and ensure our analysts and business users have access to clean, well-structured, high-performance datasets.

Expectations

Own Your Domain

• Ask all the whys, relentlessly until you know your customer needs inside-out and know you're designing the right solution to solve their problems.
• Proactively, continuously, think forward and lead your business partners and peers to the right decisions to meet our wider organization goals.

• Work with our business users to understand their business logic and map it to the models in our data warehouse.
• Architect and maintain well-structured, performant data models that scale with our business and support the varied needs of a modern data stack - whether that is traditional BI, powering ML models or providing enriched data to operational systems via reverse ETL.
• Optimize dbt models on Snowflake, ensuring efficiency, reliability, and maintainability.
• Enforce best practices in dimensional modeling (star/snowflake schemas), normalization, and performance tuning.
• Write clean, modular SQL that adheres to best practices for dbt development.

• Continuously improve data reliability, governance, and accessibility across our platform.
• Improve data transformation speed, query performance, and cost efficiency.
• Create well tested models featuring robust documentation and clear data lineage that support self-serve analytics with high quality, impactful data.
• Champion CI/CD practices for dbt deployments and collaborate with Data Engineering to ensure robust ELT processes.

• Be the go-to expert for analytics data modeling and transformation.
• Work closely with analysts, engineers, and business teams to ensure our data models serve real-world needs.
• Share your knowledge generously-whether through documentation, mentoring, or presenting results to the wider team.

• Exemplify the values we live by. Know and care for the people in your team.
• Help inspire, develop, and guide your colleagues to be the best that they can be.
• Be the heart-first, people-first team member everyone wants to be around, because you have invested in building relationships.

• You know SQL like the back of your hand and write highly performant queries.
• You have multiple years of experience with dbt and have optimized models at scale.
• You have a deep understanding of Snowflake architecture, including performance tuning, clustering, caching, and cost optimization.
• You have created data sources for highly performant BI and know how best to optimize aggregations for producing dashboards in particular (experience serving Tableau is a plus).
• You can design and maintain dimensional models (Kimball/Inmon), data vault structures, and best practices for modern analytics warehouses.
• You love Entity-Relationship Diagrams (ERDs) and have experience designing data models that balance usability, flexibility, and performance.
• You create clear, well-structured documentation and know the importance of clear SOPs, ensuring that data models and transformations are well understood and easy to maintain.

• You're an excellent communicator who can explain complex data concepts simply and clearly.
• You collaborate naturally with analysts, engineers, and business teams to define requirements and deliver impactful data solutions.
• You advocate for data literacy and best practices across the organization.

• While you are lightning focused on shipping, you also like to have a good time while getting things done. When we say a "team player" we mean it - you have a crisp high-five and funny stories to tell. You have your team's back, and the team has yours.
• You're insanely curious and love learning new things: You know that there's always more to learn. You're up-to-date on new trends in data - you know who's using what to solve various problems and are excited for the next release of your favorite tool.
• Past experience in the Esports / Gaming industry would be a great asset.
• You make the time to cheer and enjoy the ride.