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