Fairfax, VA 22035
Full-time
Salary: $110,000.00 to $120,000.00 /year


Job Description:

Data process and Web (required)

  • Write and manage SQL scripts (SQL Server, Oracle) for queries and data modeling
  • Develop and maintain Python scripts for data processing automation
  • Maintain and update Power BI Reports and data process from various web sources (Dynamics, ODATA, SharePoint Online, Database, Web API/HTTPS)
  • Document system designs and data models

Analyst(required)

  • Work with management and users to prioritize business and system needs
  • Documentation of user requirements
  • Train users and management on developed solutions and reports
  • Issue resolution/help desk support
  • Participation in team and user meetings

GIS

  • Create/Maintain spatial database objects and publish web services to GIS Enterprise Portal, ArcGIS Server
  • Develop web content (maps and apps) with GIS web services
  • Develop client scripts to run geocoding process

Skills Set:

Data process and Web (required)

  • Database development experience for Data Definition and Manipulation Languages
  • Ability to use SQL client scripts and tools (SQLCMD, BCP, SSIS) for data exchanging process
  • Python development experience with data manipulation modules and Web APIs (RestAPI, HTTPS, Web Authentication, SSL, pyODBC, JSON)
  • Power BI Query (Power Query) and Power BI RestAPI (Power Shell, Python or other client script language)

GIS

  • Understanding of ArcGIS, GIS Enterprise Portal, ArcGIS Online and ArcGIS Server for content management/development and service publication
  • Enterprise Geodatabase and ability to use spatial functions in SQL
  • Python development: Good understanding of Enterprise Geodatabase, Data Management modules, Locator with ArcPy, Using Web API to transfer geometry from geoJson

Go to all jobs