Job Seekers, Please send resumes to resumes@hireitpeople.com
Complete Description:
The IT Consultant will work for the IT Strategic Investments Services (SIS) team supporting the design, development, and maintenance of the procurement 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. For the first couple dashboard projects, the consultant will work with the Business Discovery tool called QlikView. The candidate must have experience in creating data models, designing and developing the User Interface with QlikView as well as a strong SQL knowledge background with some experience with .Net development.
Extension of performance period is a strong possibility.
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 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 |
Basic Microsoft Office experience such as Word, Project and Visio |
Required |
5 |
Years |
3 - Expert |
Experience working in a fast paced and muti-tasking technical evironment |
Highly desired |
5 |
Years |
2 - Proficient |
Strong SQL and data analysis with the ability to move data from Database into presentation via .Net development |
Required |
3 |
Years |
3 - Expert |
Experience designing, developing the data model and front end user interface using Qlikview |
Required |
2 |
Years |
3 - Expert |
Certified in QlikView 11 Developer and Designer |
Required |
|
|
1 - Basic |
Data Architecture and Application Development Experience using Qlikview |
Required |
3 |
Years |
3 - Expert |
Scripting/Data Modeling – Proficiency with QlikView Scripting, use of complex QlikView functions, experience with complex data models and optimization |
Required |
3 |
Years |
3 - Expert |
Strong knowledge on QlikView server architecture and experience in building QlikView dashboards applying business rules and data validations |
Required |
3 |
Years |
3 - Expert |
Experience with enterprise application development for use in production environments using QlikView. Well versed with deployment methodologies |
Required |
3 |
Years |
3 - Expert |
Full understanding of the processes of data quality, data cleansing and data transformation |
Required |
5 |
Years |
3 - Expert |
Strong knowledge and experience in all chart types and their characteristics |
Required |
5 |
Years |
3 - Expert |
Experience in creating complex visualizations for dynamic aggregation, actions and triggers |
Required |
3 |
Years |
3 - Expert |
Ability to define the overall QlikView architectural design and application designs |
Highly desired |
|