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