Management Reporting and Analysis Specialist - Budget Office

Job Number
2021-7829

Position Summary

UAE Nationals are encouraged to apply

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.