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 ta...