Analytics Engineer

ESL FACEIT Group
Summary
Join EFG's Data team as an Analytics Engineer and contribute to shaping the company's data and information strategy. You will own your domain, asking the necessary questions to understand customer needs and design effective solutions. As a data modeling expert, you will work with business users to map business logic to data warehouse models, architect and maintain performant data models, and optimize dbt models on Snowflake. You will drive efficiency and impact by improving data reliability, governance, and accessibility, while collaborating with analysts, engineers, and business teams. This role requires expertise in SQL, dbt, Snowflake, and dimensional modeling, along with excellent communication skills. You will be a key contributor to a team focused on increasing access to meaningful data and improving decision-making at EFG.
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
Responsibilities
- 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
Preferred Qualifications
Past experience in the Esports / Gaming industry would be a great asset