Computer Software Developer

End client requires IT professional services to support day-to-day financial reporting needs for critical business functions and objectives related to the reporting and compliance requirements. This includes

• Extensive knowledge of IBM/Cognos Reporting/Analytics, Modeling, OLAP and ETL tools.
• Implementation of new reports, dashboards and the enhancements of existing reports.
• Engaging closely with business stakeholders and providing functional translation of Business requirements to ensure
• expectations for project successes.
• Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms

High-Level Effort Goals:

• Delivering reports in a timely manner to meet any type of compliance deadlines and prevent any temporary withholding of aid as applied to the end client.
• Position Specialist 2 (Computer Software Developer) to provide support for the deployment of reporting and compliance requirements across end client's central offices, including provisioning of technical support. The Specialist 2 will be responsible for:
• Conducting requirements meetings with end-users utilizing quantitative, analytical and business skills and knowledge to understand crucial data needs for different business users within the end client.
• Serving as point of contact to the end client's Senior Manager of overall Reporting Software Projects
• Engaging with business users, translating technical designs, implementing best practices, performing user acceptance testing (UAT), migrating to production, mentoring end users and providing training.

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 to understand crucial data needs for different business users within the end client.
• 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).