Data Reporting Analyst

Data Reporting Analyst 5 Months Any of client location Oakland, San Ramon, Fairfield, or Sacramento, CA (Hybrid - average 1-2 times / WEEK) LOCAL CANDIDATES ONLY 5% TRAVEL: Local travel only TOP THINGS Power BI & ServiceNow Reporting Expertise: Strong hands‑on experience building dashboards, reports, and performance analytics across Power BI and ServiceNow ITSM modules ITSM Metrics & KPI Development: Deep understanding of ITSM processes and ability to define, measure, and translate meaningful metrics into actionable insights Stakeholder Engagement & Governance Reporting: Ability to partner with process owners, leadership, and governance team to design and deliver clear, executive‑ready reporting Overview We are seeking a senior‑level ITSM Reporting & Dashboard Analyst / Developer with expertise in Power BI and ServiceNow reporting to support IT Service Management (ITSM) operations, governance, and the transition from BMC Remedy to ServiceNow ITSM/ITOM. This role will design, develop, and guide the reporting and dashboarding solutions across ITSM processes and governance, including but not limited to Incident, Change, Problem, Work Orders, CMDB. In addition to dashboard development, this role will help define the overall reporting approach, including evaluating when to leverage Power BI versus native ServiceNow reporting and Performance Analytics. The ideal candidate will work closely with ITSM process owners and leadership to define reporting requirements, establish a standardized metrics and KPI library, and determine the appropriate reporting platform strategy. This includes supporting near‑term reporting in Power BI (e.g., leveraging Remedy data to define and prototype metrics and dashboards) while preparing for a transition to ServiceNow‑based reporting and dashboards in alignment with platform capabilities. This individual will translate operational data into actionable insights and provide recommendations that support decision‑making, governance review boards, compliance, and continuous improvement, while ensuring reporting solutions are scalable, accurate, and aligned to long‑term ITSM strategy. Key Responsibilities Reporting & Dashboard Development POWER BI Design and develop end-to-end Power BI solutions, including data ingestion, transformation (Power Query/M), and semantic data modeling (star schema) Build reusable datasets and models, and develop advanced DAX measures (e.g., SLA %, MTTR, aging, time intelligence, rolling trends) Create interactive dashboards with drill‑downs, filters, and role‑based views for operational and executive audiences Integrate data from multiple sources (e.g., ServiceNow, SharePoint, Excel, or others) and optimize performance through efficient modeling and query design SERVICENOW Develop ServiceNow reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB) Configure Performance Analytics (e.g., indicators, breakdowns, scorecards, widgets) to track trends and process performance Build reports using advanced filters and logic to reflect lifecycle behavior (e.g., assignment, state, SLA, task relationships) Leverage platform capabilities (e.g., database views, table relationships) and validate report accuracy against record‑level data ITSM Metrics & Data Modeling Design data models and metrics that reflect how ITSM work actually flows, evolves, and connects across incidents, tasks, SLAs, and related records Define and implement KPIs aligned to process performance (e.g., MTTR, MTTA, SLA attainment /breaches, backlog/ aging, reassignment counts, change success, problem lifecycle) Engineer metrics to handle real‑world conditions (e.g., reopens, SLA pauses/resets, assignment transfers, parent/child relationships) to ensure accuracy Establish and maintain a standardized metrics and KPI library (definitions, calculation logic, data sources, ownership, usage) for consistency and governance Validate and optimize metrics by enforcing correct aggregations, denominators, and filter context, and support flexible slicing (e.g., group, priority, service, time) ServiceNow Reporting Development Develop reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB, and more) Build reporting views that surface key operational insights (e.g., aging/backlog, SLA performance, assignment group performance, reassignment trends, change success/failure, governance intake) Apply advanced filtering and logic to reflect lifecycle behavior (e.g., assignment, state transitions, SLA conditions, task relationships) Validate accuracy against ServiceNow source data and platform logic to ensure trusted outputs Power BI Reporting Development Develop advanced Power BI reports using DAX, Power Query/M, and structured data models Integrate data from multiple sources (Remedy, ServiceNow, SharePoint, Excel, others) into consistent reporting models Create interactive dashboards with drill‑down and filtering capabilities, dynamic views Optimize performance, usability, and scalability Governance & Executive Reporting Develop reporting for governance forums (ITSM Governance Review Board, CAB, operational and leadership reviews) Deliver insights that highlight performance and risk (aging tickets, SLA breaches, gaps, trends) Structure outputs to support both executive summaries and operational drill‑downs Support governance intake and lifecycle reporting (demand tracking, approvals, status) Data Analysis & Quality Analyze data to identify trends, anomalies, and improvement opportunities across ITSM Identify and resolve data quality issues (missing data, inconsistencies, stale records) Document metric definitions, calculations, and report logic in the standardized metrics and KPI library to ensure consistency and traceability Partner with process teams to improve reporting data quality Stakeholder Engagement Gather and refine reporting requirements from process owners and leadership Translate needs into clear reporting solutions and dashboards Communicate insights to technical and non‑technical stakeholders Provide data‑driven recommendations based on trends, gaps, patterns Qualifications Bachelor's degree in IT, Data Analytics, Business, or related field (or equivalent experience) 7+ years in reporting, analytics, business intelligence, or ITSM performance reporting 5+ years of Power BI development (DAX, Power Query, data modeling) 5+ years with ServiceNow reporting across ITSM/ITOM/FSM Hands‑on experience with ServiceNow Performance Analytics (indicators, breakdowns, scorecards, trending) Strong knowledge of ITSM processes and lifecycle (Incident, Change, Problem, Work Orders, Requests, SLA) Desired ServiceNow Certified Implementation Specialist - Platform Analytics (CIS-PA) or equivalent performance analytics experience ITIL Foundation certification MS Power BI certification (or equivalent expertise) Experience supporting executive or governance reporting Key Skills Power BI (DAX, Power Query, data modeling, dashboards) ServiceNow reporting and dashboards KPI and metrics development Data analysis and data validation SQL and data integration Dashboard design and data storytelling Success Criteria Delivery of accurate, trusted ITSM dashboards and reports Improved visibility into ITSM performance and aging work Adoption of reporting by leadership and stakeholders Clear, actionable insights supporting governance decisions Improved data quality and reporting consistency #J-18808-Ljbffr