Data Warehouse Programmer

Overview

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!

We will consider candidates for any of our four Bethesda Game Studios office locations: Rockville, MD; Montreal, Quebec; Austin, TX; Dallas, TX.

Responsibilities

Your Daily Life at Bethesda Game Studios

As Data Warehouse Programmer, you will…

• Work with other data warehouse 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

Preferred Skills

Bonus Skills

• Experience with Matillion or related tools

Salary Range

Data Warehouse Programmer - The typical base pay range for this position at the start of employment is expected to be between $75,000 - $160,000 per year.

ZeniMax has different base pay ranges for different work locations within the United States, which allows us to pay employees competitively and consistently in different geographic markets. The range above reflects the potential base pay across the U.S. for this role; the applicable base pay range will depend on what ultimately is determined to be the candidate’s primary work location. Individual base pay depends on various factors, in addition to primary work location, such as complexity and responsibility of role, job duties/requirements, and relevant experience and skills. Base pay ranges are reviewed and typically updated each year. Offers are made within the base pay range applicable at the time.

At ZeniMax certain roles are eligible for additional rewards, such as merit increases and discretionary bonuses. These awards are allocated based on individual performance and are not guaranteed. Benefits/perks listed here may vary depending on the nature of employment with ZeniMax and the country work location. U.S.-based employees have access to healthcare benefits, a 401(k) plan and company match, short-term and long-term disability coverage, basic life insurance, wellbeing benefits, paid vacation time, paid sick and mental health time, and several paid holidays, among others.

This position is in a union and represented by the Communication Workers of America.

We embrace diversity, equity, and inclusion in everything we do – from recruiting for our studios, publishing and operations to fostering safe and respectful workplaces that encourage collaboration. Our culture is based on principles of respect, inclusion, and fair treatment and we welcome anyone into our family without regard to race, religion, gender identity, sexual orientation, or age.

Our diversity fuels our innovation and inspires us to create game worlds that bring us closer to the global community of players we serve.