This job listing expired on Jan 10, 2024
Tweet

Join Constellation!

Come join Bethesda Game Studios, the award-winning development team behind Starfield, The Elder Scrolls and Fallout. Bethesda Game Studios strives to offer its employees a well-balanced home and work life by providing competitive salaries, a generous benefits program, and offices located in some of North America’s best cities.

With a goal of creating a culture as fun and diverse as our games and our players, we welcome applicants with unique skillsets, experience levels and backgrounds. If you are passionate about making a meaningful contribution to some of the most significant games in the industry we’d love to hear from you!

Responsibilities

Your Daily Life at Bethesda Game Studios

As Data Warehouse Programmer, you will…

  • Work with other data programmers and game analysts to build new and extend existing data structures to support game analytics

  • Develop, maintain, and support ETL processes for loading data from multiple data sources into a Redshift data warehouse

  • Maintain and develop all physical data models for EDW.

  • Maintain large, multi-terabyte data warehouse which includes performance tuning and data retention/purge processes

  • Research and troubleshoot data quality issues, providing fixes and proposing both short- and long-term solutions

  • Prepare designs for database systems and recommend improvements for performance.

  • Maintain and develop various database scripts and tools to facilitate automation process

  • Provide support to all data warehouse initiatives.

  • Evaluate all proposals requests and assist to improve structure of data warehouse

Qualifications

What Makes You S.P.E.C.I.A.L.

  • You have 3+ years of experience in a data warehousing, data engineering, or data architect role

  • You have strong experience with AWS Redshift or similar databases

  • You have experience working with other AWS data technologies such as S3, Redshift Spectrum, Athena, Data Pipeline, Glue, EMR, RDS, and Kinesis

  • You have excellent SQL skills

  • You have data modeling experience for both transactional and data warehousing environments including familiarity with Kimball dimensional and 3NF modeling standards

  • You have strong interpersonal skills and problem-solving ability