JOB SUMMARY
The Senior Revenue Data Analyst will assume lead roles on projects leveraging advanced data analytics skills and, by partnering with Revenue Management, Sales/Service, IT and Finance develop analyses, tools, and reports to support business decisions. Demonstrated expert in using SQL, Python, SAS or R the Senior Revenue Data Analyst will be responsible for working on complex problems involving large sets of structured and unstructured data.
ESSENTIAL DUTIES AND RESPONSIBILITIES
TACTICAL:
- Develop, disseminate, and present reports to internal stakeholders on revenue metrics to include customer, market and segment performance, competitive pricing activity, distribution channel performance, and capacity utilization
- Adept data programmer, develops complex and performance optimized programs in Python and SQL
- Maintain and advance departmental data analysis tools, templates, and techniques
- Present complex findings to senior management and non-technical users in clear, concise, and convincing manner both in writing and interactive presentation setting
- Proactively track key metrics, identify trends that warrant deeper analysis, and advise decision makers of the business implications
- Assist management in representing Revenue Management in data governance projects, work with IT to resolve identified data issues and deficiencies
- Assist management in mentoring and training professionals in less senior positions
- Under minimal supervision translate internal stakeholder questions into actionable and insightful reports
- Develop new reporting tools to accommodate evolving business needs
- Develop and monitor data quality metrics to ensure that reporting used to make decisions is both accurate and comprehensive
- Practical understanding of micro-economic concepts, financial, and pricing/yield management principles
- Strong proficiency in Microsoft Office applications; particularly advanced Excel functionality including Pivot Tables, Macros, Lookups, external data connectivity, and logic functions. VBA a plus
- SQL and Python programming
- Tableau, R, Python, MS Azure, Google Cloud Platform
MANAGEMENT & SUPERVISORY RESPONSIBILTIES
- Typically reports to Director, Business Intelligence and Analytics
- Job is NOT directly responsible for managing others
CORE COMPETENCIES FOR ALL POSITIONS: Essential Skills, Abilities and Example Behavior(s)
- Experience working collaboratively across departments
- Strong collaboration skills: partners with leaders across functional lines to deliver results
- Decision capability & quality; makes critical decisions under pressure often with limited set of information
- Change Advocate: Identifies and acts upon opportunities for continuous improvement as well as transformational change where warranted. Encourages prudent risk taking, exploration of alternative approaches and organizational learning. Demonstrates personal commitment to change through actions and words. Mobilizes others to support change through times of stress and uncertainty
- Capable of conducting and guiding sophisticated analytics and reporting
- Strong financial and business acumen
- Strong collaboration skills: partners with leaders across functional lines to deliver results
- Develops self & others; holds staff accountable to goals, sets challenging goals and champions the learning and development system
- Excellent communication skills: respected by & can influence at senior levels, takes responsibility to ensure messages are delivered and received