Job Description :
As a Revenue Accounting Data and Analysis Analyst, you'll be responsible for daily monitoring of the data and processes that create, load, and distribute the sales data and the flown ticket lift data. You will work with end-users of this data across the company to answer questions, address concerns and coordinate enhancements. You will be responsible for reporting on and analyzing the Sales and Flown data for Revenue Accounting and other departments. You are expected to identify issues, propose solutions, and coordinate / contribute to the implementation of proposed solutions.
Responsibilities :
- Daily monitoring and reporting on the timeliness and accuracy of Sales data and Flown ticket lift data. This monitoring includes a variety of tests on the reasonableness of data and often includes exhaustive analysis on outliers and possible data issues.
- On-going analysis and advice on departmental changes, company initiatives and industry mandates.
- Communication with end-users of Revenue Accounting data regarding questions / concerns about Revenue Accounting data / projects.
- Work as advisor and technical support for Revenue Accounting end-users on existing (Cognos, Excel, Power BI, Azure Databricks, etc.) reports.
- Work as advisor, technical support, and liaison with development team when other groups in Revenue Accounting are developing new reports.
- Work with Protiviti and KPMG teams to ensure SOX compliance of Cognos applications when required.
Job Qualifications :
Bachelor's Degree or equivalent experience / education requiredExperience with SQL, Python, Azure Databricks, Azure Data Factory, Alteryx, Tableau, Microsoft Excel, Power BI, or other Business Intelligence tools is strongly preferredThorough understanding of company Financial and Accounting data preferredSelf-starter with strong quantitative and planning skills requiredAbility to independently identify issues, conduct research, analyze data, and propose solutionsLeadership and organizational skillsCreative thought process and visionary attitudeAbility to build alliances & reach effective solutions across multiple departmentsAbility to work independently and manage multiple dependenciesAbility to effectively communicate verbally and written with all levels of the organizationOutstanding interpersonal skills - for building relationships and working successfully with business partners, technical teams, and all levels of managementMust have the ability to understand and explain complex systems and be effective working as a liaison between technical and non-technical groupsThe successful applicant will have an aptitude for problem identification and resolution including securing inter-departmental and intra-departmental cooperationAttention to detail and an ability to understand complex, interrelated elements are necessaryCapable of effectively working with people of varying backgrounds and levelsSignificant and demonstrated analytical ability. Must be able to independently identify a problem area, sift through multiple data sources and develop a sound analysis framework and present resulting recommendations to senior managementAbility to effectively use Microsoft Office Products (e.g. Word, Excel, PowerPoint, etc.)Innate curiosity - How do things work? How can they be improved?Willingness to show initiative and take ownership of job responsibilities