Lead Business Systems Analyst - BMP/Environmental Data

Role Type: Core / Full-time early; taper later

Experience: 8+ years; strong environmental/regulatory data experience preferred

Role Purpose

• Convert DEQ's already-collected BMP Warehouse requirements into an implementation-ready, testable, traceable functional baseline. This role is the functional owner for BMP intake, validation, lifecycle, search/reporting, administrative configuration, NEIEN/EPA reporting interactions, and user workflows. The analyst must be able to reason about data rules and regulatory reporting, not just document meetings.

Key Responsibilities

• Validate and refine the existing functional requirements with DEQ SMEs, resolving ambiguities, contradictions, missing decision points, data ownership questions, and exception paths before development.
• Maintain requirement traceability from SOR requirement IDs through functional specifications, design decisions, development stories/tasks, test cases, UAT evidence, and acceptance.
• Own functional definition of upload-template selection, reporting reason, required fields, overwrite/update behavior, staged review/approval, in-place editing, direct UI entry, and API-based intake.
• Document validation rules including required fields, controlled vocabularies, measurement/unit relationships, numeric ranges, chronological checks, BMP-specific cross-field rules, duplicate logic, and MS4-specific requirements.
• Work with the GIS specialist and DEQ SMEs to translate locality/FIPS/HUC12/VAHU6, latitude/longitude, Chesapeake Bay drainage, and implementation qualifier requirements into testable business rules.
• Define functional behavior for code-table administration, VACS/NRCS/Clearinghouse mappings, credit durations, practice lifespans, eligible-practice lists, Tracking ID/Import ID corrections, and export of administrative reference data.
• Clarify NEIEN/CAST/GRTS/GRTS-WPT business processes, annual reporting windows, resubmission behavior, submission caps, nutrient-trading option boundaries, and associated user decisions.
• Define role-based workflows and organization-scoped access for Site Admin, BMP DEQ Admin, BMP External User, Local Admin, and Local Viewer scenarios.
• Coordinate with the integration developer to document business ownership, trigger, payload, error-handling, synchronization, and reconciliation expectations for CEDS/TMDL IP, CGP, OLAP, DCR/VACS, and local-government API access.
• Update/maintain the business glossary and data dictionary with DEQ and the Data Lead.
• Partner with QA to derive UAT scenarios and acceptance criteria directly from requirements and high-risk business rules.
• Prepare user-facing process documentation, training materials, and administrator-training content; support in-person training and UAT facilitation.

Minimum / Required Profile for Sourcing

• 8+ years of business systems analysis experience on data-intensive custom applications.
• Demonstrated experience translating complex business/data rules into functional specifications, decision tables, acceptance criteria, and testable requirements.
• Strong SQL/data literacy and ability to work with data dictionaries, code tables, mappings, XML/API payload concepts, and data-quality rules.
• Experience with workflow-heavy public-sector, environmental, permitting, regulatory, grants, water-quality, or comparable compliance/reporting systems.
• Experience leading requirements workshops, resolving edge cases, and maintaining end-to-end traceability through UAT.
• Strong documentation and facilitation skills with business and technical stakeholders.

Preferred Differentiators

• Experience with EPA Exchange Network/NEIEN, Chesapeake Bay Program, BMP/TMDL/MS4/NPDES/VPDES, GRTS, watershed/HUC data, or similar environmental reporting.
• Experience with GIS-enabled workflows and spatially derived business rules.
• CBAP/CCBA or equivalent business-analysis certification.