Data Architect - Senior JP921

This position will play a key role in enhancing EPAs Digital Regulatory Assurance System. The position is in a high performing team, working in a fast-paced, agile environment.

A. Reducing duplication in EPEA and WA Monitoring Report Templates

Identify overlapping parameters, metrics, and calculations across monitoring and reporting templates across programs and regulatory regimes.

Define and maintain canonical data elements (e.g., facility, authorization, activity, parameter, time, location) to support consistent interpretation and reuse.

Rationalize template designs to reduce redundancy and prepare them for ingestion into standardized data structures.

B. Designing Streamlined Data Structures

Translate manual, upload-oriented reporting templates into analytics-ready data structures, including:

Object/fact tables (e.g., sample observations, measurements, monitoring events)

Dimension tables (e.g., facility, source, ...