Computer Software Developer

Job Description:

DFO 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 Department of Education.
Position – Specialist 2 (Computer Software Developer) to provide support for the deployment of reporting and compliance requirements across DOE 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 Department of Education (DOE).
Serving as point of contact to the DOE 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.
 

OUTLINE OF 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 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