PMIS Datawarehouse & Reporting Specialist
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Integrate data using Oracle Autonomous Datawarehouse and OIC, develop Power BI dashboards, and manage reporting solutions for project management.
Key Skills for This Role
Full Job Posting
What You'Ll Be Doing
- Set up and maintain Oracle Autonomous Datawarehouse to integrate data from PMIS systems (Unifier, P6 EPPM) and client platforms (ERP, specialist tools).
- Use Oracle Integration Cloud (OIC) to establish and manage data connectors into the Datawarehouse for Power BI reporting.
- Write SQL/PLSQL queries to extract, transform, and load data into the reporting data model.
- Troubleshoot and resolve availability or performance issues with Oracle Datawarehouse and OIC in coordination with Oracle Support.
- Develop automated Power BI dashboards and paginated reports, using DAX and advanced visuals, to meet program reporting needs.
- Gather reporting requirements from stakeholders and translate them into data models and dashboard solutions.
- Manage access, workspaces, and publishing of Power BI reports for stakeholders.
- Oversee integration specialists when custom APIs or connectors are required beyond Oracle s out-of-the-box solutions; support testing with tools like POSTMAN/SOAPUI.
- Prepare and maintain functional/technical documentation and implementation records for data integration and reporting solutions.
- Deliver training and knowledge transfer sessions to client IT teams on Datawarehouse, OIC, and reporting tools.
What Required Skills You Ll Bring
- Bachelor s degree in Computer Science, IT, or related engineering discipline.
- 5 7 years of experience implementing Datawarehouse solutions with Oracle Unifier and P6 EPPM datasets.
- Hands-on experience with Oracle Autonomous Datawarehouse, OIC, SQL, and PLSQL.
- Proven expertise in building client-ready dashboards and reports in Microsoft Power BI, including DAX and paginated reports.
- Strong understanding of data integration, including managing REST API-based connectors.
- Experience in project/construction management environments (client, consultant, or contractor side) delivering reporting solutions.
- Excellent written and verbal communication skills in English.
What Desired Skills You Ll Bring
- Experience building API-based data connectors using Java, .NET, or similar languages.
- Previous client-facing or consulting experience in IT services for the construction industry.
- Strong troubleshooting skills and familiarity with Oracle Knowledge Management resources.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Parsons Corporation
Document Controller
Abu Dhabi, UAE
In a world of possibilities, pursue one with endless opportunities. Imagine Next! At Parsons, you can imagine a career where you thrive, work with exceptional people, and be yourself. Guided by our leadership vision of v
Site Engineer (Saudi National)
Riyadh, KSA
Parsons seeks a Site Engineer to supervise construction activities, conduct inspections, and ensure compliance with drawings and specifications. The role requires a Bachelor's in Civil Engineering and 4+ years of constru
Construction Director - PMO
Riyadh, KSA
Parsons is seeking a Construction Director to serve as a senior PMO leader responsible for program-wide construction integration, assurance, governance, and performance management across multiple zones and work packages.
Underground Structures Expert
Abu Dhabi, UAE
Parsons seeks an Underground Structures Expert for a major rail project in UAE. The role involves leading design review and construction oversight for tunnels, cut-and-cover sections, shafts, and underground boxes. Candi
Risk Manager
Riyadh, KSA
Parsons is seeking a Risk Manager to lead the development and implementation of risk management frameworks for major infrastructure projects, including airport airfield development. The role involves facilitating risk wo
BIM Coordinator - Landscape
Dubai, UAE
Parsons Corporation is looking for a BIM Coordinator – Landscape to support landscape design teams by coordinating BIM processes and ensuring project deliverables align with client requirements and industry standards in
Document Controller
Dubai, UAE
Parsons Corporation is looking for a Document Controller to join their team in Dubai. The role involves establishing and maintaining filing systems, processing contractor submittals and RFIs, and providing administrative
Quantity Surveyor
Dubai, UAE
Parsons Corporation seeks a Quantity Surveyor to perform estimating activities for large infrastructure projects in Dubai. The role involves post-contract QS functions including interim payments, variations, claims, and
Document Controller
Abu Dhabi, UAE
Site Engineer (Saudi National)
Riyadh, KSA
Construction Director - PMO
Riyadh, KSA
Underground Structures Expert
Abu Dhabi, UAE
Risk Manager
Riyadh, KSA
BIM Coordinator - Landscape
Dubai, UAE
Document Controller
Dubai, UAE
Quantity Surveyor
Dubai, UAE