CADD-GIS Administrator - Hybrid, OH

Overview

Interviews will be in Teams. No onsite requirement for remote contractors, though Columbus based applicants may be asked to come into the office 1-day per week.

CADD/GIS Administrator 2 - Geographic Analysis Support

MCD is seeking a resource to provide geographic analysis support. Candidates for this role should have 5 to 7 years of Geographic Information System (GIS) Analysis experience.

• Support and work closely with the Project team to provide GIS analysis capabilities.
• ArcGIS programming support: LISA cluster, outlier analysis, catchment area analysis, and programming in Model Builder, Python, and SAS.
• Provide training for analysts to perform basic mapping functions and improve system performance.
• Meet with business SMEs to define geospatial analysis needs.
• Work with DGA analysts to integrate ArcGIS geospatial shape files with Tableau.
• Create specialized geospatial files and maps for census tract and behavioral health capacity work.
• Collaborate with clinical analytics to advance in-depth geospatial analysis.
• Calculate time and distance for SPBM and Managed Care programs and verify accuracy.
• Utilize provided queries or data sources to integrate ArcGIS shape files with new dashboards as assigned.
• Review test geospatial files with team members to identify additional development needs.
• Complete quality assurance checks to validate correct map displays and provide technical recommendations.
• Coordinate with access request and IT staff as needed.

• 6+ years in data analysis and related tools (e.g., Excel, Python, R).
• 4+ years with identifying data anomalies.
• 6+ years data visualization (e.g., ArcGIS).
• 6+ years with ArcGIS mapping development including advanced mechanics.
• Ability to document business needs, develop method and quality control documentation, and track key decisions/actions.
• Ability to establish priorities and follow through on projects, with attention to detail and minimal supervision.
• Ability to accept feedback and modify project plans accordingly.
• Data analytics experience and use of large relational databases.
• Proficient use of Network Analyst tool within ArcGIS to calculate correct time and route distance.
• Python skillset within ArcGIS environment, especially for automating spatial analysis tasks.
• Excellent communication skills to convey information clearly and succinctly (e.g., STAR method).

• ArcGIS teaching experience.
• Healthcare data experience including geospatial analysis with census tract/block data within ArcGIS.

• Advanced SQL language experience.
• Experience with Big Data platform tools such as Hadoop, Hue, or Impala.
• Ability to stay informed about current best practices and new developments in data visualization and geospatial analysis.
• Excellent written and oral communication skills with both technical and business SMEs.
• Ability to discern critical from minor problems and propose innovative solutions.
• Demonstrates effective leadership, analytical, and problem-solving skills.
• Ability to support the training and development of team members’ technical skills.