Ascension is seeking an Energy Code Data Solutions Developer to support Montgomery County’s Department of Permitting Services in improving how energy code information is collected, stored, accessed, exported, secured, and used for reporting. This role is important because Montgomery County is working to strengthen its building energy code implementation, improve energy code-related data collection, and support federal grant reporting tied to new energy codes and process improvements. The RFP states that DPS needs contractor support to help fulfill DOE grant objectives related to reporting on project compliance, improving processes, data collection methods, policies, and guidance materials.

The ideal candidate will be a hands-on developer who can translate business and data requirements into small-scale web/data intake tools, workflow tools, dashboards, accessible forms, export functions, and secure user interfaces. This position requires someone who can work comfortably across requirements analysis, solution design, development, testing, data preparation, cybersecurity-aligned controls, accessibility, and ongoing support.

Summary of the Contractor Role

The Energy Code Data Solutions Developer will design, develop, test, maintain, and enhance data solutions that support the collection, management, export, and reporting of building energy code data. The RFP specifically identifies the need for systems that can collect, store, and export energy code data; be internet accessible; include user-friendly interfaces; meet accessibility requirements; support approximately 30 concurrent users; export data for report generation; and implement cybersecurity.

The candidate should bring strong technical judgment, attention to detail, and the ability to work in an environment where requirements may evolve by task order. The role will support tools and processes that help DPS reduce manual work, improve data quality, support reporting, and prepare for possible future migration to the County’s existing IT systems. The RFP also references possible system integration with Infor or Avolve and ETL/data work involving systems such as Infor and ProjectDox.

The successful candidate should be self-driven, organized, quality-focused, and able to communicate clearly with project managers, data analysts, energy code SMEs, and client stakeholders. The person should be comfortable documenting assumptions, identifying data quality issues, supporting user acceptance testing, and maintaining technical documentation needed to rerun transformations, support sustainment, and transfer knowledge.

Anticipated Activities and Responsibilities

The Energy Code Data Solutions Developer will be expected to:

• Design web-based and/or low-code data intake tools to capture energy code information from permit-related workflows.
• Develop user-friendly interfaces, forms, validation rules, and export features that support data collection and reporting.
• Build small-scale workflow tools, dashboards, and reporting interfaces using approved technologies.
• Translate business requirements into functional requirements, user stories, wireframes, data models, test cases, and acceptance criteria.
• Configure data structures that allow users to collect, store, query, validate, and export energy code data.
• Develop ETL or data transformation processes to extract, merge, clean, validate, and prepare datasets for analysis.
• Query SQL databases and support data integration with existing County or permitting-related systems, where authorized.
• Support potential integration or data exchange with systems such as Infor, Avolve, ProjectDox, Microsoft Power Platform, SharePoint, Access, Excel, Power BI, or similar platforms.
• Create accessible user interfaces and documents consistent with Section 508, ADA, web accessibility, keyboard navigability, alt-text, and accessible PDF/Word requirements.
• Implement role-based access, data protection, logging, change control, and other reasonable security practices aligned with County data protection expectations.
• Maintain and support developed solutions, troubleshoot defects, resolve user issues, and document corrective actions.
• Prepare source files, scripts, configuration notes, data dictionaries, transformation documentation, and user/admin guides.
• Conduct unit testing, integration testing, accessibility checks, data validation, and user acceptance testing support.
• Document data quality issues, defects, risks, and recommended corrective actions for project leadership.
• Support migration planning if a developed solution is later replaced by or integrated into the County’s current DPS IT system.
• Participate in kickoff meetings, annual program meetings, task order planning sessions, technical reviews, and client status meetings as requested.
• Coordinate with the Project Manager, Energy Code SME, Data/Reporting Lead, and client stakeholders to ensure the tool supports reporting, analysis, and grant-related needs.