Previous Job
Developer Analyst 2
Ref No.: 14-01328
Location: Austin, Texas
Texas Water Development Board
Austin, TX
10 months

1040 hours

The Department of Information Resources (DIR) requires the services of one Developer Analyst, hereafter referred to as Worker(s), who meets the general qualifications of ITSAC Developer Analyst 2 Category, Core Technology Type and the specifications outlined in this document for the Texas Water Development Board (TWDB).

All work products resulting from the project shall be considered "works made for hire and are the property of the TWDB. TWDB may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. TWDB will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).

The selected Worker will be assigned to work for the Operations & Administration Area, Information Technology Division of the company. The Worker will work under the direct supervision of the Application Services Manager and the Technical Architect. The Worker will perform complex computer systems analysis work and will be responsible for generating reports in Microsoft SQL Server Reporting Services (SSRS). The Worker will collaborate with business areas and end users to determine layout and data requirements for reports. Work involves analysis of user requirements and procedures to remediate data and develop data-related reports. The Worker will demonstrate superior technical ability to create informative and aesthetically pleasing reports in SSRS using SQL queries, stored procedures, parameters, grouping, and sub-reports. The Worker will work under general supervision, with moderate latitude for the use of initiative and independent judgment.

Essential Job Functions
Designs, develops, and maintains SSRS reports.
Analyzes and develops complex Microsoft SQL Server queries, views, and/or stored procedures.
Demonstrates verbal and non-verbal communication skills to gather and document business requirements from business areas and end users.
Works closely and amicably with business areas and end users in multi-disciplinary teams.
Develops systems requirements specifications using some combination of interviews, document analysis, requirements workshops, storyboards, surveys, business process descriptions, use cases, scenarios, business analysis, and/or task and workflow analysis.
Converts systems requirements into functional design documents to develop SSRS reports.
Performs data analysis and data querying.
Coordinates testing and deployment of SSRS reports.
Troubleshoots and solves problems related to SSRS reports.
Performs related work as assigned.
Bachelor's degree from an accredited college or university with major coursework in Computer Science, Information Science, Information Technology or related field (A PHOTOCOPY OF OFFICIAL COLLEGE OR UNIVERSITY TRANSCRIPT MUST BE ATTACHED TO APPLICATION)
Relevant experience may be substituted for degree on a year-for-year basis.

Minimum Requirements:
Years Skills/Experience
5 Experience designing and developing reports using Microsoft SQL Server Reporting Services, Microsoft SQL Server Management Studio, and Business Intelligence Development Studio
5 Experience with relational databases and the software development life cycle
4 Object-Oriented Analysis, Design, and implementation skills
3 Experience with Windows Server 2003/2008, Microsoft Internet Information Services 7.0+
3 Experience prioritizing deadlines
3 Worked in an application team environment consisting of Project Manager, System Analyst, Database Administrator, and Programmers
3 Skill in providing excellent customer service
3 Ability to establish and maintain effective working relationships with peers, users, technical staff and management
3 Excellent Communication skills, written and oral, with people of all technical levels
3 Skill in decision making and problem solving

Years Skills/Experience
1 Experience with financial computer applications
1 Familiarity with water resources information.
1 Experience with regional and state water planning in Texas