Solution Architect / Program Lead

Own the architecture, planning, and delivery of the DiscoverertoPBIRS migration. This role will translate complex business reporting needs into a secure, auditable, scalable onprem 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/exit criteria
Dependencies
Risks and mitigations

Expected phases include:

Discovery & Inventory
Infrastructure StandUp
Data Architecture & ETL
Report Migration
Security & Audit
Cutover & Discoverer Decommission

Governance & Delivery

Build and maintain the program cost model
Produce budget, timeline, and total cost of ownership estimates
Lead architecture review board sessions
Ensure the solution meets audit, security, and compliance requirements
Hand off architecture artifacts and operational procedures to internal teams

In-Scope Environment

Source System: Oracle E-Business Suite 12.2.12 (Oracle DB 19c)
Modules: GL, AP, AR, Cash Management, Projects (Costing/Billing), Purchasing, Inventory, BOM, WIP, Manufacturing, Quality, EAM, OM, Shipping
Reporting Platform: Power BI Report Server (onprem only)
Data Platform: SQL Server (separate physical or virtual server)

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to View email address on click.appcast.io learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:


Required Skills & Experience

10+ years in enterprise BI / data platform architecture
At least two full-lifecycle Microsoft BI implementations
Proven experience reporting on or integrating with Oracle ERP systems (EBS R12 or Oracle Fusion)
Hands-on Power BI Report Server experience (refresh behavior, licensing, limitations, feature gaps vs Power BI Service)
Strong background designing solutions for highsecurity, regulated environments (finance, utilities, healthcare, defense, critical infrastructure)
Demonstrated ability to:

Build phased delivery plans
Produce accurate cost and effort estimates
Manage risk and dependencies

Excellent communication skills with both executive stakeholders and handson technical teams


Nice to Have Skills & Experience

Experience replacing Oracle Discoverer, OBIEE, Cognos, BusinessObjects, or MicroStrategy with Microsoft BI
Prior ownership of largescale reporting modernization programs in onprem environments


Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.