.Who we are At Fortis Games we aspire to make great games that bring people together while redefining how game companies work. We believe in building a sense of belonging through our games, their communities, and how we operate and treat each other. Through our game communities, we will create powerful connections and lasting memories. We will foster a culture of diversity, equity and belonging where together our diverse skills, experiences and backgrounds impact the games we make. We are an early but mighty organization with a leadership team of game industry veterans. There are many opportunities for you to have a big impact on the products we'll be making as well as the overall direction of the company. If you're passionate about tackling difficult problems with direct and thoughtful communication and team first mentality, we may be the right place for you. About the role The Sr Analytics Engineer role helps us strengthen the data-driven culture in the company, integrating multiple heterogeneous data sources and working in close collaboration with our Analytics team to provide them with reliable, high-quality data sets and ensure that they have the tools and resources they need to derive meaningful insights from data. What you'll achieve Work with the data engineering team to build data processing pipelines on the Fortis Data Platform. Partner with Analytics to design, build and maintain data models in response to end customer needs. Examine, deconstruct and deep dive into large, unstructured datasets in order to identify useful and relevant information. Build and optimise data structures that underpin our Analytical dashboards to ensure optimal performance, timeliness and quality of information provided to stakeholders. What you'll need to be successful Expert in Python: familiarity with using APIs to obtain 3rd party data, and for data manipulation and enrichment. SQL Expert: Aggregate and window functions, joins and CTEs. Experience with columnar database platforms. Database design best practices: understand how to structure datasets for optimal performance. Demonstrated ability to maintain high standards of data quality, accuracy and completeness. Version control and collaboration using GitHub. Advanced English, written and spoken. Experience with Kafka, Hadoop, and Spark is strongly preferred. Working with large datasets on a database platform, including normalization and denormalization is strongly preferred. Experience with AWS services like S3, Glacier, Kinesis, and Redshift is strongly preferred. Familiarity with Clickhouse and Looker is strongly preferred. *PLEASE SUBMIT RESUME IN ENGLISH* Why join us There are many reasons to join us, but here are a few: We strongly believe we are changing how games studios operate and at the core of what we do is making great games that create a connected community We're not just about making Games Where You Belong. We're also about building communities where our people belong
