Data Warehouse Analyst

Position Summary

This position is responsible for working with end users to understand their requirements and design and implement decision support assets that meet their needs. The role includes the implementation of data warehouse infrastructure such as ETL programs, views, and table structures. It also provides Level III support for business intelligence and decision support tools, works on project teams to create or modify existing data reports, and executes approved work requests based on business priorities.

• Validate all data warehouse feeds by automated or manual procedures.
• Design and maintain technical documentation including data catalogues, structural diagrams, and end‑user warehouse assets.
• Provide Level III end‑user support and counseling for business intelligence and decision support tools.
• Document data, views, and reports.
• Work with business and management to provide meaningful, efficient, and accurate reports.

• Promote Mohegan Sun ideology through a thorough understanding and implementation of its core values and core purposes.
• Support applications that run in a 7 × 24 × 365 enterprise environment.
• Maintain accurate time reports for activities according to Mohegan Sun’s Information Systems policies.
• Carry a cell phone and be on call.
• Adhere to the privacy rules pursuant to the Health Insurance Portability and Accountability Act of 1996 (HIPAA) as applicable to Mohegan Sun.
• Promote superior customer service.
• Perform other duties as assigned.

• 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).
• Obtain and maintain at least one or more applicable gaming licenses in multiple jurisdictions as required.

OR

• Associate degree in Computer Science, Engineering, Business, or a related field.
• Two years of progressive Information Technology experience.
• Demonstrated knowledge with one or more business intelligence tools.
• Obtain and maintain at least one or more applicable gaming licenses in multiple jurisdictions.

OR

• High School Diploma or equivalent.
• Four years of progressive Information Technology experience.
• Two years experience documenting requirements and designing end‑user reports in a business intelligence environment.
• Demonstrated knowledge with one or more business intelligence tools.
• Obtain and maintain at least one or more applicable gaming licenses in multiple jurisdictions.

• 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.
• Knowledge of data modelling (Star Schema).
• Demonstrated analytical skills and critical thinking skills.

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

• 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 to the above job description whenever necessary.

Regular

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.