Business Analyst (Cognos / SQL / Social Services)

Trigyn Technologies Limited; City of Rensselaer (NY); Vor Ort; USD 90.000 - 120.000; Vollzeit

Zusammenfassung

Trigyn Technologies, Inc. is seeking a skilled Business Analyst in Rensselaer, NY to drive BI projects from requirements to delivery. You will gather business needs, support design, and write complex SQL for reporting.

You will model data with Cognos Framework Manager and Transformer, ensuring secure data access across reports and packages. The role requires 7+ years in requirements and Cognos development, plus a Bachelor’s degree.

Qualifikationen

• 7+ years of experience in business requirement gathering, analysis and design (84 months).
• 7+ years creating/modifying Framework Manager models with Cognos tools.
• 7+ years creating/modifying reports using Cognos tools.
• 7+ years using SQL for analysis and reporting with complex joins and formatting.
• 7+ years testing reports and dashboards; presenting data issues to stakeholders.
• 7+ years in social services or related fields.
• Bachelor’s Degree required.

Aufgaben

• Collaborate with staff and participate in business requirements 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 Cognos Framework Manager and Transformer to support reporting initiatives.
• Secure Framework Manager and Transformer models with data/object/package level access controls.
• Create advanced reports using Cognos Analytics 12 with multi-query datasets.
• Complete testing of reports, dashboards, and analytics in all environments.
• Transfer knowledge to Cognos users and provide troubleshooting support.

Kenntnisse

Business requirement gathering

Analysis and logical design

SQL for analysis and reporting

Cognos reporting

Data modeling

Troubleshooting and problem solving

Stakeholder communication

Ausbildung

Bachelor’s Degree

Tools

Cognos Framework Manager

Cognos Transformer

Cognos Analytics

Jobbeschreibung

Trigyn's direct government client has an immediate need for Business Analyst in Rensselaer, NY.

Description:

• Work collaboratively with staff 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.
• Modeling using IBM Cognos BI Framework Manager and Transformer to support mission critical reporting initiatives including all layers of the model and package development.
• Securing the Framework Manager and Transformer models for data level, object level and package access security.
• Create advanced reports using IBM Cognos Analytics 12, which include but are not limited to several pages with conditional formatting and joining multiple queries to produce a single dataset for the requested report.
• Complete testing of all reports, dashboards and analytics in all environments prior to business owner review/approval.
• Transfer knowledge to other Cognos users creating their own reports in person and using electronic technologies.
• Provide troubleshooting and end user support and problem resolution.
• Research and develop solutions utilizing new product functionality to integrate into Human Services Cluster business deliverables.

Mandatory Qualifications:

• Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 Months of Experience in business requirement gathering, analysis and logical design; translating issues both in oral and written communication
• 84 Months of Experience in creating and modifying Framework Manager models.
• 84 Months of Experience in creating and modifying reports using COGNOS tools
• 84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining queries sourced from multiple tables or views
• 84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting data challenges to stakeholders
• 84 Months of Experience working in social services or related fields
• Bachelor’s Degree.

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.