Remote Etl Tester Jobs in Michigan (NOW HIRING)

MUST BE U.S CITIZEN OR HOLD GREEN CARD STATUS
MUST RESIDE IN THE U.S.
About Us
Pyrovio Consulting is a dynamic consulting firm with offices in Ann Arbor, Michigan and Akron, Ohio, specializing in providing innovative solutions to utilities and large-scale capital investment clients. We pride ourselves on our commitment to excellence and our ability to deliver tailored strategies that enhance operational efficiency and drive project success.
Summary
We are seeking an Oracle Primavera Cloud (OPC) Consultant to design, implement, configure, and optimize Oracle Primavera Cloud solutions for utility and capital investment clients, combining deep technical expertise with client-facing advisory skills. The role focuses on analysis, system integration, customization, configuration and ongoing support.
THIS ROLE REQUIRES DEEP, HANDS-ON OPC EXPERIENCE.
Key Responsibilities
Business Analysis & Solution Design
• Gather and analyze business requirements from utility and capital investment clients.
• Map client workflows to OPC capabilities, identify gaps, and recommend process improvements.
• Design, configure, and implement OPC solutions, including Schedule, Cost, and Risk modules.
System Implementation & Integration
• Install, configure, and maintain OPC environments.
• Manage upgrades and patches.
• Integrate OPC with other enterprise systems (Oracle P6, Unifier, ERP, EcoSys, Sage).
• Plan and execute data migration from legacy systems to OPC.
Customization & Reporting
• Customize OPC dashboards, KPIs, security roles, and workflows to meet client needs.
• Develop dashboards, KPIs, and reports using OPC and business intelligence tools.
• Analyze data and generate reports to support decision-making and project performance evaluation.
Documentation & Training
• Prepare technical and functional documentation, including user guides and specifications.
• Develop training materials, conduct workshops, and support end-user adoption.
• Lead and facilitate functional workshops to gather requirements and support implementation.
Support & Governance
• Provide technical support, troubleshoot system issues, and optimize performance.
• Ensure portfolio governance, audit system configurations, and maintain compliance with Oracle standards.
• Stay updated with the latest OPC features and enhancements to improve system utilization.
Client Engagement & Delivery
• Collaborate with stakeholders to optimize project lifecycle management and operational efficiency.
• Define service offerings, oversee implementations, and manage client relationships.
• Combine functional and technical expertise for end-to-end solution delivery in a client-facing capacity.
Qualifications
Education
• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
Technical Expertise
• Deep expertise in Oracle Primavera Cloud (OPC) and Primavera suite, with a strong portfolio of successful implementations.
• Proficiency in Oracle architecture, SQL, WebLogic, and OPC technical configuration.
• Hands-on experience with OPC configuration tools and scripting.
• Integration experience with Oracle Integration Cloud, API development, and middleware.
• Familiarity with ETL tools, SQL, and data validation.
• Advanced skills in Oracle BI Publisher, SQL, and data visualization.
Functional & Industry Knowledge
• Proven experience as an Oracle Primavera Cloud technical and functional consultant.
• Strong knowledge of portfolio and project management processes, especially within the utility industry.
• Experience in process modeling, change management, and risk management.
• Familiarity with utility industry practices and standards (preferred).
Training, Documentation & Security
• Instructional design experience and ability to develop effective training materials.
• Understanding of audit processes and Oracle security standards.
Professional Skills
• Excellent verbal and written communication skills.
• Strong problem-solving abilities and collaborative team-oriented approach.
• Leadership experience and client engagement skills.
Preferred Certifications
• Primavera Unifier Cloud Service Certified Implementation Specialist
• Primavera Unifier Administration Professional
• Primavera P6 Enterprise Project Portfolio Management Certified Professional
• Project Management Institute (PMI) PMP or PgMP certification
Benefits
• Competitive salary
• Comprehensive benefits package
• Professional development opportunities
• Collaborative and supportive work environment
MUST BE U.S CITIZEN OR HOLD GREEN CARD STATUS
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.