JOIN OUR TEAM AND EXPERIENCE ENDLESS CAREER POSSIBILITIES
IF YOU ARE AN EXISTING TEAM MEMBER, PLEASE CLICK THE FOLLOWING LINK TO BE TAKEN TO THE INTERNAL CAREER SITE: MOHEGAN INTERNAL CAREER SITE (http://www.myworkday.com/mohegan/d/task/2998$46522.htmld)
Position Summary:
The incumbent in this position is responsible for the overall design of the enterprise-wide data/information architecture, which maps to the enterprise architecture and balances the needs for access against security and performance requirements. Focuses on enterprise-wide data modeling and database design. Defines data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements and applies accepted data content standards to technology projects. Facilitates consistent business analysis, data acquisition and access analysis. Translates strategic requirements into a useable enterprise information architecture.
Primary Duties and Responsibilities: includes but not limited to:
Responsible for the design and development of the architecture for all data warehouse components to include; tool integration strategy, source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy
Responsible for the design and implementation of data storage strategies and techniques as well as data warehouse health monitoring and security mechanisms
Accountable for all capacity planning activities in regards to both the data warehouse and related analytical platforms
Works with enterprise business and IT senior management to understand and prioritize data and information requirements
Solves complex technical problems related to business intelligence tools, databases and ETL tools.
Optimizes the performance of enterprise business intelligence tools by defining data to filter and index that add value to the business user community
Designs and coordinates a curriculum for coaching and training business end users on how effectively and efficiently utilize business intelligence tools
Develops data and information quality metrics
Researches new technology and develops business cases to support enterprise-wide business intelligence solutions
Develops testing and other quality assurance procedures to insure the highest quality of data and business intelligence result sets
Works on highly complex projects that require in-depth knowledge across multiple technical areas and business segments with minimal supervision
Secondary Duties and Responsibilities:
Performs other duties as assigned
Coaches and mentors more junior technical staff
Must be able to work flexible hours and shifts
Must be able to support applications that are running in a 7 X 24 X 365 enterprise environment
Maintains accurate time reports for his or her activities
Responsible for enforcing the privacy rules pursuant to the Health Insurance Portability and Accountability Act of 1996 (HIPAA) as applicable to Mohegan Sun
Minimum Education and Qualifications:
Master's degree in Computer Science or Engineering, and four years of progressive Information Technology experience
Two years' experience as an Data Warehouse Engineer or equivalent position responsible for analyzing, compiling, programming and writing specifications in a business intelligence role
Demonstrated knowledge with one or more business intelligence tools (e.g. Teradata, Unica, SAS, Cognos) and ETL tools (e.g. Informatica)
Obtain and maintain at least one or more applicable gaming licenses in multiple jurisdictions
~OR~
Bachelors' degree in Computer Science or Engineering, and ten years of progressive Information Technology experience
Two years' experience as an Data Warehouse Engineer or equivalent position responsible for analyzing, compiling, programming and writing specifications in a business intelligence role
Demonstrated knowledge with one or more business intelligence tools (e.g. Teradata, Unica, SAS, Cognos) and ETL tools (e.g. Informatica)
Obtain and maintain at least one or more applicable gaming licenses in multiple jurisdictions
Competencies: Incumbent will master the following competencies while in this position:
Certifications as required by Mohegan Sun
Excellent written and oral communications
Knowledge of Control Objectives for Information and related Technology (COBIT) and the Information Technology Infrastructure Library (ITIL)
Knowledge of the software lifecycle
Expert knowledge of an enterprise class ETL tool such as Informatica
Expert knowledge of SQL
Expert knowledge of the Teradata product suite
Demonstrated analytical skills and critical thinking skills
Demonstrated self-awareness
Training Requirements:
Knowledge of Mohegan Sun corporate and department policies and procedures
Appropriate regulations that pertain to Mohegan Sun information systems
Purchase request review and approval with enterprise supply-chain management application
Review and analysis of department timesheet information
Mohegan Sun budget planning and analysis process and procedures
Physical Demands and Work Environment:
May be required to carry a pager or a cell phone and be on call
May require occasional weekend and evening work
Must be able to work flexible hours and shifts
Occasional travel may be required
This is not necessarily an exhaustive list of all responsibilities, requirements or working conditions associated with the job. Mohegan reserves the right to make changes in the above job description whenever necessary.
Work Shift:
Regular
Knock, knock. Hear that sound? That's opportunity!
.
Mohegan Sun practices Native American Preference in hiring. "Native American" means an individual who is a duly enrolled member of the Mohegan Tribe or any group of Native Americans recognized by the Mohegan Tribe, The United States of America, or the State of Connecticut.
What began in 1996 as a gaming destination in southeastern Connecticut with a handful of Team Members has expanded into a premier entertainment enterprise with over 10,000 team members across the globe. What drives our success is the centuries-old philosophy of the Mohegan Tribe "The Spirit of Aquai". Its principles of welcoming, mutual respect, cooperation and building relationships have shaped our culture, and serve as the foundation that we live by with every guest and team member interaction today, and for generations to come.
