This job might no longer be available.

Senior Data Engineer

Overview

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 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

• 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

• Apache Spark experience a major plus (Spark RODs, Spark DataFrames, Spark SQL)
• Streaming Data Technologies (Pub/Sub, Kafka, Kinesis, etc)
• Experience with the Spark / Hadoop Eco-System (Hive, Parquet)
• Understanding of Amazon Web Services, Google Cloud Compute, or Microsoft Azure
• Experience with nonrelational databases or NoSQL Databases encouraged
• Experience working with very large datasets highly encouraged
• Working experience with an agile development framework
• 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.)
• Familiarity or experience working with big data solutions such as Apache Spark, PrestoDB, Kafka, etc.
• Familiarity or experience with statistics and data analysis
• Familiarity or experience with DevOps and infrastructure automation
• Prior experience working in a game development studio or gaming company developing online titles
• Passion or personal interest in video gaming and or BGS games
• BS Degree in Computer Science, Math, Engineering, or equivalent
• A personal interest in video gaming is a plus

Applicant Privacy Notice

CCPA Applicant Privacy Notice