Overview
Skills
Job Details
Position: IT Reports Specialist (Cognos)
Location: Washington, DC (Hybrid)
Duration: 12 months+
Q006 - IT Rpt Spec
*Only submit local candidates to DMV region*
*Hybrid position - candidate will be required to be on-site 3x/week in the near future*
Duties and Responsibilities
Daily monitoring of system for nightly jobs normal completion as well as overall health of system.
Support day to day basic reporting systems, which will include help desk issues, end user support.
Work closely with users to gather reporting/dashboard requirements
Maintain and create analytic dashboards as needed.
Providing support for the creation of the OCFO Budget book
Support all .NET applications used in the building of the OCFO Budget book
Support any ad-hoc reporting as needed.
Responsible for designing, optimizing, and develop and debug new cubes dashboards and reports
Design and support Informatica ETL scripts
Support external and internal facing OCIO reporting web sites
Support all new system implementations as it relates to Cognos and Tableau interfaces and reporting
Capacity planning and recommend improvements to ensure system stability
Coordinate with appropriate personnel to determine positive solutions that increase end user satisfaction, following through to completion, and communicating resolution results; escalate to management any situation that could adversely impact the service provided to the end user
Qualifications
10+ years of experience in Modeling Enterprise-Wide Data Warehouse.
10+ years of experience in Cognos 11.7
10 + years of experience in Cognos BI applications (BI framework Manager)
5+ years of experience in Tableau 10 desktop (certified) and server professional.
5+ years of experience in Tableau developer and administrator.
10 + years of experience in Public Sector Financial systems.
10 + years of experience in Informatica 10.
10+ years of experience in .Net/ASP and Visual Basic
Technical Skills:
System Software: Cognos 11.7, Tableau 10.3, IIS, Windows 2016,
Informatica 10
Development tools: Cognos-Framework manager, Visual Studio,
.NET/ASP/Visual Basic, Informatica 10, Oracle Data Modeler, SQL Developer, Tableau Desktop
Databases: Oracle 12C Rac
Required/Desired Skills
Candidates must have ALL the Required skills in order to be considered for the position. Desired or Highly Desired skills are a PLUS but may NOT be required.
Skill Matrix (Please fill the last two columns of this matrix)
Experience with Business workflow processes | Required / Desired | Amount | of Experience | Years of Experience | Last Used |
experience in Modeling Enterprise-Wide Data Warehouse. | Required | 10 | ears |
|
|
experience in Cognos 11.7 | Required | 10 | ears |
|
|
experience in Cognos BI applications (BI framework Manager) | Required | 10 | ears |
|
|
experience in Tableau 10 desktop (certified) and server professional. | Required | 5 | ears |
|
|
experience in Tableau developer and administrator. | Required | 5 | ears |
|
|
experience in Public Sector Financial systems. | Required | 10 | ears |
|
|
experience in Informatica 10. | Required | 10 | ears |
|
|
experience in .Net/ASP and Visual Basic | Required | 10 | ears |
|
|