GIS Database Analyst

All times are in Central Daylight Time.

 

Job ID 

2017-7990

 

Posted Date 

3/22/2017

 

Job City 

Indianapolis

 

Job State 

Indiana

More information about this job:

Overview:

 

Knowledge Services,  established in 1994 and headquartered in Indianapolis IN, is a certified woman-owned (WBE) professional services organization with over 1500 employees located in offices throughout North America.  Founded by Julie Bielawski, CEO, Guidesoft, Inc. DBA Knowledge Services is an industry leader in Managed Service Programs (MSP), Employer of Record / Payrolling Services, National Recruitment, and Staffing Services.  We provide outstanding services to major organizations in various industries, including; IT, Healthcare, Entertainment, Media, Federal and State Governments, Public Utilities, Telecom, Manufacturing and more.

 

As such, Knowledge Services is committed to providing opportunities for growth – in our company, in each team member and in our relationships.  We believe titles do not define a person, but provide a framework to each person’s endless potential.  Our focus on improving our team, product and processes drive us every day.  We are guided by our four Pillars that set the foundation of who we are and how we conduct business:  Knowledge, Integrity, Innovation, and Service. 

 

 

Responsibilities:

This position will be performing analysis on various database sources to include: access, excel, GIS, and our client’s Traffic Count Database System (TCDS).  Updates will be made to TCDS and GIS systems based on findings.  This position will also have responsibility for assisting with the preparation of Turning Movement Forecasts which requires compiling historic data from multiple sources and analyzing data using Excel. It is hoped that the person would be able to develop scripts or other programmatic tools to streamline the preparation of forecasts. This person will assist in the annual preparation of data for submittal to Highway Performance Monitoring System (HPMS), including development of Annual Factors, updating of default traffic volumes, and preparation of HPMS reports. This person should have a solid working knowledge of data analysis through various sources and a basic understanding of ESRI ArcGIS analysis methodologies. The candidate will also have basic knowledge of creating macros in Office products with VBA and a basic knowledge of Python programming.

 

Description of Duties:

• Data analysis and comparisons form various database types (40% of the time)
• Turning Movement Forecasts (20% of the time, higher initially until backlog cleared)
• Creation or Enhancement of Turning Movement Forecast tools (10%)
• Assist with Development of Annual Factors and HPMS submission (10%)
• Updates to proprietary data system (MS2) (10% of the time)
• GIS, spatial data comparisons and analysis (10% of the time)

 

Qualifications:

Skillset Requested:

• Excel (Advanced) – 3 years – Good Working Knowledge
• Access (Advanced) 3 years - Good Working Knowledge
• VBA & Python scripting 1 year – Basic Programming Knowledge

ArcGIS (Basic) – 1 year – Basic GIS Knowledge