Software Architect - Expert

Mindlance

Rensselaer, NY

Contract

Senior

137k-147k

11 days ago

Job Description

About the Role

This role involves providing localized Cognos report administrative functions, guiding data model development, and supporting data warehouse and Oracle needs from a design perspective. The position supports Federal government reporting, generates data files in XML format, and works on reporting, analysis, and measurements related to Juvenile Justice in New York State, including ad hoc reporting as needed.

Key Responsibilities

Work collaboratively with OREPA and participate in business requirement gathering for BI projects.
Work with Business Analyst on analysis and logical design.
Perform complex SQL coding to facilitate reporting and testing functions.
Model using IBM Cognos BI Framework Manager and Transformer to support mission critical reporting initiatives including all layers of the model and package development.
Secure the Framework Manager and Transformer models for data level, object level and package access security.
Create advanced reports using IBM Cognos Analytics 11.2, including multiple pages with conditional formatting and joining multiple queries to produce a single dataset.
Complete testing of all reports, dashboards, and analytics in all environments prior to business owner review/approval.
Mentor State staff and other contract resources as required.
Lead data exchange efforts for Federal and State Reporting to content and file specifications (.xml).
Transfer knowledge to other Cognos users through in-person and electronic training.
Provide troubleshooting, end user support, and problem resolution.
Research and develop solutions utilizing new product functionality to support Human Services Cluster business deliverables.

Requirements

Experience with IBM Cognos BI Framework Manager and Transformer modeling.
Proficiency in complex SQL coding for reporting and testing.
Ability to create advanced reports with conditional formatting and multi-query joins.
Experience in securing Cognos models at various access levels.
Knowledge of data exchange processes and XML file specifications.
Strong troubleshooting and end user support skills.
Ability to work collaboratively with business stakeholders and team members.

Nice to Have

Experience with Federal and State reporting standards.
Knowledge of data warehouse and ETL processes.
Experience mentoring staff and training users.

Qualifications

Experience with IBM Cognos Analytics 11.2.
Proven experience in report development, modeling, and security.
Strong SQL and data modeling skills.

Benefits & Perks

Competitive hourly rate of $65.89-$70.89 per hour.
All on-site work location in Rensselaer, NY.

Working at Mindlance

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of minority, gender, disability, religion, LGBTQI, age, or veterans status.

Apply Now