Analytics Engineer (Remote)

ESL FACEIT Group - EFG; London; Remote; GBP 45,000 - 85,000; Full time

Job summary

Join a forward-thinking company as an Analytics Engineer, where you'll play a vital role in shaping data strategies and optimizing data models. This position offers a unique opportunity to work with cutting-edge technologies like Snowflake and dbt, ensuring that data is accessible, reliable, and impactful. You'll collaborate with a dynamic team to drive efficiency and inspire data-driven decisions across the organization. If you're passionate about data modeling and eager to make a significant impact in the esports and gaming industry, this role is perfect for you!

Qualifications

• Extensive experience with SQL and dbt for data modeling.
• Deep understanding of Snowflake architecture and performance tuning.

Responsibilities

• Architect and maintain scalable data models for business needs.
• Optimize dbt models on Snowflake for efficiency and reliability.

Skills

SQL

Data Modeling

Performance Optimization

Communication

Data Governance

CI/CD Practices

Entity-Relationship Diagrams (ERDs)

Education

Bachelor's Degree in a related field

Tools

dbt

Snowflake

Job description

Get AI-powered advice on this job and more exclusive features.

EFG (ESL FACEIT Group) creates 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 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.

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

Analytics Engineering & Data Modeling

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

Communication

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

Traits

• While you are lightning focused on shipping, you also like to have a good time while getting things done.
• You're insanely curious and love learning new things.
• Past experience in the Esports / Gaming industry would be a great asset.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Other

Industries

Technology, Information and Internet