Job Description

United Airlines is seeking talented individuals to provide data-driven support to project teams within Internal Audit department. This position will primarily work with Audit Manager & Project Leads to ensure audit teams obtain the structured and unstructured data related to the areas of the assignment in scope.  Develop testing algorithms that provide more efficient and extensive population coverage, and design data visualization dashboards to accompany published audit reports.

Responsibilities

• Support the audit team to scout, document, and – where necessary – obtain access to the associated data landscape(s).
• Develop queries and test scripts aimed at identifying transactional and operational patterns, instances of non-compliance, and emerging risks
• Design and support digital dashboards that visualize audit results and findings
• Support the audit team in maintaining functionality and managing departmental access to analytics specific software and hardware, including Spotfire library & private SQL servers
• Support audit team solve business problems using data analysis, data mining, and data visualization tools under the direct supervision of the Manager
• Assist with special projects, contracted services and other agreed upon procedures requested of the Internal Audit department
• Perform financial and IT testing for SOX 404 and 302 compliance
• Develop and maintain productive client, staff, and management relationships through individual contacts and group meetings.

This position is offered on local terms and conditions. Expatriate assignments and sponsorship for employment visas, even on a time-limited visa status, will not be awarded.

Required 

• Bachelor’s degree
• 4+ years of experience with analytics
• Experience using database querying tools and able to write queries and procedures using Teradata SQL and/or Microsoft TSQL
• Extensive experience with data analytics and visualization tools such as Spotfire, Power BI, Alteryx Python (including Pandas and Jupyter), Power Query
• Must be legally authorized to work in India for any employer without sponsorship
• Successful completion of interview required to meet job qualification
• Reliable, punctual attendance is an essential function of the position

Preferred

• Master’s Degree in a quantitative field like Math, Statistics, Operations Research and/or MBA
• CIA, CPA, or CISA
• Certified Analytics Professional (CAP)
• Experience in testing internal controls around financial, application, and IT general controls (ITGCs)
• Knowledge of and skill in applying auditing principles and practices
• Experience working with unstructured data
• Direct experience in the transportation/aviation fields
• Knowledge of SAS or R

Skills Required

• Python
• SQL