Remote Oracle Bi Publisher Jobs in Ohio (NOW HIRING)

About Us

Pyrovio Consulting is a dynamic consulting firm specializing in providing innovative solutions to utilities and large-scale capital investment clients. We deliver tailored strategies that enhance operational efficiency and drive project success.

Summary

We are seeking an Oracle Project Portfolio Management (OPPM) Consultant to design, implement, configure, and optimize Oracle Project Portfolio Management solutions for utility and capital investment clients, ensuring alignment with best practices and business objectives. This role combines functional and technical expertise to deliver end-to-end solutions, drive user adoption, and support portfolio governance in a client-facing environment.

THIS ROLE REQUIRES DEEP, HANDS-ON OPPM EXPERIENCE.

Key Responsibilities

Solution Design & Implementation

Gather business requirements and design portfolio structures.

Map client processes to OPPM capabilities, identify gaps, and recommend improvements.

Configure functional workflows, portfolio hierarchies, and dashboards.

Customize OPPM settings and manage security roles.

System Administration & Technical Delivery

Install, configure, and maintain OPPM environments.

Manage upgrades, patches, and performance tuning.

Troubleshoot technical issues and provide solutions.

Develop and maintain APIs and middleware solutions.

Ensure data consistency across integrated systems.

Integration & Data Management

Integrate OPPM with other enterprise systems (Oracle P6, Unifier, ERP, EcoSys, Sage).

Plan and execute data migration from legacy systems to OPPM.

Validate and reconcile migrated data; develop ETL scripts and manage data integrity.

Reporting & Analytics

Develop dashboards, KPIs, and reports using OPPM and BI tools.

Optimize reporting for performance and usability.

Support ad-hoc reporting needs.

Training, Adoption & Support

Develop training materials and conduct workshops.

Support user adoption and change management initiatives.

Provide ongoing user support and documentation.

Governance, Compliance & Risk Management

Ensure portfolio governance and audit configurations.

Maintain compliance with internal and external standards.

Monitor security and risk management processes.

Qualifications

Education & Experience

Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.

10+ years in portfolio management and Oracle Primavera suite.

5+ years in Oracle OPPM functional configuration.

5+ years in Oracle technical administration (WebLogic, SQL).

3+ years in business process analysis.

Technical Skills

Expertise in Oracle OPPM architecture and governance.

Experience with OPPM configuration tools, XML, scripting.

Strong experience with Oracle Integration Cloud, API development, and data mapping.

Proficiency in SQL, ETL tools, and data validation.

Experience in large-scale data migration projects.

Oracle BI Publisher, SQL, and data visualization tools.

Functional Skills

Strong understanding of portfolio management processes.

Functional and technical OPPM knowledge, integration experience.

Experience in portfolio analytics.

Communication & Leadership

Excellent verbal and written communication skills.

Strong leadership and client engagement skills.

Collaborative, team-oriented approach.

Strong analytical and documentation skills.

Training & Change Management

Instructional design and training delivery experience.

Experience in change management and user adoption initiatives.

Compliance & Risk

Knowledge of audit processes and Oracle security.

Experience in compliance frameworks.

Risk management expertise.

Certifications (Preferred)

Primavera P6 Enterprise Project Portfolio Management Certified Professional

Project Management Institute (PMI) PMP or PgMP certification

Primavera Unifier Cloud Service Certified Implementation Specialist

Primavera Unifier Administration Professional

Benefits

Competitive salary

Comprehensive benefits package

Professional development opportunities

Collaborative and supportive work environment

MUST BE A U.S. CITIZEN OR GREEN CARD HOLDER

MUST RESIDE IN THE U.S.

Pyrovio is an equal opportunity employer and complies with all applicable federal, state, and local laws regarding nondiscrimination. We provide equal employment opportunities to all employees and applicants and prohibit discrimination and harassment of any type based on race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.