Solution Architect / Program Lead

Insight Global · Harmar, PA, United States

Location
Harmar
Job Type
Full-time
Posted
June 03, 2026

Job Description

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

Ready to Apply?

Submit your application for Solution Architect / Program Lead at Insight Global

Apply Now