Hilton is looking for a Senior Analyst, Project Support to join the Strategic Operations team supporting the Revenue Management Consolidated Center (RMCC). You will help hotels grow market share and outperform competitors by developing analytics data products and designing performance dashboards.
What You'll Do
- 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, PivotTable automation, Power Query integration).
- Integrate with RESTful APIs, managing secure authentication and credential storage.
- Profile pipeline performance — enhance Python code and SQL execution plans.
- Document ETL processes, data models, and maintain a centralized data catalog.
- 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.
- 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.
What We're Looking For
- 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, PivotTables).
- Proficient in Python (ETL frameworks, pandas, NumPy) 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.
- Ability to travel up to 10%.
Nice to 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: MicroStrategy, Alteryx, Power BI.
- Experience with Airtable, Salesforce, GitLab, and Power Automate.
Technical Stack
- Python, SQL, VBA, Excel
- RESTful APIs
- Redshift, SQL Server, MySQL
- pandas, NumPy, Power Query
- MicroStrategy, Alteryx, Power BI
- Airtable, Salesforce, GitLab, Power Automate
Team & Environment
You will be on the Strategic Operations team reporting to the Senior Manager, Project Support.
Benefits & Compensation
- Go Hilton travel program: 110 nights of discounted travel with room rates as low as $40/night.
- Hilton Shares: Our employee stock purchase program (ESPP) - you can purchase Hilton shares at a 15 percent discount.
- Paid parental leave for eligible Team Members, including partners and adoptive parents.
- Mental health resources including free counseling through our Employee Assistance Program.
- Paid Time Off (PTO).
- Leadership development opportunities and programs.
Work Mode
This role is onsite in McLean, VA or Dallas, TX.
We provide reasonable accommodations to qualified persons with disabilities to perform the essential functions of the position and provide other benefits and privileges of employment in accordance with applicable law.





