Overview
Skills
Job Details
-
72 months experience as a Cognos Reports' Writer/Developer, working with multiple cross-functional teams analyzing existing reports, developing future reports and designing/configuring models/modules using Cognos BI Framework Manager and Data Module. This includes design, development and management of multi-dimensional reports, models, dashboards and ETL data structures.
-
60 months experience in end-to-end Cognos BI (version 11.1.7 and higher) model/module configuration, security, architecture design, administration and maintenance.
-
84 months experience in database management systems, such as Oracle, Microsoft SQL Server SSRS, SSIS integrations and PL/SQL for creating, updating and deploying reports, packages, and writing/troubleshooting TSQL statements, creating stored procedures, views, triggers, and SQL functions.
-
84 months of experience with analytics, API integrations and dashboards delivery using Cognos, EZSpec, Power BI, SSIS, SSAS and SSRS, with ability to work in waterfall, agile and hybrid frameworks.
-
72 months of experience in all types of reports testing (including functional, regressions, integration, etc.), model/module testing, business process validations reporting needs and data sanity checks. This includes writing and executing test plans, various types of report test cases, report testing procedures & cycles, testing of manual and automated reports, defects tracking, reporting bugs resolution, periodic testing results communication and requirements-based validation/testing for final deliverables sign-off.
-
60 months of experience in supporting cross-functional technology solutions such as Unisys Agile Business Suite, Cognos BI, MS Power Automate & Power BI, Salesforce, Databridge, Tableau, and Talend.
-
60 months of experience in delivering Cognos BI training to end-user and IT staff in Cognos Reports Authoring, Dashboard Creation and Data Modules Configuration, and developing user/help guides, toolkits and SOPs.
-
36 months of reports creation and maintenance experience in Crystal Reports, Talend, Tableau, or similar reporting, data visualization and dashboard analytics tools.
-
Obtained at least one of the following certifications along with their verifiable certification numbers, where applicable. Submit certification copies.
-
IBM Cognos BI Certification
-
MS Power BI certification
-
Any Microsoft SQL server, data visualization, database fundamentals certifications.
-
Cloud/CRM Reporting certifications such as MS Dynamics, Salesforce, Tableau, etc.
-
-
Project Management Professional Certification
_________________________________________________________
Agency: New York State Department of Education
Project: EFRT Reports Migration Converting EZspec reports to Cognos reports
Detailed Job Description: The IT Specialist Report Writer will work with multiple technical, business and project management teams to define and meet reporting requirements, develop Cognos model/module, dashboards, KPIs and reports. Contribute towards Requirement Analysis, Data Architecture and Modeling, Data Engineering, Systems Integration, Program/enterprise-level Reporting, all types of reports testing and other project deliverables. Candidate will be assigned to multiple projects. This position would be a Cognos Reporting Expert, who would work with the STAC/Medicaid, Rate Setting and State Aid Units to recreate model/module, reports and dashboards in Cognos BI, which is the reporting tool that will be used once EFRT is migrated off of the mainframe to Unysis.