This job listing expired on Dec 13, 2020
Tweet

Bethesda Game Studios is seeking a qualified Data Warehouse Engineer to work with the BGS game analytics team in building and maintaining back end data solutions, utilizing AWS technologies, to support analytics initiatives to improve player experience and game performance as well as increase player retention and monetization.

Responsibilities

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

  • 5+ years of experience in a data warehousing, data engineering, or data architect role
  • 5+ years of experience in developing, managing, and maintaining large, multi-terabyte data warehouse environments including the pipelines of data and ETL processes feeding into it
  • Experience with full life cycle development, architecture and implementation, of an enterprise data warehouse.
  • Strong experience with AWS Redshift or similar databases
  • Experience working with other AWS data technologies such as S3, Redshift Spectrum, Athena, Data Pipeline, Glue, EMR, RDS, and Kinesis
  • Expert level SQL skills
  • Data modeling experience for both transactional and data warehousing environments including familiarity with Kimball dimensional and 3NF modeling standards
  • Experience working with a variety of data sources such as MySQL, Oracle, SQL Server, PostgreSQL, S3, HDFS, and MongoDB
  • Strong interpersonal skills and problem-solving ability

Preferred Skills

  • Experience with AWS CloudFormation for creating and managing a variety of AWS resources
  • Experience with Python and Linux shell scripting
  • Experience using source control systems (Git, Perforce, SVN, etc.)

Applicant Privacy Notice

CCPA Applicant Privacy Notice