CMDB Dashboard Developer

Ampcus, Inc; Coppell (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Ampcus Inc. is seeking a CMDB Dashboard Developer to design, develop, and maintain CMDB dashboards, KPI scorecards, and executive reports in Coppell, TX or Costa Mesa, CA.

The role emphasizes hands-on work with BMC Helix CMDB/Remedy ITSM, SQL, and data-quality analytics to drive CMDB governance and reporting maturity.

Qualifications

• 3+ years CMDB/ITSM reporting experience.
• Strong SQL and data quality analysis.
• Experience with dashboards and KPI scorecards.
• Familiar with CMDB governance and data certification.
• Knowledge of ITIL SACM processes.

Responsibilities

• Gather reporting requirements from CMDB, Asset Management, IT Operations, and Service Management stakeholders.
• Design, develop, and troubleshoot CMDB dashboards and KPI scorecards.
• Develop executive-level reporting to demonstrate CMDB maturity and business value.
• Document dashboard designs, data sources, KPI definitions, and reporting standards.

Skills

SQL

Data analysis

Data modeling

ETL concepts

KPI reporting

Tools

Power BI

Tableau

BMC Helix Dashboards

Remedy ITSM

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: CMDB Dashboard Developer

Location(s): Coppell, TX or Costa Mesa, CA

Role Overview

The BMC Helix CMDB Reporting Analyst will be responsible for designing, developing, and maintaining CMDB dashboards, KPI scorecards, executive reports, and data-quality analytics. The role requires strong hands-on experience with BMC Helix CMDB, Remedy ITSM, SQL, reporting, and CMDB governance.

Platform Expertise

• 3+ years of hands-on experience with BMC Helix CMDB, Remedy ITSM, or related BMC Helix modules.
• Strong understanding of CMDB architecture, Configuration Items (CIs), class hierarchy, attributes, and relationships.
• Experience with BMC Helix Dashboards, Smart Reporting, Helix Data Manager, or equivalent reporting technologies.
• Knowledge of ITIL Service Asset & Configuration Management (SACM) processes.

Dashboard & Reporting Skills

• Design and develop interactive dashboards, scorecards, KPIs, and executive reports.
• Create drill-down reporting and trend analysis capabilities.
• Develop automated reporting and scheduled distribution of dashboards.

Data & Analytics Skills

• Strong SQL and data analysis capabilities.
• Experience with data modeling, ETL concepts, and integration reporting.
• Analyze large CMDB datasets and identify data-quality issues, including:
  • Duplicate CIs
  • Orphaned CIs
  • Missing attributes
  • Relationship inconsistencies

Technical Competencies

• Experience working with APIs, integrations, and external data sources.
• Knowledge of CMDB governance, reconciliation, discovery, and data certification processes.
• Understanding of service mapping and CI relationship structures.

Key Responsibilities

• Gather reporting requirements from CMDB, Asset Management, IT Operations, and Service Management stakeholders.
• Design, develop, and troubleshoot CMDB dashboards and KPI scorecards.
• Develop executive-level reporting to demonstrate CMDB maturity and business value.
• Document dashboard designs, data sources, KPI definitions, and reporting standards.

Preferred Qualifications

• BMC Helix or Remedy certification.
• ITIL Foundation certification.
• Experience with Power BI, Tableau, or enterprise analytics platforms.
• Knowledge of cloud infrastructure, service mapping, and discovery tools.

Success Criteria

• Accurate and trusted CMDB reporting.
• Improved visibility into CMDB health and data quality.
• Executive dashboards that support operational and business decision-making.
• Measurable improvement in CMDB governance, compliance, and adoption.

Work Hours

• 08:00 AM - 05:00 PM, Monday-Friday (CST or PST based on location).

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.