<p>Do you enjoy transforming raw gaming data into meaningful insights that drive player experiences? Do you want to build the foundational data infrastructure that empowers teams to make data-informed decisions? At Bungie, we build worlds that inspire friendships, and we leverage data insights to enhance the player experience.</p> <p>As a Senior Analytics Engineer at Bungie, you will be responsible for building and extending the data warehouse for our analytics platform, with a primary focus on Marathon. You will design and develop scalable data models that bridge the gap between raw data and business insights. You will work closely with analysts, data scientists, and game developers to understand their analytical needs and transform complex gaming data into accessible, reliable datasets. Most importantly, you will work with a fun, collaborative team devoted to making the best games in the world.</p> <p><strong>RESPONSIBILITIES</strong></p> <ul> <li>Design, build, and maintain the data warehouse for Marathons analytics platform using modern data modeling practices</li> <li>Transform raw gaming telemetry into clean, reliable datasets that support analytical workflows</li> <li>Collaborate with analysts and data scientists to understand requirements and translate them into scalable data models</li> <li>Develop and maintain data quality standards, monitoring, and testing frameworks to ensure data reliability</li> <li>Build efficient data transformations and aggregations optimized for BigQuery performance and cost</li> <li>Partner with cross-disciplinary teams including game designers, product managers, and engineers to deliver data solutions</li> <li>Document data models and create self-service resources for data consumers</li> </ul> <p><strong>REQUIRED SKILLS</strong></p> <ul> <li>Proficiency with SQL: such as transforming complex granular data to meaningful aggregations; writing performant, cost effective, and repeatable logic; and a strong understanding of SQL concepts such as window functions, CTEs, recursive queries, sharding, and partitioning</li> <li>Ability to develop Python code for data processing, automation, and tooling</li> <li>Experience with data warehousing concepts, dimensional modeling, analytics engineering best practices, and data quality testing frameworks</li> <li>Experience working with big data (TB to PB scale) and optimizing for performance and cost efficiency</li> <li>Strong communication skills: listen to, speak with, and resolve conflicts with members of varied disciplines and external partners in a clear and efficient manner </li> <li>Experience with Google Cloud Platform (GCP) and BigQuery</li> <li>Interest in gaming and understanding how gaming data can be leveraged for analytics and player insights</li> </ul> <p><strong>NICE-TO-HAVE SKILLS</strong></p> <ul> <li>Experience with dbt for data model creation and management</li> <li>Knowledge of game telemetry, player behavior analytics, or live service game metrics</li> <li>Experience with Apache Airflow and workflow management</li> </ul><div><div><div>Listed below is this roles base pay range. In other locations that Bungie has approved for remote work, this pay range may be adjusted up to +/- 10% and some roles may be classified as non-exempt (hourly). <br /><br />This range is determined by an array of factors, including training, transferable skills, work experience, business needs, and market demands. Additionally, it is subject to change and may be modified in the future. <br /><br />In the journey to make incredible worlds, Bungie employees dont simply do meaningful work - they receive meaningful support. Competitive salaries and discretionary bonus opportunities are just the start. We offer comprehensive healthcare coverage, generous 401(k) matching, flexible time off policies, paid parental leave, social clubs, and so much more. Check out our benefits page: <a href="https://careers.bungie.com/benefits">Benefits - Bungie Careers</a> to see all the perks that come with joining Bungie.</div><div>Bellevue Pay Range</div><div><span>$156,000</span><span>—</span><span>$183,000 USD</span></div></div></div><div><div> </div> <div> <p><em>So you dont meet every requirement listed in this job description? Do you think your experience level is not where it needs to be? Studies show that members of certain underrepresented groups are less likely to apply to jobs unless they believe they meet every single qualification. Bungie is focused on building a diverse, inclusive, and equitable workplace. If youre interested in this position but your past experience doesnt line up perfectly with every qualification in the job description, we want you to apply anyway. The right role for you may be right around the corner!</em></p> <p><em>Most Bungie full-time employees will adopt a digital first approach allowing remote work in Bungie approved locations (outside of positions identified as 100% onsite in Bellevue/Seattle, or individuals preferring a hybrid/flex environment). Prospective full-time employees who are located outside of a Bungie approved state will need to establish residency in an approved state within 45 days of their start date. Contractors will follow a digital first approach adhering to the location guidelines agreed upon by our third-party employer/vendor and Bungie. Bungie’s remote policy is subject to change at the company’s discretion.</em></p> </div></div>