Project Manager, Business Analysis and Reporting - Revenue Pipeline

How You'll Help Us Keep Climbing

The Project Manager – Business Analysis and Reporting, Revenue Pipeline, will be responsible for executing the analytical components of Delta's roadmap for technology development while ensuring alignment between the commercial and financial goals and solutions.

• Perform deep senior management requested standard financial and data analysis of RP information related to passenger revenues, commissions, RASM, yield, profitability, and contractual agreements for various customer groups.
• Work with the Revenue Pipeline Solutions Center (RPSC) and various business customers and determine clear and actionable requirements for new or existing Revenue Pipeline (RP) reports and queries while managing end-user expectations.
• Design, develop, test, and document structured queries and reports to extract data from the Revenue Pipeline Analytical database (RPAD).
• Maximize the performance and accuracy of standard and ad hoc queries and reports.
• Proactively perform audits of RPAD data, reports, queries, and tables to identify weaknesses in RP data integrity, reliability, or technical processes.
• Work with Revenue Management, Commercial, Operational, Information Technology, and peer Revenue Accounting teams, to define, prioritize and support execution of initiatives that contribute to revenue growth, customer satisfaction, and enhanced controls and data analytics.

Summary Of Responsibilities

Perform deep senior management requested standard financial and data analysis of RP information related to passenger revenues, commissions, RASM, yield, profitability, and contractual agreements for various customer groups.

Work with the Revenue Pipeline Solutions Center (RPSC) and various business customers and determine clear and actionable requirements for new or existing Revenue Pipeline (RP) reports and queries while managing end-user expectations.

Design, develop, test, and document structured queries and reports to extract data from the Revenue Pipeline Analytical database (RPAD).

Maximize the performance and accuracy of standard and ad hoc queries and reports.

Proactively perform audits of RPAD data, reports, queries, and tables to identify weaknesses in RP data integrity, reliability, or technical processes.

Work with Revenue Management, Commercial, Operational, Information Technology, and peer Revenue Accounting teams, to define, prioritize and support execution of initiatives that contribute to revenue growth, customer satisfaction, and enhanced controls and data analytics.

What You Need To Succeed (Minimum Qualifications)

• Proficient with SQL and scripting languages like Python
• Proficient building automated dashboards, reports, and analysis in Tableau, and other analytical BI tools (e.g. SAS, Hyperion Brio, TOAD, Cognos, Alteryx, AWS Quick Sight, etc.) based on business needs
• Proficient in MS Office applications
• Consistently makes safety and security, of self and others, the priority
• 5 years of relevant work experience or equivalent number of years relevant work experience
• Proven track record of performing complex data analysis with large data sets
• Proven success in understanding and managing complex processes
• Experience building decks and presentations that clearly articulate key messages
• Ability to communicate clearly to business leaders and technical developers
• A self-starter who exhibits curiosity and thinks creatively to help understand and identify solutions
• Must have the ability to work well with diverse groups in a time sensitive and team environment with minimal supervision
• Excellent coaching skills
• Results oriented and capable of prioritizing work assignments and meeting or exceeding deadlines with attention to detail and follow through
• Consistently prioritizes safety and security of self, others, and personal data
• Possesses a high school diploma, GED, or high school equivalency
• Is at least 18 years of age and has authorization to work in the United States

What Will Give You a Competitive Edge (Preferred Qualifications)

• Bachelor's Degree with major in quantitative discipline such as Business Administration, Economics, Finance, Engineering or Information Systems
• MBA/MA/MS, strongly desired
• Combination of at least 3 years of relevant working experience in Revenue Accounting, Financial and Analytical Applications (especially DL systems like Revenue Pipeline, BARTS, etc.), Revenue Management, Internal or External channels, Project Management, Consulting, Technical Development
• Experience working in an Agile environment, worked within an accounting or financial system, and who has written, tested and executed/managed user stories from inception through post-implementation

Benefits And Perks To Help You Keep Climbing

• Competitive salary, industry-leading profit sharing program, and performance incentives
• 401(k) with generous company contributions up to 9%
• Paid time off including vacation, holidays, paid personal time, maternity and parental leave
• Comprehensive health benefits including medical, dental, vision, short/long term disability and life benefits
• Family care assistance through fertility support, surrogacy and adoption assistance, lactation support, subsidized back-up care, and programs that help with loved ones in all stages
• Holistic Wellbeing programs to support physical, emotional, social, and financial health, including access to an employee assistance program offering support for you and anyone in your household, free financial coaching, and extensive resources supporting mental health
• Domestic and International space-available flight privileges for employees and eligible family members
• World-wide partnerships to engage in community service and innovative goals created to focus on sustainability and reducing our carbon footprint
• Recognition rewards and awards through the platform Unstoppable Together
• Business Resource Groups created to connect employees with common interests to promote inclusion, provide perspective and help implement strategies
• Access to over 500 discounts, specialty savings and voluntary benefits through Deltaperks such as car and hotel rentals and auto, home, and pet insurance, legal services, and childcare