Hilton - McLean, VA

posted about 2 months ago

Full-time - Mid Level
McLean, VA
501-1,000 employees
Accommodation

About the position

The Senior Analyst, Reporting Applications - SQL Development role at Hilton is a pivotal position within the corporate office located in McLean, VA. This role is designed for an individual who is not only skilled in data analysis but also possesses a strong foundation in SQL development. The primary responsibility of this position is to assist the Senior Manager in various project management-related tasks, ensuring that projects are completed efficiently and effectively. The Senior Analyst will guide other analysts in their development and recurring reporting tasks, fostering a collaborative environment that encourages knowledge sharing and skill enhancement. In this role, the Senior Analyst will be tasked with designing, developing, and testing SQL queries and stored procedures. This includes developing data modeling concepts that are essential for effective data management and reporting. The analyst will perform thorough analysis and validation of data to ensure accuracy and reliability. A key aspect of the position is to identify opportunities to convert ad-hoc report requirements into standardized report designs, which will streamline reporting processes and improve efficiency. Additionally, the analyst will be responsible for identifying areas where performance improvements can be made in queries and stored procedures, ensuring that the reporting applications run optimally. The position requires a proactive approach to problem-solving and a keen eye for detail, as the analyst will be working with complex data sets and must ensure that all reporting outputs meet the highest standards of quality. The role also involves a moderate amount of travel, with an expectation of approximately 10% domestic travel to support various projects and initiatives.

Responsibilities

  • Assist Senior Manager in project management-related tasks.
  • Guide Analysts on completion of development and recurring reporting tasks.
  • Design, develop, and test SQL queries and stored procedures.
  • Develop data modeling concepts.
  • Perform analysis and validation of data.
  • Identify opportunities to convert ad-hoc report requirements to canned report design.
  • Identify areas for queries/store procedures performance improvements.

Requirements

  • Master's degree in Data/Business Analytics or related field.
  • Two (2) years of experience as Data/Business Analyst or related field.
  • Experience with developing complex queries using SQL.
  • Proficiency in relational databases, SSRS/SSAS/SSIS, Excel, SQL Server.
  • Familiarity with business intelligence tools such as Tableau and PowerBI.
  • Knowledge of data modeling concepts and database design.
  • Understanding of data quality concepts and methodologies.
  • Experience in converting ad-hoc report requirements to report design.
  • Ability to clean data using Python.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service