ITSM Reporting/Dashboard Analyst

For over 17 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies.

For additional information or to view all of our job opportunities, please visit our website https://trilyonservices.com/careers

Job Title: ITSM Reporting/Dashboard Analyst

Location: Oakland, CA/, San Ramon, CA/, Fairfield, CA or Sacramento, CA (1-2 times/Week)

Duration: 6 Months (High Potential for Extension)

**LOCAL CANDIDATES ONLY**

The role is Hybrid - Expect to be onsite at any of the Client’s location areas in Oakland, San Ramon, Fairfield, or Sacramento on average 1-2 times / WEEK

o No mileage or travel expenses will be reimbursed

o 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

1. Reporting & Dashboard Development

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

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

4. ITSM Metrics & Data Modeling

o Design data models and metrics that reflect how ITSM work actually flows, evolves, and connects across incidents, tasks, SLAs, and related records

o Define and implement KPIs aligned to process performance (e.g., MTTR, MTTA, SLA attainment /breaches, backlog/ aging, reassignment counts, change success, problem lifecycle)

o Engineer metrics to handle real-world conditions (e.g., reopens, SLA pauses/resets, assignment transfers, parent/child relationships) to ensure accuracy

o Establish and maintain a standardized metrics and KPI library (definitions, calculation logic, data sources, ownership, usage) for consistency and governance

o Validate and optimize metrics by enforcing correct aggregations, denominators, and filter context, and support flexible slicing (e.g., group, priority, service, time)

5. ServiceNow Reporting Development

o Develop reports and dashboards across ITSM modules (e.g., incident, change, problem, task, request, CMDB, and more)

o Build reporting views that surface key operational insights (e.g., aging/backlog, SLA performance, assignment group performance, reassignment trends, change success/failure, governance intake)

o Apply advanced filtering and logic to reflect lifecycle behavior (e.g., assignment, state transitions, SLA conditions, task relationships)

o Validate accuracy against ServiceNow source data and platform logic to ensure trusted outputs

6. Power BI Reporting Development

o Develop advanced Power BI reports using DAX, Power Query/M, and structured data models

o Integrate data from multiple sources (Remedy, ServiceNow, SharePoint, Excel, others) into consistent reporting models

o Create interactive dashboards with drill-down and filtering capabilities, dynamic views

o Optimize performance, usability, and scalability

7. Governance & Executive Reporting

o Develop reporting for governance forums (ITSM Governance Review Board, CAB, operational and leadership reviews)

o Deliver insights that highlight performance and risk (aging tickets, SLA breaches, gaps, trends)

o Structure outputs to support both executive summaries and operational drill-downs

o Support governance intake and lifecycle reporting (demand tracking, approvals, status)

8. Data Analysis & Quality

o Analyze data to identify trends, anomalies, and improvement opportunities across ITSM

o Identify and resolve data quality issues (missing data, inconsistencies, stale records)

o Document metric definitions, calculations, and report logic in the standardized metrics and KPI library to ensure consistency and traceability

o Partner with process teams to improve reporting data quality

9. Stakeholder Engagement

o Gather and refine reporting requirements from process owners and leadership

o Translate needs into clear reporting solutions and dashboards

o Communicate insights to technical and non-technical stakeholders

o Provide data-driven recommendations based on trends, gaps, patterns

Qualifications

o Bachelor’s degree in IT, Data Analytics, Business, or related field (or equivalent experience)

o 7 years in reporting, analytics, business intelligence, or ITSM performance reporting

o 5 years of Power BI development (DAX, Power Query, data modeling)

o 5 years with ServiceNow reporting across ITSM/ITOM/FSM

o Hands-on experience with ServiceNow Performance Analytics (indicators, breakdowns, scorecards, trending)

o 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

Why Join Us?

• Trilyon, Inc., offers a comprehensive benefits package.

• Opportunities for growth and professional development.

• Collaborative and inclusive company culture

Equal Employment Opportunity (EEO) Statement:

Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.

Regards

Inderjeet Nishad

Direct: (669) 315-4455

E: inder@trilyonservices.com