Work in Iowa STEM Jobs

Job Information

Iowa Department of Transportation Data Quality Analyst (ITS5) in Ames, Iowa

Salary $71,988.80 - $110,697.60 Annually

Location Ames - 50010 - Story County, IA

Job Type Full-time

Agency 645 Iowa Department of Transportation

Job Number 21-01162

Closing 11/30/2020 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.Starting pay is negotiable within pay scale range, based on years of experience above the minimum qualifications.Telework options available.Our Mission:For more than a century, Iowa Department of Transportation has promoted the growth and betterment of Iowa’s transportation system. Headquartered in Ames, the DOT continues to serve the transportation needs of Iowa and its citizens. As a member of our team, you’ll play a vital role by ensuring completion of the day-to-day- tasks of software development and participating in strategic planning for the overall Iowa DOT digital services. Your responsibilities will include:

  • Developing and implementing new software applications for several divisions within the Iowa Department of Transportation

  • Providing customer support of internally developed and/or purchased applications used by the divisions supported

  • Maintaining a seat on the Data Governance Committee and leading Data Governance initiatives

  • Pursuing new ways to provide analytics to the divisions supported

  • Developing project documentation

  • Working and communicating with all clients and customers providing quality professional service

Preferred skills:

  • Statistics

  • Business Information Technology

Shift:Monday-Friday 8:00 am - 4:30 pmTravel:Occasional travel may be requiredWhat 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


233 Data ModelingMust have 6 months experience acting in a data modeling role with relational database platform architecture. Required skills include:

  • Knowledge of Erwin, logical modeling, data architecture/normalization/analysis Ability to:

  • Define business rules and data requirements

  • Perform all aspects of data analysis and logical data modeling, including both 3rd normal form of online transaction protocol (OLTP) applications as well as dimensional modeling for decision support warehouse applications

  • Transform logical models into physical database designs, estimation of volumes and frequencies and denormalization as appropriate

  • Build standards and administer all data models

  • Collaborate with Data Base Administrators and the Data Warehouse Architect regarding the development and adherence of data modeling standards, methods and practices


022 Microsoft C#.Net6 months’ experience, 12 semester hours, or a combination of both in the following:

  • Developing code written in C#

  • Developing Windows forms based on applications using Microsoft C#.Net.

  • Developing web based applications using Microsoft ASP.Net.

  • Using ADO.Net to interact with Microsoft SQL Server and other data bases.


121 T-SQL Business Query Writing6 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 four-year college or university and experience equal to three years of fulltime work: 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 post high school 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 computer specialty areas listed above, for the required education;


an equivalent combination of education and experience substituting one year of the required experience for thirty semester hours of the required education;


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