ZeniMax Jobs

Enterprise ETL Engineer

Division: ZeniMax Media | Department: Business Systems | Location: Rockville, MD, Hunt Valley, MD or Austin, TX, US

The Enterprise ETL Engineer position works within the Enterprise Business Intelligence Team and is responsible for the design of the ETL processes for Enterprise wide reporting. The ETL Engineer will be supporting a broad range of data integration needs from all facets of the business, including e-commerce, financial, and game event data.

The incumbent will have at least 5+ years of previous experience partnering with both technical and business teams to facilitate ETL design and implementation across the enterprise.  The Enterprise ETL Engineer will facilitate the creation of ETL processes to move data across enterprise data sources such as Redshift, Databricks/Spark, AWS S3, MySQL, and Oracle. The Enterprise ETL Engineer will be responsible for validating that the ETL processes align with the technical requirements and that either internal or externally developed systems properly meet the standards required for enterprise use. The Enterprise ETL Engineer will also act as a subject matter expert for the functions assigned to them and as a liaison to the business.

Note: Position is located in Austin, TX, Hunt Valley, MD, and Rockville, MD.

Responsibilities:

  • Work within the Enterprise BI team, supporting the creation of Enterprise ETL processes
  • Create and maintain ETLs that will support data models and business needs within the organization
  • Work directly with Enterprise Architects, Data Scientists, and Analysts, ensuring that warehouse data models meet business requirements
  • Work directly with other ETL Engineers and Big Data Engineers to understand the source and target structures
  • Coordinate with the Analysts and Report Developers to ensure data can be easily digested by BI reporting tools
  • Be able to straddle differing subject areas such as in-game vs business data sources

Requirements:

  • 5+ Years of Experience
  • A complete understanding of the full data pipeline - conceptual, logical, and physical
  • Experience in applying Kimball Dimensional Modelling
  • Comfortable working in both OLTP and OLAP environments
  • Strong SQL skills – as well as reviewing ERDs, able to query data sources directly to determine source/target mapping needs
  • Comfortable working with structured, semi-structured, and unstructured source data
  • Comfortable working in both data warehouse and big data environments (such as Apache Spark)
  • Able to translate requirements and define ETL needs prior to and during data model design
  • Basic familiarity with BI reporting tools to understand how data models are used in reports
  • A strong communicator, is comfortable interfacing directly with differing customers across the organization in addition to the BI team
  • Working experience with the SCRUM development framework
  • Experience with a proven ETL solution. Pentaho is preferred, however experience with any ETL solution will be considered

Preferred Skills:

  • Experience with AWS or other cloud providers is a plus
  • Experience working within the Video Game/MMO industry is desired, though candidates from outside of the industry are also welcomed
  • A personal interest in video gaming is a plus
  • Understanding of the Free to Play/Micro transaction Business Model is a plus

How to Apply

To apply for this position you will be redirected to the job submission form at Taleo.com, our third-party applicant tracking system. While Taleo.com is not hosted by ZeniMax Media and does not fall under our Privacy Policy, only employees of our Human Resources department will be able to view your submitted information. Information collected via the job submission form is subject to Taleo.com’s privacy policy.

Previously Applied? Click here.

No Recruiters or Agencies Please

Please Note: Individuals submitting resumes or otherwise responding to employment opportunities are NOT considered applicants until they apply for a particular position and have been invited to complete the company's employment application.

© Copyright 2018 ZeniMax Media Inc.
Trademarks are the property of their respective owners. All Rights Reserved.
Privacy Policy | Terms of Service | Legal Info | Contact Us