Job Information
Iowa Department of Administrative Services IT Business Analyst (ITS3) in Ames, Iowa
IT Business Analyst (ITS3)
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