Work in Iowa Jobs

Job Information

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

IT Business Analyst (ITS3)

Print

Apply

IT Business Analyst (ITS3)

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

LinkedIn Tag

#LI-POST

Point of Contact

Morgan See - morgan.see@iowadot.us

  • Description

  • Benefits

  • Questions

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.

Selectives

916 Electronic Records Management

The 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.

AND

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;

OR

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;

OR

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;

OR

employees withcurrentcontinuous experience in the State Executive Branch that includes six months of full-time work as an Information Technology Specialist 2

For additional information, please click on thislink to view the job description.

Join Us!

Whether it's caring for those in need, making highways safer, or improving agriculture production, the work that we do matters to the people of Iowa.

We take our responsibilities and the public trust very seriously. We are committed to delivering the services that matter most to the people of Iowa. If you have the skills, the commitment and the desire to make a difference, then we invite you to explore the career opportunities available with the State of Iowa.

CareerChoices

State government is one of the largest employers in Iowa, and also one of the most diverse. From state trooper to nurse to engineer, the state offers a wide variety of career opportunities.

Benefits

The state offers paid vacation, sick time and holidays, a defined benefit retirement plan, health, dental, vision, and long-term disability insurance along with flexible spending accounts. For more information, please visit the executive branch employee benefits website.

The State of Iowa is committed to providing an outstanding employment experience. Check out thisBenefits Beyond the Paycheck brochure.

01

Do you understand that the answers to all of the following questions must be truthful, honest, and accurate to the best of your ability?

Please read all questions and answers thoroughly and make sure you understand them completely. Ensure the answers to your questions match the information filled out on your application and the attachments you have uploaded. If the answers to your questions are inconsistent with your application information or uploaded attachments, you will be given zero points for the question.

Knowingly misrepresenting the facts when submitting any information related to an application, examination, certification, appeal, or any other facet of the selection process will result in your disqualification from this application and future employment with the state of Iowa.

  • Yes - I understand and agree.

  • No

02

PLEASE READ CAREFULLY

Have you filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq?

  • No - I have NOT filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq

  • Yes - I HAVE filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq

03

Have you graduated from an accredited college or university with a Bachelor's Degree? IF YES - How many months do you have 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?

  • I have not graduated from an accredited college or university with a Bachelor's Degree

  • Less than 12 months of experience in the identified areas

  • 12 months or more of experience in the identified areas

04

Have you completed an approved curriculum/specialized training program developed and implemented by or in cooperation with State Government; or completed eighteen semester hours of accredited college or university course work in one of the specialty areas listed in number one (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); or received certification by an authorized educational institution/major computer or software producer in an area directly related to one of the specialty areas listed in number one? IF YES - How many months do you have 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?

  • I have not completed a specialized curriculum

  • Less than 12 months of the identified experience

  • 12 months or more of the identified experience

05

How many years do you have of a combination of post high school education in any field AND/OR 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? Thirty semester hours equals one year of experience.

  • I do not have any of the education and/or experience

  • Less than five years of the combined education and/or experience

  • Five years or more of the combined education and/or experience

06

Are you a current State of Iowa employee (executive branch)? IF YES - How many months of experience do you have in the classification of Information Technology Specialist 2 for the State of Iowa?

  • I am not a State of Iowa employee

  • I do not have any experience in the classification of Information Technology Specialist 2 for the State of Iowa

  • Less than six months of experience in the classification of Information Technology Specialist 2 for the State of Iowa

  • Six months or more of experience in the classification of Information Technology Specialist 2 for the State of Iowa

07

Does your application demonstrate that you have 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?

  • Yes

  • No

08

Does your application demonstrate that you have the 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?

  • Yes

  • No

Required Question

Agency

State of Iowa

Agency

645 Iowa Department of Transportation

Address

800 Lincoln WayAmes, Iowa, 50010

Website

https://iowadot.gov/careers/

Apply

Please verify your email addressVerify Email

DirectEmployers