THE OVERALL PURPOSE OF POSITION:  

• Serves as technical team leader in the development of GIS solutions and other reports and analysis across all divisions of the organization. Perform professional level work in GIS database and system management and analysis. Analyze, diagnose, and troubleshoot GIS database application problems. Provides day-to-day management of the overall reporting environment. The results provide ongoing support to Client decisionmakers, the FCC, Congress, and other interested parties.  

SCOPE OF WORK  

• The position’s SCOPE OF WORK include the following:  

• Serve as technical team lead in the development of GIS System, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems  

• Utilize Open Geo suite of software applications with relational databases including PostGres and SQL Server.   

• Install/configure various components of OpenGeo stack of products – GeoServer, OpenLayers, PostGIS, QGIS  

• Complete documentation of datasets and processes.  

• Ability to overlay maps with different layers  

• Coordination of some short- and long-term enterprise GIS projects  

• Provide geospatial support to internal and external teams with data development, data scrubbing and analysis, on-line and hardcopy map creation, setup of ETL processes, training, and setup of field data collection apps.  

• Create and maintain web map applications published via ArcGIS On-Line Query, analyze and prepare statistics on spatial and non-spatial data within relational databases.  

• Prepare and execute workflows and geoprocessing models using Python.  

• Prepare and execute workflows and geoprocessing models using ArcGIS ModelBuilder  

• Prepare and execute queries in spatial and non-spatial databases using SQL.  

• Develop and maintain geospatial datasets including those stored in relational databases.  

• Conduct end user training on GIS system  

QUALIFICATION AND EXPERIENCE:  

• 12+ Years of Knowledge of Relational Databases  

• 7+ Years of Requirements Gathering   

• 10+ Years of SQL Programming  

• 5+ Years of Geo Server   

• 5+ Years of Open Layers  

• 6+ Years of PostGres   

• 6+ Years of Post GIS   

• 5+ Years of QGIS / ArcGIS  

• 7+ Years of ESRI stack  

• 4+ Years of Geo Node  

• 7+ Years of CSS/HTML  

• 7+ Years of Java scripting  

• 5+ Years of Python scripting  

• 5+ Years of Pentaho PDI/ Kettle  

• 4+ Years of ETL using open data tools  

NOTE: In addition, this is the desired experience.  

• POST GIS  

• SQL Server  

• Pentaho PDI / Kettle  

• ArcGIS  

• REST API  

• Web Mapping Services /Web Feature Service  

• Boundless Open Geo Suite  

• Vertica  

• Creating visual displays for data analysis and presentation  

• Prefer experience with State, Federal & local government agencies.  

• Expertise working with Census, ACS data sets.  

SPECIAL SKILLS:  

• Ability to install, configure Boundless Open Geo Stack of products.  

• Ability to create Maps using QGIS and publishing it on GeoServer  

• Ability to translate logical models into physical implementation.   

• Excellent verbal and written communication skills are an absolute must.   

• Ability to work well under pressure and work on multiple tasks simultaneously.   

• Outstanding analytic skills—in particular, an ability to translate an unstructured strategic question into a structured program of research, to disaggregate potential drivers of performance, to explore relationships between multiple pieces of data, and to test and identify the drivers underlying performance measures  

• Outstanding ability to synthesize research results into actionable strategies and recommendations  

• Advanced verbal and written communication skills and the ability to present effectively to small and large groups.  

• Energetic, organized, detail-oriented  

• Consistent ability to meet deadlines in a fast-paced environment  

• Must be strong self-starter able to work independently under limited supervision  

• The ability to build consensus and to work through others in achieving desired results and objectives.   

• Consistent ability to set and deliver against a work plan in a fast-paced environment  

• Ability to foster a cooperative work environment and to freely give and receive feedback  

• Strong interpersonal skills and the ability to work effectively with a wide range of constituencies in a diverse community.   

• Ability to lift 15 – 25 pounds  

• General computer and presentation skills  

• Customer and results oriented