Report Specialist

Reports Specialist

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 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
• Experience using version management tools
• Strong communication and presentation skills

Highly Desired Skills

• Experience in developing Yellowfin BI dashboards (Highly Desirable)
• Experience in developing reports in Crystal Reports
• Experience with AMANDA solution from Granicus (formerly Calytera)
• Experience in creating document templates and generating letters in AMANDA
• Knowledge of AMANDA database structure and table relationships
• Extensive knowledge on various AMANDA database objects related to Folders and People
• Experience in exporting configuration data from one environment to another (dev to test, etc.)
• Knowledge of configuring user security in Yellowfin BI

Projected to go through Jan 2024. Using Amanda (COTS app). Folder table and free form table (20 character fields). Will do a lot of word merges into templates. They regulate the finance/insurance industry (it is all licensing data).

Responsibilities

• Think abstractly
• Create complex SQL queries (lot of joins)
• Using Yellowfin for report development
• Will be using Crystal Reports
• Heavier on reports vs dashboards
• Demo what they develop
• Look at requirements and figure out what is needed, go to client if needed

Required Skills: Strong SQL – Create complex queries, tuning, etc. Reporting and BI development – Preference for Yellowfin, but will take any tools (PowerBI, etc.