Job Seekers, Please send resumes to resumes@hireitpeople.com
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 consultant 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. The candidate must have strong DBA background with great SQL knowledge and experience.
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 |
