Data Warehouse Analyst

Primary Duties And Responsibilities

• Validates all data warehouse feeds by automated or manual procedures
• Designs and maintains technical documentation including data catalogues, structural diagrams and end user warehouse assets
• Provides Level III end user support and counseling for business intelligence and decision support tools
• Documents data, views and reports
• Works with business and management to provide meaningful, efficient and accurate reports

Secondary Duties And Responsibilities

• Promotes Mohegan Sun ideology through a thorough understanding and implementation of its core values and core purposes
• Must be able to support applications that are running in a 7 X 24 X 365 enterprise environment
• Maintains accurate time reports for activities according to Mohegan Sun’s Information Systems policies

Minimum Education And Qualifications

• Bachelor’s Degree in Computer Science, Engineering, Business or a related field
• Demonstrated knowledge with one or more business intelligence tools (e.g., Snowflake, Informatica, Power BI, Tableau and Cognos)
• Obtains and maintains at least one or more applicable gaming licenses in multiple jurisdictions

Competencies

• Certifications as required by Mohegan Sun
• Excellent written and oral communications
• Knowledge of the software lifecycle
• Knowledge of an enterprise class ETL tool such as Informatica
• Knowledge of SQL
• Working knowledge of Snowflake
• Demonstrated analytical skills and critical thinking skills

Training Requirements

• Knowledge of Mohegan Sun corporate and department policies and procedures
• Appropriate regulations that pertain to Mohegan Sun information systems
• Mohegan Sun budget planning and analysis process and procedures