Data Warehouse Analyst

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 SITEPosition 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. Responsible for the implementation of data warehouse infrastructure including ETL programs, views, and table structures. Provides Level III support for business intelligence and decision support tools. Works on project teams for the purpose of creating or modifying existing data reports. Executes approved work requests based on business priorities.Primary Duties and Responsibilities includes but not limited to:Responsible for the validation of all data warehouse feeds by automated or manual proceduresResponsible for the design and maintenance of technical documentation including data catalogues, structural diagrams and end user warehouse assetsProvides Level III end user support and counseling for business intelligence and decision support toolsDocuments data, views and reportsWorks with business and management to provide meaningful, efficient and accurate reportsSecondary Duties and Responsibilities:Promotes Mohegan Sun ideology through a thorough understanding and implementation of its core values and core purposesMust be able to support applications that are running in a 7 X 24 X 365 enterprise environmentMaintains accurate time reports for activities according to Mohegan Sun’s Information Systems policiesRequired to carry a cell phone and be on callAdheres to the privacy rules pursuant to the Health Insurance Portability and Accountability Act of 1996 (HIPAA) as applicable to Mohegan SunPromotes superior customer servicePerforms other duties as assignedMinimum Education and Qualifications:Bachelors’ Degree in Computer Science, Engineering, Business or a related fieldDemonstrated 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 as required. ~OR~Associate degree in Computer Science, Engineering, Business or a related fieldTwo years of progressive Information Technology experienceDemonstrated 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~OR~High School Diploma or equivalentFour years of progressive Information Technology experienceTwo years of experience documenting requirements and designing end user reports in a business intelligence environment.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 jurisdictionsCompetencies: Incumbent will master the following competencies while in this position:Certifications as required by Mohegan SunExcellent written and oral communicationsKnowledge of the software lifecycleKnowledge of an enterprise class ETL tool such as InformaticaKnowledge of SQLWorking knowledge of SnowflakeKnowledge of Data modelling (Star Schema)Demonstrated analytical skills and critical thinking skillsTraining Requirements:Knowledge of Mohegan Sun corporate and department policies and proceduresAppropriate regulations that pertain to Mohegan Sun information systemsMohegan Sun budget planning and analysis process and proceduresPhysical Demands and Work Environment:May require occasional weekend and evening workMust be able to work flexible hours and shiftsOccasional travel may be requiredThis 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:RegularKnock, 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.SummaryLocation: Uncasville, CTType: Full time