Job Description & Details
This role sits at the intersection of IT project management and data governance within an ITS PMO, meaning you will spend your days wrangling chaotic portfolio data and turning it into something executives can actually make decisions on. If you enjoy building robust pipelines and dashboards rather than just writing ad-hoc reports, this gig gives you real ownership over the reporting ecosystem.
What You'll Actually Be Doing
You'll spend your days acting as the gatekeeper of data integrity across a suite of tools like ServiceNow, Jira, and Smartsheet. Your core mission is to hunt down duplicate records, fix data discrepancies, and automate the manual plumbing using the Microsoft Power Platform so leadership gets clean, real-time visibility into project portfolios without constant firefighting.
The Core Tech Stack
You need deep, hands-on fluency in Power BI, ServiceNow (specifically PPM modules), and Smartsheet, paired with a solid grasp of API integrations and connectors. Because you'll be building automated workflows and data models, advanced Excel skills and a strong foundation in data governance principles are non-negotiable.
Interview Expectations
Expect to be grilled on your experience building data governance frameworks from scratch and handling messy, inconsistent inputs from multiple enterprise systems. The hiring manager is going to ask you how you troubleshoot an integration failure between ServiceNow and Power BI, and they want to hear a structured approach to data profiling, validation, and root-cause analysis rather than just brute-force patching.
Application Advice
Skip the generic analytics fluff and focus heavily on tools like Power BI, ServiceNow PPM, and Power Platform in your resume. Make sure to explicitly mention how you have designed system integrations and automated recurring reporting processes, as these specific keywords are what the ATS and the hiring manager will use to filter out candidates who only know how to build basic spreadsheets.