Posted 3d ago

Senior Developer - Revenue Business Intelligence (Remote)

@ United Airlines
Chicago, Illinois, United States
$82k-$107k/yrRemoteFull Time
Responsibilities:Develop pricing applications, Write and optimize queries, Maintain databases
Requirements Summary:2+ years in database design/development; 2+ years data modeling; SQL and BI tools; agile; Bachelor's in CS or related field; eligible to work in United States without sponsorship.
Technical Tools Mentioned:SQL, Power BI, AWS, Redshift, DynamoDB, Teradata, Oracle, MySQL, Databricks, Control-M, Airflow, BigPanda, .NET, C#, VB, AJAX, HTML, Excel
Save
Mark Applied
Hide Job
Report & Hide
Job Description

Find your future at United! We’re reinventing what our industry looks like, and what an airline can be – from the planes we fly to the people who fly them. When you join us, you’re joining a global team of 100,000+ connected by a shared passion with a wide spectrum of experience and skills to lead the way forward.

Achieving our ambitions starts with supporting yours. Evolve your career and find your next opportunity. Get the care you need with industry-leading health plans and best-in-class programs to support your emotional, physical, and financial wellness. Expand your horizons with travel across the world’s biggest route network. Connect outside your team through employee-led Business Resource Groups.

Create what’s next with us. Let’s define tomorrow together.

Becoming the best airline is an adventure. And our Pricing & Revenue Management team is providing fuel for that journey by ensuring that we maximize our ticket revenue on every single flight across our network – both domestically and internationally – while giving our customers various product offerings for their travel. By analyzing market trends and forecasting consumer demand, this team works hard to ensure we are selling the right number of tickets at the right price to optimize our revenue and run a profitable airline.

Key Responsibilities:

Be part of a team that provides quick-turnaround technical solutions to business problems and analyses, as well as technical support and quality assurance for Revenue Management’s Systems. Assigned to business systems projects working across business organization lines. Responsibilities include the development, testing, and implementation of departmental data warehouse, reports and applications in support of the Revenue Management systems.

  • Develop new Pricing and RM applications/reports

  • Perform ad-hoc analytical queries and create routine automation queries for various department projects

  • Write, debug, upgrade efficient queries, views, indexes, stored procedures and functions within SQL, AWS Redshift, and DynamoDB databases

  • Maintain departmental databases and supporting production jobs

  • Improve existing Pricing/RM systems and processes to maximize revenue

  • Establish data integrity reviews across multiple databases to ensure data synchronization across multiple systems

  • Coordinate, facilitate and consult with all United IT organization staff on applications architecture initiatives


What’s needed to succeed (Minimum Qualifications):

  • Bachelor's degree in Computer Science, Information Systems or another related field or equivalent work experience
  • 2+ years of professional experience in Database design, development and support
  • 2+ years in data modeling tools and/or design methodologies
  • Experience with agile development methodology
  • Technical skills:
    • Database Managements Systems (SQL Server, Redshift, DynamoDB, Teradata, Oracle, MySQL).
    • SQL programming skills, experience extracting and manipulating data from relational databases with advanced SQL, stored procedures
    • PowerBI reporting creation and maintenance
  • Non-technical skills:
    • Ability to effectively prioritize and execute tasks in a high-pressure environment
    • Strong oral and written communication skills
    • Proven project organization skills, including project prioritization, planning, and organization
  • Must be legally authorized to work in the United States for any employer without sponsorship

What will help you propel from the pack (Preferred Qualifications):

  • Experience in Revenue Management or Pricing
  • 5+ years of professional experience in Database design, development and support
  • 5+ years in data modeling tools and/or design methodologies
  • Knowledge of Enterprise Scheduling Application such as Control M, Airflow, and BigPanda
  • .NET/Web Programming (C#, VB, AJAX, html)
  • Knowledge of Excel macros and VB script
  • Experience with version control software
  • Amazon Web Services (AWS) cloud structure knowledge
  • Knowledge of Databricks

United Airlines is an equal opportunity employer. United Airlines recruits, employs, trains, compensates and promotes regardless of race, religion, color, national origin, gender identity, sexual orientation, physical ability, age, veteran status and other protected status as required by applicable law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform crucial job functions. Please contact [email protected] to request accommodation.