Solution Architect / Program Lead

Job Description
Own the architecture, planning, and delivery of the Discoverer‑to‑PBIRS migration. This role will translate complex business reporting needs into a secure, auditable, scalable on‑prem architecture, manage delivery phases and risk, and ensure a clean handoff to internal support teams.

Key Responsibilities
Architecture & Design

Define the target-state architecture, including:

Direct-query operational reporting against Oracle EBS
SQL Server dimensional data warehouse for analytics
Optional data lake tier
Power BI Report Server as the report delivery layer
Security, auditing, and scheduling services

Make and document key architectural decisions:

Import vs DirectQuery vs Composite models
Security model aligned to Oracle EBS responsibilities
Auditing and data retention requirements

Program Leadership

Own the end-to-end delivery plan, breaking the program into phases with:

Entry/exi...