Ascension is seeking a Permitting Systems Integration Specialist with hands-on experience supporting permitting, plan review, document management, and local government workflow systems, preferably including Infor, Avolve, and ProjectDox. This position will support Montgomery County Department of Permitting Services’ effort to improve how energy code-related permit data is collected, stored, exported, analyzed, migrated, and reported. The County’s RFP specifically identifies the need to perform system integration with Infor or Avolve and conduct ETL from existing systems such as Infor and ProjectDox, including dataset preparation, SQL querying, validation, and reporting support.

This role is important because DPS is working to improve its systems for collecting, analyzing, and reporting energy code-related data across current and future code cycles. The work supports the County’s ability to understand how building projects comply with energy codes, including compliance paths, energy credits, renewables, and related reporting needs.

Summary of Contractor Role

The Permitting Systems Integration Specialist will support the technical connection between DPS permitting platforms, document repositories, databases, reporting tools, and future energy code data solutions. The ideal candidate is a detail-oriented systems integrator and data professional who understands how permitting workflows, plan review systems, document uploads, inspection records, and database structures connect to downstream reporting needs.

The candidate should be comfortable working in an environment where data may exist across multiple systems, PDFs, permit records, database tables, and manually maintained sources. The role requires the ability to map workflows, identify required data fields, support ETL logic, validate data quality, troubleshoot system access issues, document integration requirements, and support migration planning if DPS replaces or expands its current IT system. The RFP also requires developed solutions to be internet-accessible, user-friendly, accessible, capable of supporting approximately 30 concurrent users, exportable for reporting, and supported by cybersecurity controls.

Day-to-Day / Anticipated Activities

• Analyze permitting workflows, system interfaces, data structures, and business rules across Infor, Avolve, ProjectDox, and County database environments.

• Map permit submission, plan review, document management, inspection, and energy code data flows to identify where required reporting data is created, stored, modified, or missing.

• Support requirements analysis, design, development, testing, integration, and implementation of energy code data solutions.

• Extract, transform, and load data from Infor, ProjectDox, Avolve, SQL databases, spreadsheets, or other County-approved data sources.

• Query SQL databases and prepare data extracts for analysis, dashboarding, reporting, and migration planning.

• Develop or support scripts, Power Query logic, data transformation routines, and repeatable workflows used to aggregate energy code-related permit data.

• Validate data quality, identify missing or inconsistent records, document data issues, and recommend corrective actions.

• Support data migration planning if a developed solution is later replaced by or incorporated into the current DPS IT system.

• Coordinate with the Project Manager, Data & Reporting Lead, Energy Code SME, and County technical staff to confirm data definitions, field mappings, access needs, and integration assumptions.

• Document interface requirements, source-to-target mappings, transformation logic, test results, and technical procedures.

• Maintain awareness of County security, remote access, database access, and data protection requirements.

• Recommend improvements to DPS IT systems, data collection tools, forms, and reporting workflows when system or data limitations are identified.