PMIS Technology Specialist (Datawarehouse & Reporting)

In a world of possibilities, pursue one with endless opportunities. Imagine Next!

When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next, right now. We’ve got what you’re looking for.

Job Description

Parsons is looking for an amazingly talented PMIS Technology Specialist (Datawarehouse & Reporting) to join our team! In this role you will get to contribute expertise in implementation of project management information systems on large programs. At this level, the PMIS Specialist has sufficient training, technical expertise to work mostly independently on assigned projects.

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.
  
  
  

Parsons equally employs representation at all job levels no matter the race, color, religion, sex (including pregnancy), national origin, age, disability or genetic information.

We truly invest and care about our employee’s wellbeing and provide endless growth opportunities as the sky is the limit, so aim for the stars! Imagine next and join the Parsons quest—APPLY TODAY!

Parsons is aware of fraudulent recruitment practices. To learn more about recruitment fraud and how to report it, please refer to https://www.parsons.com/fraudulent-recruitment/.