Complete Description:
The IT Consultant will work for the IT Strategic Investment Services (SIS) team supporting the design, development, and maintenance of the financial and performance management dashboards using business intelligence and/or discovery tool that will improve transparency, accountability and lower cost of government operations. This new initiative in FY2014 will transform how government uses financial and performance management data. End users will have access to data that is presented in context so optimal decisions can be made by transforming data into strategic business goal while monitoring progress throughout the fiscal year. The developer will also work with other teams at the Applications division to develop and implement the above dashboards as well as other assigned dashboards, databases and applications.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Advanced Excel skills, to include the use of financial data analysis and “what if” functions, as well as, the creation of pivot tables or charts
Required
5
Years
3 - Expert
Experience in demonstrating knowledge of data warehousing concepts
Required
5
Years
3 - Expert
Experience as a business analyst with a focus on requirements gathering and data analysis
Required
5
Years
3 - Expert
Experience developing dashboards using a variety of business intelligence/discovery tools, such as Business Objects, Tableau, Qlikview or Cognos
Required
5
Years
3 - Expert
Experience developing complex SQL queries used by reporting environments and data-driven dashboard applications
Required
5
Years
3 - Expert
Experience designing and implementing reports using SQL or creating scripts to identify and correct common errors and data inconsistencies
Required
5
Years
3 - Expert
Ability to gather sample data throughout all phases of a project and provide analysis to ensure data quality
Required
5
Years
3 - Expert
Experience with analyzing, compiling, verifying, extracting, converting, and validating data
Required
5
Years
3 - Expert
Experience creating metadata/data dictionaries, and designing and implementing reports, and creating database views
Required
4
Years
3 - Expert
Senior-level experience working through the full software development life cycle (SDLC)
Required
5
Years
3 - Expert
Experience with local/state government projects
Nice to have
1
Years
1 - Basic
Bachelor degree
Required
1 - Basic
Experience with Quickbase as a user, ideally as a programmer or analyst
Highly desired
1
Years
2 - Proficient
Basic Microsoft Office experience such as Excel, Word, and Project
Required
5
Years
3 - Expert
Experience working in a fast paced and muti-tasking technical evironment
Highly desired
5
Years
2 - Proficient
Experience in working with data architects in the design of database schema
Required
5
Years
3 - Expert