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

• At least 21 years of age
• Proof of authorization to work in the United States
• Bachelor's degree in Computer Science, MIS or related Business discipline, or equivalent business experience
• Must be able to obtain and maintain a Nevada Gaming Control Board Registration and any other certification or license, as required by law or policy
• Minimum 5 years of CI/CD, DevOps experience preferred
• Minimum 5 years Azure platform and related Azure products preferred
• Minimum 3 years Analytics experience preferred
• Azure Data Factory experience preferred
• Well versed with Azure offerings with work experience on Web apps, ASE, ASP, function apps, SQL PaaS, Storage accounts
• Develop T-SQL queries, scripts and store procedures used for extracting, validating, transforming, and loading data provide by clients
• Develop PL/SQL store procedures used by front-end and middle-tier developers
• Develop T-SQL store procedures for checking integrity constraints and database updates
• Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW
• Proficient with Microsoft Excel, PowerBI, Visual Studio, SSIS, SSAS, SSRS, SSMS, SQL Server, Visio & other Microsoft Office programs
• Proven work experience as an ETL developer
• Hands on experience on Azure App Service Model (Web Apps and Web Jobs)
• Hands on experience on Azure storage services like SQL DB, Tables, Files and Blobs
• Good knowledge of Azure IaaS (VMs, VNET, NSG Rules, VPN Gateways and Express Route)
• Knowledge of networking engineering including DNS, Active Directory, Firewall, Load balancers preferred
• Hands on experience in implementing RESTful webservices and SOAP services in cloud preferred
• In-depth knowledge of the Microsoft Platform Web Development (IIS, .NET, Web Services, SQL Server, SharePoint, Windows Server, Clustering, Active Directory etc.) preferred
• Strong understanding of Cloud computing concepts and technologies, such as IaaS/SaaS/PaaS, load balancing, storage, etc. preferred
• Well versed with Azure or other GIT repositories
• Proficient with Data Analysis Expression (DAX) queries
• Experience creating Power BI dashboards
• Strong project management skills
• Ability to troubleshoot and solve complex technical problems
• Able to travel as needed to support a global organization
• Experience in development and supporting enterprise applications
• Experience working with financial data from key gaming and hospitality applications such as Stratton Warren, Infinium, Cognos, and Ariba preferred
• Experience using ServiceNow and the Performance Analytics module preferred
• Experience working with IT and Project Managers preferred
• Must demonstrate the key fundamental values of professional skepticism, integrity, transparency, and accuracy
• Strong interpersonal skills with the ability to communicate effectively and interact appropriately with management, other Team Members and outside contacts of different backgrounds and levels of experience

Physical Requirements

Must be able to:

• Physically access assigned workspace areas with or without reasonable accommodation
• Work remotely as necessary
• Work indoors and be exposed to various environmental factors such as, but not limited to, CRT, noise, and dust
• Utilize laptop and standard keyboard to perform essential functions of the job