{"schemaVersion":"jobsearcher.job.v1","id":"703b16deeb9d31a74974e428","url":"https://jobsearcher.com/jobs/703b16deeb9d31a74974e428","canonicalUrl":"https://jobsearcher.com/jobs/703b16deeb9d31a74974e428","title":"Data Reporting Analyst","description":"Data Reporting Analyst5 MonthsAny of client location Oakland, San Ramon, Fairfield, or Sacramento, CA (Hybrid - average 1-2 times / WEEK)**LOCAL CANDIDATES ONLY**5% TRAVEL: Local travel onlyTOP THINGS:\r\nPower BI & ServiceNow Reporting Expertise: Strong hands-on experience building dashboards, reports, and performance analytics across Power BI and ServiceNow ITSM modules\r\nITSM Metrics & KPI Development: Deep understanding of ITSM processes and ability to define, measure, and translate meaningful metrics into actionable insights\r\nStakeholder Engagement & Governance Reporting: Ability to partner with process owners, leadership, and governance team to design and deliver clear, executive-ready reportingOverviewWe 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.\r\nThis 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.\r\nThe 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.\r\nThis 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 ResponsibilitiesReporting & Dashboard DevelopmentPOWER BIDesign and develop end-to-end Power BI solutions, including data ingestion, transformation (Power Query/M), and semantic data modeling (star schema)\r\nBuild reusable datasets and models, and develop advanced DAX measures (e.g., SLA %, MTTR, aging, time intelligence, rolling trends)\r\nCreate interactive dashboards with drill-downs, filters, and role-based views for operational and executive audiences\r\nIntegrate data from multiple sources (e.g., ServiceNow, SharePoint, Excel, or others) and optimize performance through efficient modeling and query designSERVICENOWDevelop ServiceNow reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB)\r\nConfigure Performance Analytics (e.g., indicators, breakdowns, scorecards, widgets) to track trends and process performance\r\nBuild reports using advanced filters and logic to reflect lifecycle behavior (e.g., assignment, state, SLA, task relationships)\r\nLeverage platform capabilities (e.g., database views, table relationships) and validate report accuracy against record-level dataITSM Metrics & Data ModelingDesign data models and metrics that reflect how ITSM work actually flows, evolves, and connects across incidents, tasks, SLAs, and related records\r\nDefine and implement KPIs aligned to process performance (e.g., MTTR, MTTA, SLA attainment /breaches, backlog/ aging, reassignment counts, change success, problem lifecycle)\r\nEngineer metrics to handle real-world conditions (e.g., reopens, SLA pauses/resets, assignment transfers, parent/child relationships) to ensure accuracy\r\nEstablish and maintain a standardized metrics and KPI library (definitions, calculation logic, data sources, ownership, usage) for consistency and governance\r\nValidate and optimize metrics by enforcing correct aggregations, denominators, and filter context, and support flexible slicing (e.g., group, priority, service, time)ServiceNow Reporting DevelopmentDevelop reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB, and more)\r\nBuild reporting views that surface key operational insights (e.g., aging/backlog, SLA performance, assignment group performance, reassignment trends, change success/failure, governance intake)\r\nApply advanced filtering and logic to reflect lifecycle behavior (e.g., assignment, state transitions, SLA conditions, task relationships)\r\nValidate accuracy against ServiceNow source data and platform logic to ensure trusted outputsPower BI Reporting DevelopmentDevelop advanced Power BI reports using DAX, Power Query/M, and structured data models\r\nIntegrate data from multiple sources (Remedy, ServiceNow, SharePoint, Excel, others) into consistent reporting models\r\nCreate interactive dashboards with drill-down and filtering capabilities, dynamic views\r\nOptimize performance, usability, and scalabilityGovernance & Executive ReportingDevelop reporting for governance forums (ITSM Governance Review Board, CAB, operational and leadership reviews)\r\nDeliver insights that highlight performance and risk (aging tickets, SLA breaches, gaps, trends)\r\nStructure outputs to support both executive summaries and operational drill-downs\r\nSupport governance intake and lifecycle reporting (demand tracking, approvals, status)Data Analysis & QualityAnalyze data to identify trends, anomalies, and improvement opportunities across ITSM\r\nIdentify and resolve data quality issues (missing data, inconsistencies, stale records)\r\nDocument metric definitions, calculations, and report logic in the standardized metrics and KPI library to ensure consistency and traceability\r\nPartner with process teams to improve reporting data qualityStakeholder EngagementGather and refine reporting requirements from process owners and leadership\r\nTranslate needs into clear reporting solutions and dashboards\r\nCommunicate insights to technical and non-technical stakeholders\r\nProvide data-driven recommendations based on trends, gaps, patternsQualificationsBachelor's degree in IT, Data Analytics, Business, or related field (or equivalent experience)\r\n7+ years in reporting, analytics, business intelligence, or ITSM performance reporting\r\n5+ years of Power BI development (DAX, Power Query, data modeling)\r\n5+ years with ServiceNow reporting across ITSM/ITOM/FSM\r\nHands-on experience with ServiceNow Performance Analytics (indicators, breakdowns, scorecards, trending)\r\nStrong knowledge of ITSM processes and lifecycle (Incident, Change, Problem, Work Orders, Requests, SLA)DesiredServiceNow Certified Implementation Specialist - Platform Analytics (CIS-PA) or equivalent performance analytics experience\r\nITIL Foundation certification\r\nMS Power BI certification (or equivalent expertise)\r\nExperience supporting executive or governance reportingKey SkillsPower BI (DAX, Power Query, data modeling, dashboards)\r\nServiceNow reporting and dashboards\r\nKPI and metrics development\r\nData analysis and data validation\r\nSQL and data integration\r\nDashboard design and data storytellingSuccess CriteriaDelivery of accurate, trusted ITSM dashboards and reports\r\nImproved visibility into ITSM performance and aging work\r\nAdoption of reporting by leadership and stakeholders\r\nClear, actionable insights supporting governance decisions\r\nImproved data quality and reporting consistency","company":"Spectraforce Technologies","rawCompany":"spectraforce technologies","city":"Oakland","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-07-20T01:10:27.279Z","occupations":[{"code":"15-2051.01","title":"Business Intelligence Analysts","slug":"business-intelligence-analysts"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1211.00","title":"Computer Systems Analysts","slug":"computer-systems-analysts"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541611","title":"Administrative Management and General Management Consulting Services","slug":"administrative-management-and-general-management-consulting-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Reporting Analyst","description":"Data Reporting Analyst5 MonthsAny of client location Oakland, San Ramon, Fairfield, or Sacramento, CA (Hybrid - average 1-2 times / WEEK)**LOCAL CANDIDATES ONLY**5% TRAVEL: Local travel onlyTOP THINGS:\r\nPower BI & ServiceNow Reporting Expertise: Strong hands-on experience building dashboards, reports, and performance analytics across Power BI and ServiceNow ITSM modules\r\nITSM Metrics & KPI Development: Deep understanding of ITSM processes and ability to define, measure, and translate meaningful metrics into actionable insights\r\nStakeholder Engagement & Governance Reporting: Ability to partner with process owners, leadership, and governance team to design and deliver clear, executive-ready reportingOverviewWe 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.\r\nThis 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.\r\nThe 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.\r\nThis 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 ResponsibilitiesReporting & Dashboard DevelopmentPOWER BIDesign and develop end-to-end Power BI solutions, including data ingestion, transformation (Power Query/M), and semantic data modeling (star schema)\r\nBuild reusable datasets and models, and develop advanced DAX measures (e.g., SLA %, MTTR, aging, time intelligence, rolling trends)\r\nCreate interactive dashboards with drill-downs, filters, and role-based views for operational and executive audiences\r\nIntegrate data from multiple sources (e.g., ServiceNow, SharePoint, Excel, or others) and optimize performance through efficient modeling and query designSERVICENOWDevelop ServiceNow reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB)\r\nConfigure Performance Analytics (e.g., indicators, breakdowns, scorecards, widgets) to track trends and process performance\r\nBuild reports using advanced filters and logic to reflect lifecycle behavior (e.g., assignment, state, SLA, task relationships)\r\nLeverage platform capabilities (e.g., database views, table relationships) and validate report accuracy against record-level dataITSM Metrics & Data ModelingDesign data models and metrics that reflect how ITSM work actually flows, evolves, and connects across incidents, tasks, SLAs, and related records\r\nDefine and implement KPIs aligned to process performance (e.g., MTTR, MTTA, SLA attainment /breaches, backlog/ aging, reassignment counts, change success, problem lifecycle)\r\nEngineer metrics to handle real-world conditions (e.g., reopens, SLA pauses/resets, assignment transfers, parent/child relationships) to ensure accuracy\r\nEstablish and maintain a standardized metrics and KPI library (definitions, calculation logic, data sources, ownership, usage) for consistency and governance\r\nValidate and optimize metrics by enforcing correct aggregations, denominators, and filter context, and support flexible slicing (e.g., group, priority, service, time)ServiceNow Reporting DevelopmentDevelop reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB, and more)\r\nBuild reporting views that surface key operational insights (e.g., aging/backlog, SLA performance, assignment group performance, reassignment trends, change success/failure, governance intake)\r\nApply advanced filtering and logic to reflect lifecycle behavior (e.g., assignment, state transitions, SLA conditions, task relationships)\r\nValidate accuracy against ServiceNow source data and platform logic to ensure trusted outputsPower BI Reporting DevelopmentDevelop advanced Power BI reports using DAX, Power Query/M, and structured data models\r\nIntegrate data from multiple sources (Remedy, ServiceNow, SharePoint, Excel, others) into consistent reporting models\r\nCreate interactive dashboards with drill-down and filtering capabilities, dynamic views\r\nOptimize performance, usability, and scalabilityGovernance & Executive ReportingDevelop reporting for governance forums (ITSM Governance Review Board, CAB, operational and leadership reviews)\r\nDeliver insights that highlight performance and risk (aging tickets, SLA breaches, gaps, trends)\r\nStructure outputs to support both executive summaries and operational drill-downs\r\nSupport governance intake and lifecycle reporting (demand tracking, approvals, status)Data Analysis & QualityAnalyze data to identify trends, anomalies, and improvement opportunities across ITSM\r\nIdentify and resolve data quality issues (missing data, inconsistencies, stale records)\r\nDocument metric definitions, calculations, and report logic in the standardized metrics and KPI library to ensure consistency and traceability\r\nPartner with process teams to improve reporting data qualityStakeholder EngagementGather and refine reporting requirements from process owners and leadership\r\nTranslate needs into clear reporting solutions and dashboards\r\nCommunicate insights to technical and non-technical stakeholders\r\nProvide data-driven recommendations based on trends, gaps, patternsQualificationsBachelor's degree in IT, Data Analytics, Business, or related field (or equivalent experience)\r\n7+ years in reporting, analytics, business intelligence, or ITSM performance reporting\r\n5+ years of Power BI development (DAX, Power Query, data modeling)\r\n5+ years with ServiceNow reporting across ITSM/ITOM/FSM\r\nHands-on experience with ServiceNow Performance Analytics (indicators, breakdowns, scorecards, trending)\r\nStrong knowledge of ITSM processes and lifecycle (Incident, Change, Problem, Work Orders, Requests, SLA)DesiredServiceNow Certified Implementation Specialist - Platform Analytics (CIS-PA) or equivalent performance analytics experience\r\nITIL Foundation certification\r\nMS Power BI certification (or equivalent expertise)\r\nExperience supporting executive or governance reportingKey SkillsPower BI (DAX, Power Query, data modeling, dashboards)\r\nServiceNow reporting and dashboards\r\nKPI and metrics development\r\nData analysis and data validation\r\nSQL and data integration\r\nDashboard design and data storytellingSuccess CriteriaDelivery of accurate, trusted ITSM dashboards and reports\r\nImproved visibility into ITSM performance and aging work\r\nAdoption of reporting by leadership and stakeholders\r\nClear, actionable insights supporting governance decisions\r\nImproved data quality and reporting consistency","datePosted":"2026-07-20T01:10:27.279Z","dateModified":"2026-07-20T01:10:27.279Z","hiringOrganization":{"@type":"Organization","name":"Spectraforce Technologies","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Oakland","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"703b16deeb9d31a74974e428"},"url":"https://jobsearcher.com/jobs/703b16deeb9d31a74974e428"}}