🇺🇸 USAJobs.work

America's Job Portal

← Back to USA Jobs

Solution Architect / Program Lead

Company

Insight Global

Location

Harmar, PA

Posted

June 03, 2026

Position Overview

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?

Join thousands of Americans building their careers

Apply Now