At Bungie, we believe in harnessing the power of data. We tackle complex challenges and provide game developers with essential knowledge to make informed decisions. As a leading developer of world-class games, we strive to create immersive experiences that foster lasting friendships among players.

As a BI Developer, you will support Bungie’s technological transformation by helping the team transition to a modern, streamlined data stack, which will unlock new insights and capabilities across the studio.

RESPONSIBILITIES

• Transferring production reporting to a new data warehousing solution, maintaining accuracy, consistency, and performance across platforms
• Collaborating with data owners and stakeholders to develop a migration roadmap and regularly communicating progress and challenges
• Ongoing acceptance testing with data owners and stakeholders as production reports are migrated
• Documenting discrepancies, performance/cost concerns, and other data issues, and following up on their resolution

REQUIRED SKILLS

• Experience working with Amazon Web Services (AWS) and Google Cloud Platform (GCP)
• Experience authoring and publishing resources in Tableau
• Advanced SQL coding experience (Example skills below):
  - Deep understanding of join types, standard SQL functions, window functions, etc.
  - Complex date/time handling and manipulation
  - Working with nested complex types (arrays, structs, etc.)
  - Transformation and development of user-defined functions
  - Partition elimination and other methods of performance and cost optimization on large datasets
• Experience with data warehousing, data quality and monitoring best practices
• Experience with data visualization best practices

NICE-TO-HAVE SKILLS

• Experience working with data orchestration tools such as Airflow
• Experience working with project management software like Jira or Asana

Estimated Duration: 6 months

Listed below is this role's base pay range within the greater Seattle area. In other locations approved for remote work by Bungie and our external resource vendors, this pay range may be adjusted to the local market and some roles may be classified as non-exempt (hourly),

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.

All benefits, perks, and time off are provided by and at the discretion of external resource partner(s). For more information, please visit:Worker Help Center - Help Center (tcwglobal.com) 

Bellevue Pay Range

$88,000—$115,000 USD

Bungie full-time (non-contract) employees in the U.S. also receive:

• 20 days of accrued time-off in the form of PTO and sabbatical days, depending on the level of the position
• 10 paid Floating Days annually, prorated in the first year of employment based on start date
• 10 paid Bungie-observed holidays annually
• One hour of Paid Sick Time (PST) for every 30 hours worked 

Contract and International FTE employees receive competitive benefits through their relevant contracting agency.

So you don't meet every requirement listed in this job description? Do you think your experience level is not where it needs to be? Studies show that women and people of color 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 you're interested in this position but your past experience doesn't 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!

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 located outside of CA, CO, DC, FL, GA, IL, MA, MD, MN, NC, NJ, NY, OR, TN, TX, UT, VA, WA, or WI will need to establish residency in one of the states we are compliant in within 45 days of a 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.