Seeking a Business Intelligence Report Writer, to assist with developing dashboards and metrics for 25 departments and offices.
Create complex reports using tools such as SQL Server Reporting Services and Power BI for?internal and external use. Gather and document functional and technical report requirements, and translate requirements into reporting solutions.
Develop in-depth understanding of underlying data, data structures, and business uses to ensure reports meet client needs.
Create test cases and work with QA team to ensure accurate and complete testing. Create technical documentation of report logic and processes.
Work with developers and analysts to understand code changes that will impact reports. Guide other IT resources in coding and report writing best practices.
Support end-user community in the use of business intelligence tools to query databases and files for report outputs. Work within and across functional and technical teams to support the acquisition of new skills and areas of expertise.
Develop and assist with report training through the development of training tools and training of key staff.
Demonstrated knowledge of Microsoft SQL Reporting and Analysis Services
Demonstrated knowledge of Microsoft Power BI
Demonstrated use of system application skills that include programming logic, system analysis, system testing, documentation, troubleshooting, and user support.
Ability to communicate business needs to technical staff as well as understand customer requirements and design user-friendly reports. Must also have the ability to work independently, and escalate issues and seek guidance as necessary.
Demonstrated knowledge of ETL, data schema design and best practices
Experience with Safe Software?s FME Platform
Experience in data warehouse support activities
Experience in managing or analyzing programs in government agencies