Ascension is seeking an Energy Code Data & Reporting Lead to support Montgomery County Department of Permitting Services’ Energy Code Information Technology, Reporting, and Analysis effort. This role is designed for a senior data professional who can translate complex energy code, building permit, inspection, and compliance data into accurate, usable reports, dashboards, and recommendations that help the County improve data collection, track compliance trends, and support DOE grant reporting.

This position is important because Montgomery County is using energy codes as a key tool to meet its climate goals, including net zero energy and electrification over multiple code cycles. DPS also needs improved systems for collecting, analyzing, and reporting energy code-related data, including compliance paths, energy credits, renewables, permit rejection trends, and Technical Assistance Program comparisons.

The ideal candidate will bring strong data management, Power BI/Power Query, SQL, ETL, and reporting experience, with enough familiarity in building energy codes, construction documentation, permitting, or energy efficiency to understand what the data means—not just how to manipulate it.

Summary of the Contractor Role

The Energy Code Data & Reporting Lead will support data dictionary alignment, data extraction and transformation, data quality validation, dashboard development, trend analysis, and reporting support for energy code compliance data. The role will help DPS collect and manage data from permit applications, inspections, enforcement activities, building drawings, energy model reports, mechanical drawings, and related sources.

The RFP specifically identifies the need to extract, transform, and load data from systems such as Infor and ProjectDox; merge datasets; query SQL databases; validate data; and prepare data for analysis and reporting. It also anticipates that some energy code data may need to be manually collected from permit files and construction documents, while allowing vendors to propose more efficient methods if accuracy is maintained.

This position requires a detail-oriented, organized, self-driven professional who can work in an ambiguous environment, document assumptions, identify data quality issues, reconcile inconsistent inputs, and convert fragmented building permit data into credible reports for internal County use, DOE progress reporting, and public-facing analysis.

Expected Day-to-Day / Task Order Activities

• Lead data dictionary alignment with DPS-defined reporting fields, source systems, and required DOE/public reporting outputs.
• Extract, transform, and load data from County systems, including potential sources such as Infor, ProjectDox, SQL databases, Access, Excel, and Power BI datasets.
• Review permit submissions, energy model reports, mechanical drawings, PDFs, and other construction documentation to manually identify and capture energy code data when automated data is not available.
• Build and maintain Power Query transformations, SQL queries, Excel models, Access datasets, and Power BI datasets to support repeatable reporting.
• Validate source data, transformed data, and final reporting outputs for accuracy, consistency, completeness, and traceability.
• Document data quality issues, source limitations, transformation logic, intermediate files, scripts, and assumptions needed to re-run data workflows.
• Develop dashboards, charts, tables, and visual summaries that explain energy code compliance patterns, compliance paths, renewables, electrification, energy performance, and permit/inspection rejection trends.
• Conduct trend analysis to identify problematic code sections, common rejection reasons, recurring data gaps, and patterns in industry feedback.
• Support inputs to DOE progress reports, final grant reporting, and public-facing reports by compiling accurate data and preparing clear visuals.
• Recommend improvements to DPS data collection tools, forms, workflows, and reporting processes.
• Coordinate with the Project Manager, Energy Code SME, IT specialists, and DPS stakeholders to confirm data definitions, reporting requirements, and quality-control expectations.
• Support accessibility expectations for reports, dashboards, and data documentation where deliverables may be posted or shared publicly.
• Follow County security practices for data access, data handling, and protection of County information systems.