Work in Iowa Energy Jobs

Job Information

Iowa Department of Transportation IT Business Analyst (ITS3) in Ames, Iowa

Salary $54,745.60 - $83,324.80 Annually

Location Ames - 50010 - Story County, IA

Job Type Full-time

Agency 645 Iowa Department of Transportation

Job Number 21-01727

Closing 1/31/2021 11:59 PM Central

Point of Contact Morgan See -

Job Description

Only applicants who meet the Minimum Qualification Requirements and meet all selective requirements (listed below) will be placed on the eligible list. The Iowa DOT currently is not offering sponsorship for this position. Starting pay is negotiable within pay scale range, based on years of experience above minimum requirement(s). Telework options available.Our mission:The mission of the Iowa DOT is to get you there safely, efficiently and conveniently. We need talented, passionate people working together to make this happen. We are looking to grow our teams with people who share our energy and enthusiasm for making that mission a reality every single day. What we offer:

  • Paid opportunities for professional growth and development – including training, courses and conferences

  • Company provided vehicle for all work-related activities

  • Excellent benefits package

  • Collaborative, positive work environment

  • Iowa Public Employee Retirement System (IPERS) Retirement Package

  • Employee discounts from a variety of vendors

  • Biweekly vacation accrual and separate sick leave

This position will assist in maintaining and supporting the Department's electronic content management (ECM) system software and associated integration with other agency systems. It will serve as member of the team primarily responsible for implementation, operation, maintenance, documentation, training and support of the ECM software application and processes for all divisions within the DOT. Duties and responsibilities will be:

  • Provide system application and user support, user training and issue resolution

  • Determine causes of hardware or software issues related to processing documents

  • Maintain, configure, troubleshoot operational issues for ECM software

  • Document system input and business processes to combine imagery and metadata consistently

  • Develop, implement and follow quality control procedures

  • Provide backup support and respond to service tickets

  • Recreate error conditions, observing functionality

  • Conduct tests using software diagnostic tools, to determine corrective actions

  • Automating processes with tools like SQL, PowerShell, XML and C

  • Oversee and coordinate the installation and configuration of line of business applications by: coordinating installation and verifying environment configuration of application software; prioritize tasks and complete assigned tasks in timely manner; evaluate completed tasks; follow up with users to provide assistance, information and training; keep team lead informed of project progress, of additional resource needs, and of user response to the system as it develops.

  • Coordinate the implementation of applications by: completing the tasks necessary to run and maintain software; reviewing system input process documentation; reviewing end user documentation, writing documentation as necessary; training users; cross training team members; recommending and implementing solutions to problems; developing methods for adding value to system content though automation.

  • Respond to user/team requests for system enhancements and changes by: consulting on suggested changes with team lead/members; verifying that changes system performance is nominal; performing system input processes and following standards and procedures to ensure repeatability and accuracy; analyzing error conditions and recommending solutions; assisting in programming changes to improve system efficiencies; answering questions relative to use and operation.

  • Resolve problems in the operation of the system by: coordinating with team members to assist on user operations and application issues; maintaining compliance with state standards and guidelines to secure and properly preserve the integrity of agency records.

This position is a covered position under the REAL ID Act of 2005, 49U.S.C. § 30301 note, as further defined in 6 CFR Part 37. Any applicant selected for employment in this position must submit to and pass a background check of the form and content required by 6 CFR 37.45. Travel: Occasional travel may be required. Some overnight travel might be required. Must possess and maintain a valid Driver's license.


916 Electronic Records ManagementThe equivalent of six months of full-time experience performing records management functions including the creation, organization, maintenance, administrative use, security, public accountability, storage, retention, conversion of paper documents to digital formats and digital to digital functionality.


121 T-SQL Business Query Writing 6 months’ experience writing complex T-SQL queries against SQL Server database which includes:

  • SQL database experience must use most recent SQL release or two versions prior

  • Queries against normalized, de-normalized and dimensional SQL database

  • Use of database data models to design and construct queries

  • Analyzing end-user presentation requirements and business rules and then translating into T-SQL queries

  • Creating parameterized queries for application database calls

  • Providing input to DBA(s) on data element formats and data granularity necessary to meet end-user requirements

Minimum Qualification Requirements

Graduation from an accredited college or university with a Bachelor's Degree and one year of full-time experience operating a multi-job computer; installing, operating and coordinating computer based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; or designing/administering Internet sites;


an equivalent combination of education and experience substituting the completion of an approved curriculum/specialized training program developed and implemented by or in cooperation with State Government; or eighteen semester hours of accredited college or university course work in one of the specialty areas listed above; or certification by an authorized educational institution/major computer or software producer in an area directly related to one of the specialty areas listed above, for the required education;


an equivalent combination of education and experience substituting one year of the required full-time experience for each year (30 semester hours) of the required education;


employees with current continuous experience in the State Executive Branch that includes six months of full-time work as an Information Technology Specialist 2For additional information, please click on this link to view the job description. ( (Download PDF reader) (