Job Description :
ETL (SSIS) and reporting tools (SSRS) were purchased from Microsoft. SSRS will be used for data warehouse reporting as well as throughout the agency for operational reporting. Overall, the Wisconsin Information System for Education Dashboard solution or WISEdash, powered by Edvantage includes the following components:
Education data model structured to enable smart, reporting on education data
Role based data access & dashboards
Public & secured reporting through the same technology to a wide variety of users with a wide variety of data needs
Simple ad hoc reporting functionality (choose a district, choose a demographic)
Advanced reporting capabilities for a limited number of power users at the district and state level to create customizable reports
Documentation, including professional development resources such as pre-made workbooks to guide understanding and use of dashboards and reports
Perform dashboard development or testing tasks.
Complete ETL or database development.
Help to identify and implement design standards.
Meet with business users to define technical requirements for dashboards and reports.
Complete new dashboard development including development of core semantic layer objects.
Create, maintain and utilize a comprehensive test plan and test cases.
Coordinate testing and quality assurance activities as needed.
Create project documentation as necessary including technical documentation related to the dashboard.
Provide recommendations and solutions for work to be completed within the environment.
Coordinate and/or perform support, troubleshooting, and issue resolution for the dashboard environment.

Knowledge and Skills
Experience with gathering requirements for data visualizations, dashboards and reports. Ability to understand business requirements and translate business needs and requirements into technical solutions.
Experience with dashboard tools, reporting tools, and/or analytical tools including use/development of a semantic layers and metadata repositories.
Experience with SQL Server 2008 and/or 2012, Oracle, SQL, query tools, reporting and Business Intelligence tools (examples include Oracle BI, Microsoft BI, Microstrategy, Cognos, Business Objects
Knowledge of ETL concepts is a plus.
Experience with security administration is a plus.
Knowledge of Team Foundation Server for version control.
Knowledge of general processes and procedures for troubleshooting.
Knowledge of key data warehouse and decision support concepts including each phase of the data warehouse lifecycle.
Knowledge of data warehouse design techniques, specifically Star/Snowflake dimensional data models.
             

Similar Jobs you may be interested in ..