Job Description:

WORKSITE ADDRESS - 65 Court Street Brooklyn, NY 11201

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-leveled 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 within the Department of Education (DOE).
• 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

Job Types: Full-time, Contract

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Brooklyn, NY 11201: Reliably commute or planning to relocate before starting work (Required)

Work Location: In person

Please Note :
epokagency.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, epokagency.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.