• Job Description

  Req#: afa2575a14d679e15f18be692bf3ee44
  Job Post has been updated successfully

  Job Share

  Recipient Email

  Share Cancel

  Job Description

  • Share
  • Share

    • Email
    • Facebook
    • Twitter
    • Linkedin
  • Print

  Programmer Analyst- AMANDA by Granicus

  Remote Job - United States | Posted - 07/14/23

  Apply Easy Apply

  Overview

  Role – Programmer Analyst- AMANDA by Granicus

  Location- Remote

  Position type- Contract on W2

  Job description:

  • Experience with AMANDA solution from Granicus (formerly Calytera)

  • Experience in creating document templates and generating letters in AMANDA by Granicus

  • Ability to write complex SQL statements

  • Experience in developing reports using a report writer

  • Experience in developing dashboards using analytics tool

  • Strong communication and presentation skills

  Job Description

  The Reports Specialist is responsible for developing dashboards and reports from various data sources. The ideal candidate should have prior experience of developing dashboards using analytics tool as well as developing reports using report writers.

  Responsibilities

  • Applying strong analytical skills for creating various reports and dashboards in tools like Microsoft Power BI, Tableau etc.

  • Conduct requirement reviews with Business Analyst to clarify reporting needs

  • Participate in Agile software development process by attending daily standups and providing updates

  • Provide effort estimation for reporting user stories

  • Design and develop reports and various types of dashboards (informational, predictive, actionable etc.)

  • Test reports and dashboards with larger sets of data to validate accuracy

  • Demonstrate developed reports and dashboards to SME’s and stakeholders

  • Work with Solutions Architect and development team to coordinate promotion of reports and dashboards from one environment to another (dev to test, etc.)

  • Provide support to the QA team during the testing phases of the project

  • Assist in UAT and user training activities

  • Review change requests and discuss with Business Analysts

  • Review and resolve bugs reported by QA/Testing team

  • Perform root cause analysis to avoid or reduce future bugs

  Skills

  • Experience with AMANDA solution from Granicus (formerly Calytera)

  • Experience in creating document templates and generating letters in AMANDA by Granicus

  • Knowledge of AMANDA database structure and table relationships

  • Extensive knowledge on various AMANDA database objects related to Folders and People

  • Experience with Microsoft SQL Server

  • Knowledge of T-SQL

  • Ability to write complex SQL statements

  • Ability to tune SQL queries for better performance

  • Experience writing stored procedures and functions

  • Experience in developing reports using a report writer

  • Experience in developing dashboards using analytics tool

  • Ability to develop various jobs using a job scheduler

  • Strong communication and presentation skills

  Highly Desired Skills

  • Experience in developing Yellowfin BI dashboards (Highly Desirable)

  • Experience in developing reports in Crystal Reports

  • Experience in exporting configuration data from one environment to another (dev to test, etc.)

  • Knowledge of configuring user security in Yellowfin BI

  Thanks and Regards,

  Prakash Singh | Office: 614-495-9222 x 417

  Prakash.ks@usgrpinc.com

  eye

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice