Contract

Hybrid Role

Location: Remote and Onsite in Albany, NY

Responsibilities:

• Responsible for the design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence suite of products
• Provides analysis, design, development, testing and implementation of Business Intelligence, Ad-hoc and Operational Reporting.
• Maintains and curates a central repository of enterprise Business Intelligence assets including dashboards, visualization and interactive reports.
• Monitor daily reports that identify data inconsistencies, determine the resolution and revise the incorrect operational data.
• Enables capabilities available in the Business Intelligence technology such as drill-through functionality, KPI and scorecard reporting, advanced visualizations including mapping and geospatial analysis, predictive analytics, and other capabilities as they arise.
• Communicate and coordinate with members of the development team to work across multiple projects.
• Explore, actively support and work on new technology initiatives that may be of interest to the organization.
• Actively participate in troubleshooting any technical issues that the program may have.
  

Requirements:

• Level III- 7+ years of experience working on complex projects with 2 or more years in a leadership role as a Developer
• 7+ years of experience in analysis, design, development, testing and implementation of business intelligence solutions using PL/SQL & relational databases.
• 5+ years of hands-on experience with authoring and maintaining of reports using IBM Cognos suite of tools with relational databases.
  

Desired Qualifications:

• 7+ years or more of hands-on experience writing complex SQL for querying and development of reports and data analytics.
• 7+ years or more of demonstrated hands-on experience with PL/SQL writing packages, stored procedures and triggers.
• 5+ years or more of demonstrated hands-on experience developing data models, data mappings, data migrations and assisting in data warehouse design in Oracle environment for Cognos.
• 5+ years of demonstrated hands-on experience with design & development of Cognos cubes for analytical reporting.
• 7+ years or more experience of Oracle architecture and database design.
• 7+ years or more experience working with different databases structure for OLTP, OLAP & high-volume transaction systems.
• 7+ years or more experience with data visualization tools like Tableau.
• 7+ years or more experience with business reporting ofprograms like SNAP, HEAP, MEDICAID, PA, TANF.
• 2+ years or more experience with Google Big Query.

• 7+ years or more experience with Health & Human services applications.

Posted On: Friday, May 16, 2025