Analytics Engineer - Remote

March 5

Apply Now

Receive Emails with Similar Jobs

ESL FACEIT Group [EFG]

WebsiteLinkedInAll Job Openings

The ESL FACEIT Group is the leading competitive games and esports company. At EFG we create worlds beyond gameplay where players and fans become community. The company is built on the great legacy of the world-renowned ESL, FACEIT, DreamHack and DreamHack Sports Games brands. We harness this legacy to further innovate and develop the esports and gaming landscape worldwide. Working with our developer, publisher, brand, and media partners, we deliver products that accelerate gaming culture and make gamer communities come together. Join us on the journey as we help gaming communities thrive by creating worlds beyond gameplay that unite players, fans, and creators around the esports and games they love.

esports • games • community • festivals • TV production

501 - 1000 employees

Founded 2018

📋 Description

• At EFG (ESL FACEIT Group) we create worlds beyond gameplay where players and fans become community. • The Data team is responsible for scaling and shaping EFG's data and information strategy across the organization. • We’re looking for an accomplished Analytics Engineer who knows that the true mark of intelligence and experience is kindness. • 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. • 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. • Be a Data Modeling Expert • 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. • 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. • Drive Efficiency and Impact • 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. • Collaborate and Inspire • 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. • Personify our DNA • 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.

🎯 Requirements

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