GIS Specialist

Full Job Description

We are seeking a GIS Specialist to join the Research & Analytics team, supporting quality management and geospatial strategy within the Iowa Department of Transportation (DOT).

This role ensures compliance with standards, governance, and strategic business planning while working collaboratively across DOT bureaus and GIS teams.

Key responsibilities include:

The ideal candidate will have expertise in integration, GIS software, spatial data analysis, and project management.

Location: Ames – 50010 – Story County, IA

Shift Requirements: Days, Monday-Friday; Flexible schedule available. Some travel may be required

Iowa Department of Transportation’s Mission is Making Lives Better Through Transportation.

To accomplish our Mission, the person selected for this position will demonstrate actions and behaviors guided by the Iowa Department of Transportation’s five CORE values: Safety First, People Matter, Customer Focused, Servant Leadership, and Integrity Without Exception.

As a State of Iowa employee, you will be eligible for the following benefits:

We encourage you to learn more about the State of Iowa Employee benefits and costs at the State of Iowa Employee Benefits Website!

You have the freedom to flourish in Iowa – Apply now!

The Iowa Department of Transportation is an equal-opportunity employer.

If you require a reasonable accommodation in completing any screening, interviewing, pre-employment testing, or otherwise participating in the selection process, please direct your request to the Affirmative Action & Equal Employment Opportunity (AA/EEO) Officer at: aa-eeo@iowadot.us.

Reasonable accommodation, such as an interpreter, translator, written materials, modified equipment/devices, ADA access, etc. This does not include scheduling needs.

The State of Iowa participates in E-Verify, a federal program that helps employers confirm the employment eligibility of all newly hired employees.

Within the required timeframe, new hires will be verified through the E-Verify system to ensure authorization to work in the United States.

The State of Iowa also complies with the federal Right to Work laws, which protect employees’ rights to work without being required to join a labor organization.

For more information, please visit www.e-verify.gov.

Requirements

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

"OR"
230 Categorical Selective List Geographic Information Systems (Department of Natural Resources)

• 18 semester hours of education or 1 year of experience that demonstrates the applicant has competencies in the following areas:
• Ability to create, edit, import, export, project, and georeference GIS data.
• Demonstrated proficiency with the major ESRI software products. These products include ArcView, ArcInfo, ArcGIS.
• Utilize user-developed and/or ESRI scripts and extensions for incorporation and utilization in projects.
• Ability to conduct spatial analyses and queries in order to answer complex questions relating to spatial data.
• Ability to produce cartographic documents which clearly present outputs from spatial analyses. Document formats should at a minimum include hardcopy as well as the following digital formats .pdf, .tif, and .jpg.
• Ability to work with, or train, others to use GIS to attain a common goal

Applicant must provide specific work examples to demonstrate each of the competencies. The examples should include a thorough explanation of the project goal, the process utilized and the result of the process.

"OR"
984 Business Information Technology
6 months' experience, 12 semester hours, or a combination of both, in business information technology including any of the following: support for management decision-making using computer technology, i.e., computer decision support systems, billing, accounting, queries, data modeling, and IT/manager interface including support for individual, group and corporate goals and managerial concerns with the design, use and implementation of information technology.

Qualifications

Applicants must meet at least one of the following minimum requirements to qualify for positions in this job classification:

1) Six years of full-time work experience in business/data/statistical analytics, economic research,

or data science.

2) Graduation from an accredited four-year college or university with a degree in business analytics,

economics, data science, statistics, mathematics, management information systems, or

industrial management, and experience equal to two years of full-time work (as described in

number one).

3) All of the following (a and b):

a. A total of four years of education and/or full-time experience in business/data/statistical

analytics, economic research, or data science, where thirty semester hours of accredited

college or university coursework in business analytics, economics, data science, statistics,

mathematics, management information systems, or industrial management equals one year of

full-time experience; and

b. A total of two years of graduate-level education and/or full-time experience (as described in

part a), where twenty-four semester hours of accredited graduate college or university

coursework in business analytics, economics, data science, statistics, mathematics,

management information systems, or industrial management equals one year of full-time

experience.

4) All of the following (a and b):

a. A total of four years of education and/or full-time experience in business/data/statistical

Analytics, economic research, or data science, where thirty semester hours of accredited

college or university coursework in any field equals one year of full-time experience; and

b. Graduation from an accredited college or university with a Master’s degree in business

analytics, economics, data science, statistics, mathematics, management information

systems, or industrial management.

5) All of the following (a, b, and c):

a. Two years of full-time work experience in business/data/statistical analytics, economic

research, or data science; and

b. A total of four years of education and/or full-time experience (as described in part a), where

thirty semester hours of accredited college or university coursework in any field equals one

year of full-time experience.

c. Possession of a professional certificate in data science, business analytics, or data

analytics.

6) Current, continuous experience in the state executive branch that includes eighteen months of

full-time work as a Data Analyst 1.

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

Additional Information

Work Authorization/Sponsorship

At this time, we're not considering applicants that need any type of immigration sponsorship (additional work authorization or permanent work authorization) now or in the future to work in the United States.

This includes, but IS NOT LIMITED TO: F1-OPT, F1-CPT, H-1B, TN, L-1, J-1, etc. For additional information around work authorization needs please use the following links.

Nonimmigrant Workers and Green Card for Employment-Based Immigrants