Apply now »

Title:  Analyst Financial Systems

Location: 

Long Island City, NY, US, 11101

Req ID:  22244

Position Summary

The Analyst plays the lead role in supporting the Accounting team in their data analysis and reporting needs.  In addition, the Analyst coordinates with Accounting, IT, and external business partners on data and database related efforts and works to create efficiencies in operational processes.

Essential Responsibilities

  • Develops custom queries utilizing SQL in the Snowflake data warehouse (DW) and BI tools.
  • Develops reports in BI tools to deliver data automatically to team members
  • Provides information from DW queries to team members via excel on an ad-hoc or recurring basis and ensures efficiency of data integrity of DW data, query results, and deliverables authored DW queries
  • Continually coordinates with team members to understand data needs and creates new reports and improves existing reporting as business needs evolve
  • Coordinates with Accounting, IT, and business partners on data requirements, data modeling, and data structure design to improve DW data relevance and enhance DW performance
  • Assists with the implementation and testing of system upgrades from a data perspective
  • Helps create detailed test cases and test plans, assists with testing automation, and validates test results
  • Analyzes and documents  business procedures and requirements and provides input on how to create efficiencies in new or existing operational processes
  • Develops excel macros to create efficiencies in operational processes where appropriate
  • Assists Managers and Directors with data-driven or technical projects as required
  • Assists other business units as required
  • Other duties as assigned

Minimum Experience and Qualifications

  • Bachelor’s Degree in MIS, Finance, Business, Accounting or related area
  • One (1) year of analytical experience
  • Strong knowledge of SQL and relational database concepts
  • Strong knowledge of report development
  • Must pass a ten (10) year background check and pre-employment drug test
  • Must be legally eligible to work in the country in which the position is located

Preferred Experience and Qualifications

  • Strong knowledge of report development, TIBCO Spotfire, Snowflake, Microsoft SSRS, or other BI tools
  • Strong knowledge of the Microsoft Office suite with advanced Excel knowledge, and some knowledge of or strong willingness to learn VBA/macro development
  • Experience with Management Information Systems (MIS) or other  relevant work experience 
  • Experience with one or more BI tools
  • Strong knowledge of Microsoft SSIS and ETL techniques
  • Familiarity with SAP or other financial systems
  • Knowledge of basic accounting principles and relevant transactional data
  • Previous Airline experience
  • Strong analytical and mathematical skills
  • Excellent verbal and written communication skills
  • Strong attention to detail

Crewmember Expectations:

  • Regular attendance and punctuality
  • Potential need to work flexible hours and be available to respond on short-notice
  • Well groomed and able to maintain a professional appearance
  • When working or traveling on JetBlue flights, and if time permits, all capable crewmembers are asked to assist with light cleaning of the aircraft
  • Must be an appropriate organizational fit for the JetBlue culture, that is, exhibit the JetBlue values of Safety, Caring, Integrity, Passion, and Fun
  • Promote JetBlue’s #1 value of safety as a Safety Ambassador, supporting JetBlue’s Safety Management System (SMS) components, Safety Policy and behavioral standards
  • Identify safety and/or security concerns, issues, incidents or hazards that should be reported and report them whenever possible and by any means necessary including JetBlue’s confidential reporting systems (Aviation Safety Action Program (ASAP) or Safety Action Report(SAR))

Equipment:

  • Computer and other office equipment

Work Environment:

  • Traditional office environment

Physical Effort:  

  • Generally not required, or up to 10 pounds occasionally, 0 pounds frequently. (Sedentary)


Nearest Major Market: Brooklyn
Nearest Secondary Market: New York City

Apply now »