Brooksource
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 required
- Experience with SQL, Python, Azure Databricks, Azure Data Factory, Alteryx, Tableau, Microsoft Excel, Power BI, or other Business Intelligence tools is strongly preferred
- Thorough understanding of company Financial and Accounting data preferred
- Self-starter with strong quantitative and planning skills required
- Ability to independently identify issues, conduct research, analyze data, and propose solutions
- Leadership and organizational skills
- Creative thought process and visionary attitude
- Ability to build alliances & reach effective solutions across multiple departments
- Ability to work independently and manage multiple dependencies
- Ability to effectively communicate verbally and written with all levels of the organization
- Outstanding interpersonal skills - for building relationships and working successfully with business partners, technical teams, and all levels of management
- Must have the ability to understand and explain complex systems and be effective working as a liaison between technical and non-technical groups
- The successful applicant will have an aptitude for problem identification and resolution including securing inter-departmental and intra-departmental cooperation
- Attention to detail and an ability to understand complex, interrelated elements are necessary
- Capable of effectively working with people of varying backgrounds and levels
- Significant 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 management
- Ability 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