Parsons
PMISDatawarehouse&ReportingSpecialist
Neural analysis suggests this role is
optimal for Mid candidates.
“PMIS Datawarehouse & Reporting Specialist at Parsons. Skills: Oracle Autonomous Datawarehouse, Oracle Integration Cloud (OIC), SQL/PLSQL, Power BI, Data integration, Reporting. 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”
Industry & Context.
Troubleshoot and resolve availability or performance issues
What They're Looking For.
Must Have
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, 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
Nice to Have
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, troubleshooting skills and familiarity with Oracle Knowledge Management resources
What You'll Do.
Set up and maintain Oracle Autonomous Datawarehouse to integrate data from PMIS systems (Unifier
P6 EPPM) and client platforms (ERP
Use Oracle Integration Cloud (OIC) to establish and manage data connectors into the Datawarehouse for Power BI reporting
Write SQL/PLSQL queries to extract
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
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 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
How You'll Work.
Team & Collaboration
Coordinate with Oracle Support to resolve issues; Oversee integration specialists; Deliver training and knowledge transfer sessions to client IT teams
Communication Scope
Excellent written and verbal communication skills in English; Deliver training and knowledge transfer sessions
Process & Methodology
Experience implementing project management information systems on large programs, Experience in project/construction management environments
Full Job Description
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 valuing people, embracing agility, and fostering growth, we cultivate an innovative culture that empowers you to achieve your full potential. Unleash your talent and redefine what’s possible. _**Job Description:**_ Job Posting Parsons is looking for an amazingly talented **PMIS 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 know
Applying for this PMIS Datawarehouse & Reporting Specialist role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Workday
- Workday has a multi-step form — save your progress after every section.
- "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
- Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
- Job requisition numbers are useful when following up with HR by email.
ANONYMOUS · UNFILTERED
What do employees actually say about Parsons?
Real rants from real employees. Read before you apply.