Computer Software Developer

End client requires IT professional services to support daytoday 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 highlevel design choices and dictates technical standards including software coding standards tools and platforms

HighLevel 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 clients central offices including provisioning of technical support. The Specialist 2 will be responsible for:
• Conducting requirements meetings with endusers 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 clients 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 multileveled 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 endusers 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 users 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 AccessVisio 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:

• Bachelors degree or a masters 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 nontechnical audience.
• Detailed and process oriented.
• Familiarity with city financial systems (FMS and FAMIS).