PMIS Technology Specialist (Datawarehouse & Reporting)

We harness the power of innovation so that you can change the world and help our customers solve their most complex challenges

Eastern Region
R171152
Project Controls
Additional posting locations:

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/.

COMPETITIVE BENEFIT OFFERINGS

Financial Wellness

We care about your financial wellbeing. Parsons offers competitive pay and retirement plans to help you build wealth for the future while giving you the flexibility to diversify your investments.

Work Life Harmony

Balance in life is important and time away from the office is imperative to allow you to refresh and focus your attention on the things that matter to you. Parsons supports your time away by providing paid time off and paid flexible holidays.

Career Development

We are committed to fostering the personal and professional growth of our employees. Develop and advance yourself though our comprehensive training, educational and mentorship programs.

Veteran Support

We provide Industry leading benefits to support veterans and active-duty members to provide security for you and your family by offering robust leave and benefits; including paid active-duty military leave and paid time off when transitioning back to civilian life.

Mind & Body

At Parsons we inspire healthier habits, heathier minds, and a healthier you through our wellness program. Participate in our weekly Meditation Mondays and Wellness Wednesdays. Wellness, at Parsons, is more than just your annual checkup.

Health

Health is not a one size fits all. At Parsons, we offer a robust Employee Assistance Program as well as comprehensive medical, dental and vision plans through large, national carriers with the choice of regional PPO, HDHP, or HMO networks.

Want to learn more about the benefits eligible for the Parsons’ location you are interested in? Click below to find out more!
group of people sitting in bleachers in a stadium

Talent Community Heading here

Join our Talent Community and imagine next with us!

Favorite Jobs
You've saved some roles!