Senior Analyst, Project Support - Strategic Data Operations

Hilton • Addison, TX

17h • Onsite

About The Position

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 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.

Requirements

• 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%

Nice To Haves

• 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

Responsibilities

• 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
• 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

Benefits

• 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)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed