Under the direction of NYC Department of Education management, the consultant will utilize analytical and architectural skills with emphasis on developing and generating enterprise reports and managerial dashboard solutions for complex business problems. The primary responsibility will include plan and design software version upgrade; develop; implement; and maintain Business Intelligence reports and dashboards using various reporting and BI tools: Cognos version 10/11 Business Intelligence, Microsoft SQL Server Reporting, Microsoft Power BI and Tableau.
Participation in requirement meetings with end-users to understand and collect Business Intelligence (BI) report and Web content needs.
Document functional and technical specifications;
Develop BI analytical and reporting solutions based on user needs.
Develop and maintain interfaces using Cognos SDK.
Develop SQL queries & stored procedures.
Collaborate with other groups to design and develop new enterprise reporting solutions.
Tune the supporting queries and report build processes to improve end-user access response times.
Design, document and deploy the front-end components of analytical applications.
Assist in the rollout, maintenance and ongoing administration of these applications.
Documentation of all tasks in accordance with Department of Education standards.