Job Description

State of New Hampshire Job Posting DEPARTMENT OF INFORMATION TECHNOLOGY Agency Software Division - Dept of Corrections Main Bldg - SOPS Campus Data Warehouse Developer Systems Development Specialist V LG: 28 Position #12481
*See total compensation information at the bottom of announcement.
The State of New Hampshire, Department of Information Technology, Agency Software Division - DOC has a full time vacancy for Data Warehouse Developer/Systems Development Specialist V. SCOPE OF WORK : Designs, develops and maintains complex Microsoft SQL databases that support web-based business applications and on-line reporting that are critical to the State, its business partners, and the general public. Works directly with agency management and business users to analyze, define, develop, test, document, and deploy applications and databases that support the state\xe2\x80\x99s business objectives. ACCOUNTABILITIES : Demonstrate and cultivate an understanding of all aspects of data warehousing and reporting that will enable the State to build and deploy high quality, professional and secure business applications and reports to meet agency business objectives. Interviews end users to determine requirements for new application/reports and for the modification of existing applications/reports. Design detailed functional databases for agency business applications and reports as solutions to State agencies\xe2\x80\x99 business initiatives/problems. Build and maintain complex SQL relational databases to support business applications and agency reports. Provide development, support and maintenance for State government business applications and reports that utilize data warehouse services. Perform data analytics, consolidate disparate data sources using SQL Server for data warehousing. Ensures SQL Server Integrated Service (SSIS) jobs and functions are operating at optimal levels to ensure uninterrupted services. Analyze and research acute or on-going database and/or application issues as assigned. Devise solution, assist in implementation of solution. Leads business partners in testing and certification of developed applications/reports and provides training when necessary. Perform code reviews and other duties assigned for other agency applications as needed. MINIMUM QUALIFICATIONS : Education: Bachelor\'s degree from a recognized college or university with at least fifteen (15) credit hours in the field of computer sciences. Each additional year of approved formal education may be substituted for one year of required work experience. Experience: Five years\' experience as a computer programmer or systems analyst associated with a late generation medium or large scale on-line computer systems or computer networks similar to the recruiting agency; at least two years of which shall have been involved with systems analysis. Each additional year of approved work experience may be substituted for one year of required formal education. License/Certification: Must be eligible to hold a valid New Hampshire driver\'s license and have access to transportation for use in statewide travel. SPECIAL QUALIFICATIONS : Experience in data warehouse, web application and business report development using various software languages and platforms with the following desired: Classic ASP, VB, HTML, Javascript, XML and CSS. Technical knowledge and understanding of relational database design and MS SQL skills are required, .NET knowledge and skills desired. PreferredWORK TRAITS: Displays the aptitude and desire to learn other related technologies easily and efficiently. Ability to evaluate present systems, organize data and develop new systems procedures based on user input, system constraints, and prioritized responses. Ability to communicate effectively with various department and division representatives. Ability to reduce problems to basic details. Ability to establish and maintain effective working relationships with customers, superiors, associates and with representatives from other state departments. DISCLAIMER STATEMENT : The supplemental job description lists the essential functions of the position and is not intended to include every job duty and responsibility specific to a position. An employee may be required to perform other related duties not listed on the supplemental job description provided that such duties are characteristic of that classification. For further information please contact Michael O\'Neil, Director Agency Software Division (603)

Selected candidate will undergo a fingerprint-based criminal background check and motor vehicle record check in order to ensure suitability for exposure to confidential information.

*TOTAL COMPENSATION INFORMATION
The State of NH total compensation package features an outstanding set of employee benefits, including:
HMO or POS Medical and Prescription Drug Benefits: The actual value of State-paid health benefits is based on the employee\xc2\xbfs union status, and employee per pay period health benefit contributions will vary depending on the type of plan selected.
Value of State\'s share of Employee\'s Retirement: 14.53% of pay
Other Benefits: o Dental Plan at minimal cost for employees and their families ($500-$1800 value) o Flexible Spending healthcare and childcare reimbursement accounts o State defined benefit retirement plan and Deferred Compensation 457(b) plan o Work/life balance flexible schedules, paid holidays and generous leave plan o $50,000 state-paid life insurance plus additional low cost group life insurance o Incentive-based Wellness Program (ability to earn up to $500)
Want the specifics? Explore the Benefits of State Employment on our website:
EOE TDD Access: Relay NH 1-800-735-2964