Manager - Reporting and Analytics

Job Description : Position Overview

The primary responsibility of the Manager - Reporting & Analytics is to manage and support the strategic direction to data, access and reporting for the Corporate Analytics & Reporting team. This team provides a wide array of support, strategic analysis, metrics, and reporting to Corporate and the Property Information Technology departments. The main area of focus is performing analysis and evaluating performance of key IT operating metrics and expenses such as headcount, payroll, maintenance contracts, project delivery, and assets (see specific examples below).

All duties are to be performed in accordance with departmental and Las Vegas Sands Corp.'s policies, practices, and procedures. All Las Vegas Sands Corp. Team Members are expected to conduct and carry themselves in a professional manner at all times. Team Members are required to observe the Company's standards, work requirements and rules of conduct.

Essential Duties & Responsibilities

• Consulting with data management teams to get a big-picture idea of the company's data storage needs
• Presenting the company with warehousing options based on their storage needs
• Collaborate with BI developers, DBA, researchers, and IT in enhancing existing projects or data structures, and resolving project and programming issues
• Act as a subject matter expert for the ETL architecture for the EDW
• Work with Agile team members to document and execute test plans for data loading and data validation scripts
• Designing and coding the data warehousing system to desired company specifications
• Conducting preliminary testing of the warehousing environment before data is extracted
• Extracting company data and transferring it into the new warehousing environment
• Testing the new storage system once all the data has been transferred
• Troubleshooting any issues that may arise
• Providing maintenance support
• Responsible to creating and adhering to standard operating procedures and standards for data and web application related activities
• Responsible for analyzing customer requirements and creating web-based applications in Azure
• Participating on requirement gathering, analysis and technical design
• Develop client displays and user interfaces
• Creating, deploying, configuring and scaling applications on Azure PaaS (preferred)
• Design, Develop and support Cloud-Native applications and API development using NET, NET Core and Containers (preferred)
• Develop workflow solutions to simplify processes and remove manual dependencies (preferred)
• Develop technical interfaces, specifications, and architecture
• Use and adapt existing web applications for apps (preferred)
• Create and test software prototypes
• Responsible to creating and adhering to standard operating procedures and standards for data and web application related activities
• Responsible for creating and maintaining analysis and reporting
• Collecting and adhering to business requirements for reporting deliverables
• Responsible for extracting, transforming, and creating connections to various data sources for Business Intelligence (preferred)
• Developing multidimensional models that are compatible with warehouse standards (preferred)
• Understand business requirements and data models while taking care of the sources
• Responsible for converting existing reporting to automated dashboards
• Analyzes operational data, monitoring key operations metrics, managing the governance process around key operations metrics, and providing recommendations on process improvements
• Develops and maintains monthly dashboards of key operational performance indicators, incorporating data from multiple internal and external sources and communicates results to leadership
• Responsible to creating and adhering to standard operating procedures and standards for all data related activities
• Perform job duties in a safe manner
• Attend work as scheduled on a consistent and regular basis
• Performs other related duties as assigned

Minimum Qualifications

Physical Requirements

Must be able to :