Job Description :

RESPONSIBILITIES: 

•       Creating, enhancing and maintaining reporting models to support business requirements

•       Design report models using department and company goals as a filter for processing relevant data

•       Design multi-levelled query structures

•       Write SQL Queries where necessary for complex Cognos reporting project requirements

•       Design and Implement Cognos Drill Through and Bookmark features in reports

•       Design reports using HTML tags in the Cognos Reporting Tool

•       Maintain knowledge on all new software and financial techniques to make design choice solutions

•       Monitor report response times and ensure optimal utilization of all SQL scripts

•       Conduct requirements meetings with end-users utilizing quantitative, analytical and business skills and knowledge in an effort to understand crucial data needs for different business users.

•       Coordinate with data architecture and modeling teams to prepare and design reports that best fit user’s requirements

•       Assist with managing report security, folder security, database row level security, report schedules and  distributions

•       Develop and maintain dashboards and apply data visualization best practices

•       Assures consistent quality of report results by developing, validating, and providing the necessary documentation

•       Plan, control and execute Unit and System Testing

•       Create email distributions using the Cognos automated bursting features that uses data results

•       Perform Cognos maintenance activities including schedule and report queue monitoring

•       Document report issues and problems to provide update status and resolutions to project manager

 MANDATORY MINIMUM QUALIFICATIONS

The successful candidate must have minimally achieved the following level of experience:

•       8+ years of experience supporting day to day operations of Cognos BI and Analytics

•       4+ years of experience in working with Cognos Framework Manager, data modeling and the development of packages accessing various data sources including SQL Server and DB2.

•       4+ years of experience in preparing with Microsoft Office products such as MS Project, MS Access, Visio, PowerPoint, Excel and Word where required

•       4+ years of experience in Microsoft SQL Server databases, SQL Reporting tools, Microsoft TFS and TFS Release Manager

PREFERABLE QUALIFICATIONS

•       Bachelor’s Degree or a master’s degree in computer science from an accredited college

•       Prior education industry/project experience

•       Excellent oral and written communication skills; ability to communicate in a credible and confident manner at all levels in the organization including conveying technical issues to a non-technical audience.

•       Detailed and process oriented.

•       Familiarity with city financial systems (FMS and FAMIS). 

             

Similar Jobs you may be interested in ..