Senior Analyst, Project Support - Strategic Data Operations
***This role is based at one of our corporate offices in McLean, VA or Dallas, TX***
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 Senior Manager, Project Support, you will work on projects including developing analytics data products and designing performance dashboards.
HOW WE WILL SUPPORT YOU
Hilton is proud to support the mental and physical wellbeing of all Team Members so they can Thrive personally and professionally in a diverse and inclusive environment, thanks to programs and benefits such as:
- 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)
- Learn more about the rest of our benefits
At Hilton, we believe every Team Member is a leader. We are committed to offering leadership development opportunities and programs through every step of a Team Member’s career journey and at every level, both in our hotels and across corporate.
**Available benefits may vary depending upon terms and conditions of employment and are subject to the terms and conditions of the plans.
HOW YOU WILL MAKE AN IMPACT
Your role is important and below are some of the fundamental job duties that make your work unique.
What your day-to-day will be like:
- 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 (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 will 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
What projects you will 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
WHY YOU'LL BE A GREAT FIT
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, 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
- 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: MicroStrategy, Alteryx, Power BI
- Experience with Airtable, Salesforce, GitLab, and Power Automate
WHAT IT IS LIKE WORKING FOR HILTON
Hilton, the #1 World's Best Workplace, is a leading global hospitality company with a diverse portfolio of world-class brands. Dedicated to filling the earth with the light and warmth of hospitality, we have welcomed more than 3 billion guests in our more-than 100-year history. Hilton is proud to have an award-winning workplace culture and we are consistently named among one of the World’s Best Workplaces. Check out the Hilton Careers blog and Instagram to learn more about what it’s like to be on Team Hilton!
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. Please contact us if you require an accommodation during the application process.