New York University Abu Dhabi (NYUAD) seeks to appoint a Management Reporting and Analysis Specialist.
The Reporting and Data Analytics Specialist primary responsibility is to ensure that NYUAD's budget and managerial reports address the needs of the Executive Director of Finances and Budget, the Assistant Director Budget and Financial Planning, NYUAD senior leadership, NYU NY Budget Office, departmental managers and outside funding agencies.
The candidate is expected to build strong internal and external relationships and collaborate with financial colleagues and IT application leads to empower the organization with high quality data and reporting.
Key Responsibilities:
Organizational Reporting
Deliver Monthly and Quarterly Reporting Packages: Working with the wider budget team deliver on-time reporting and update the baseline reports, ensuring all reporting reconciles with other statutory reporting produced by the management accounts team on a monthly basis
Assist the development of updated monthly and quarterly budget and actual reports for distribution to outside funding agencies, NYU leadership, departmental unit heads. This report set should include key metrics important to both NYUAD leadership and NYUAD's funders
Monthly Projection Models: Working with the wider Budget Office team, assist in the quarterly projection exercise by updating baseline reporting tools and providing supplementary datasets to assist with budget to actual and YoY analysis
Assist in the development of reporting tools that automate and enable the compilation of projection activity in order to provide a more streamlined projection process to NYUAD leadership, departmental managers and other stakeholders. Reporting will assist in the identification of expected surpluses or deficits
Expand the Existing Portfolio of Key Metrics: Working with the Assistant Director of budget and Financial Planning, expand NYUAD's existing set of metrics to determine and develop a set of metrics in support of NYUAD's key management objectives and develop supporting reports
Provide data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; cleans and prepares data, as necessary.
Work closely with leadership, finance, operations, to develop actionable reports through the available tools to maximize the use of the system’s data. Collaborate in the development of management and budget reports for senior leadership, external agencies, NYU's budget office in New York, the institutional research office and NYUAD's departmental leaders
Develop complex and customized reports, both on a proactive basis to address client needs as well as in response to user requests.
Prepare ad hoc reports using Excel, Tableau, and PowerPoint. Create charts, graphs, infographics, dashboards, etc. to support knowledge acquisition and decision making
Dashboards and Data Visualization
Develop and maintain reports created in data visualization software (Tableau)
Assist in the development and delivery of program dashboards which will provide budget analysis and support for Division heads and relevant FP&A staff
Consult with budget analysts/FP&A Managers, NYUAD leadership and budget owners to understand the business requirements that drive the analysis and design of performance dashboards and reporting solutions
Lead technical development for financial reporting, data analytics and dashboard creation and enhancements inclusive of gathering and analyzing requirements, providing design recommendations, prototyping solutions and delivering end-user assets
Financial Planning System and Annual Budget Process
Partner with the ERP Applications technical support team to maintain the financial planning and budgeting system (Hyperion Planning) including; adding dimensions, setting up scenarios and versions, managing meta data, loading and calculation of data, updating security and workflow settings
Smartview: Develop, maintain and manage monthly reporting, develop and design ad-hoc monthly reporting packs as per the Tamkeen program, data validation, co-ordination with NY Budget Office
Provide technical development support for NYUAD reporting and data analytic enablement initiatives in coordination and alignment with the NYU IT Enterprise Data Management group
Assist in the delivery of the annual budget load to NYU NY Budget Office. Ensure reconciliation with the approved budget
Data and information access
Liaise with DSG (Decision Support Group) in New York to ensure optimal application and utilization of UDW+ (the University Data Warehouse - hosted in OBIEE) for financial reporting right across NYUAD
Support delivery of UDW+ training materials and access to the wider community to ensure departments and end users have access to the information and reports they require to make informed business decisions
Work with the wider NYUAD Budget Office team to ensure units and departments have access to the tools they require to monitor resource decisions and to address budgetary problems throughout the year
Audit chartfield and reporting dashboard access (Tableau and OBIEE) to ensure end users and departments can only access relevant information
Be the first point of contact for UDW+ financial reporting data or access queries within NYUAD
Data Relationship Management System
Work with the ERP Applications team to maintain the accounts hierarchy, NYUAD hierarchy, Tamkeen hierarchy within the Data Relationship Management System, which feeds into UDW+ and Tableau datasets
Financial Reporting Coordination
Work in collaboration with ITS and Controller's Office on all financial reporting. Work with the Budget Director to develop and improve financial reporting and integrity of financial data
Advise others in the expert use of the University's financial system inquiry and reporting tools
Coordinate with finance team for fund balance reconciliation and generating reports
Additional Budget Office Support
Support the budget office team during the budgeting and planning process with reports and data for analysis
Develop reports and presentations based on data available in company’s data repository, finding compelling ways to display the analysis results
Actively contribute to the continuous improvement of department processes through ongoing initiatives including: solutions to automate, building efficiencies, and maintaining consistency across multiple dashboards
Train others and serves as subject matter expert on data integrity processes, data visualization tool usage, new techniques in data processing and analytics, and best practices; provides support for data visualization tool related questions, requests, and issues
Create effective, scalable, and easy to understand reporting solutions (e.g. dashboards)
Perform additional assignments and projects as requested by the Executive Director
Required Education:
Bachelor's degree in business management
Preferred Education:
Master's degree in management, accounting, computer science, or any related field.
Professional Financial and/or Accounting certification
Required Experience:
Minimum of 5 years’ experience or equivalent combination in data warehouse analysis, report development or business analysis
Experience working with business intelligence tools (such as Tableau, OBIEE, Power BI, Business Objects, etc.) in a data warehouse environment
Excellent knowledge of business intelligence practices and tools, including simplified query tools
Excellent knowledge of developing and monitoring against key metrics
Excellent interpersonal, presentation, and communication skills
Excellent Knowledge of reporting and business analysis
Excellent Knowledge relational databases and business intelligence technology
Knowledge of organization, training, research and planning skills
Preferred Experience:
Experience supporting a large, diverse customer base
Previous experience working within higher education
Experience working as a trainer of business processes and /or software applications
Experience with Smartview
Other Information
About NYUAD
NYU Abu Dhabi is a degree-granting research university with a fully integrated liberal arts and science undergraduate program in the Arts, Sciences, Social Sciences, Humanities, and Engineering. NYU Abu Dhabi, NYU New York, and NYU Shanghai, form the backbone of NYU’s global network university, an interconnected network of portal campuses and academic centers across six continents that enable seamless international mobility of students and faculty in their pursuit of academic and scholarly activity. This global university represents a transformative shift in higher education, one in which the intellectual and creative endeavors of academia are shaped and examined through an international and multicultural perspective. As a major intellectual hub at the crossroads of the Arab world, NYUAD serves as a center for scholarly thought, advanced research, knowledge creation, and sharing, through its academic, research, and creative activities.
