Senior Analyst, Project Support - Strategic Operations

Exceptional Hospitality Starts with You

This role is based at one of our corporate offices in Dallas, TX or McLean, VA. This is your chance to be part of a Revenue Management Consolidated Center (RMCC) that is offering owned, managed, and franchised Hilton hotels world-class revenue management talent and tools. As a Senior Analyst, Project Support-Strategic Operations, you will support the team that's helping hotels grow market share and outperform competitors.

On the Strategic Operations team reporting to the Manager, Project Support, you will work on projects including developing analytics data products and designing performance dashboards.

What you'll do during a typical day:

• Develop Python-based Extract, Transform, Load (ETL) pipelines to create reports and tools
• Author complex SQL queries and stored procedures for data extraction, aggregation, and reporting
• Build Excel-based financial and operational tools using VBA (macros, custom functions, Pivot Table automation, Power Query integration)
• Integrate with RESTful APIs, managing secure authentication and credential storage (e.g., keyring)
• Profile pipeline performance — enhance Python code (cProfile) and SQL execution plans
• Document ETL processes, data models, and maintain a centralized data catalog

How you'll collaborate with others:

• Partner with RMCC teams, Analytics, BI, and Commercial Services teams to translate use cases into scalable data products
• Mentor junior analysts and developers in Python, SQL, and VBA best practices; lead knowledge-sharing workshops
• Provide strategic advisory to business and technical partners on analytics best practices and data-product adoption
• Collaborate with partners to define and measure performance metrics and evaluate data-product impact

Projects you'll take ownership of:

• Architect performance-outlook dashboards and self-service reporting tools that surface revenue and commercial trends
• Develop CI/CD pipelines for automated testing and deployment of analytics data products
• Design data models (star/snowflake schemas) to support reporting
• Ensure compliance with security and data-governance policies, including secure credential management and access controls

You have these minimum qualifications:

• Three (3) years professional experience in analytics/data-engineering roles
• Experience authoring complex SQL (Redshift, SQL Server, MySQL) and stored procedures
• Two (2) years coding development experience (macros, automation, Pivot Tables)
• Proficient in Python (ETL frameworks, pandas, Num Py) and advanced Excel (Power Query, functions)
• Experience in requirements elicitation for KPI frameworks and reporting structures, transforming business inputs into data stories and dashboard architectures that optimize operational performance.
• This is a hybrid role and would require to be near one of two US office locations (Dallas or McLean)
• Travel up to 10%

It would be useful if you have:

• Understanding of data-modeling principles (star/snowflake schemas)
• Experience in cross-functional project management and requirements translation, converting business objectives into detailed technical specifications
• Experience with BI tools:
  Micro Strategy, Alteryx, Power BI
• Experience with Airtable, Salesforce, Git Lab, and Power Automate
• Front end website development

At Hilton, the hospitality we're known for doesn't end with our guests. We proudly invest in our Team Members' wellbeing, supporting you through all of life's moments. When you join Hilton, our exceptional care extends to you with unmatched perks and benefits, including:

• Incredible travel perks – Enjoy 110 nights of deeply discounted travel, with room rates as low as $40/night at our world-class hotels through our Go Hilton travel program
• Own a piece of Hilton – Through our employee stock purchase program (ESPP), you can invest in Hilton shares at a 15% discount to help build your financial future
• Paid parental leave – Because family matters. We offer paid leave for eligible Team Members, including partners and adoptive parents
• Personalized caregiving support – Access dedicated caregiving concierge services to help navigate caregiving for yourself and…