Start searching
Back to Jobs
Technology

Data Analyst MDM Reporting & Compliance

HTC Global ServicesTroy, MI🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationTroy, MI, United States
SQLMicrosoft ExcelPower BIITIL

Job description

Job Title: Data Reporting Analyst SQL, Excel & Power BI

Position Overview

This role offers an opportunity to work across enterprise data reporting, inventory management, and compliance operations. The position focuses on maintaining accurate device, user, and mobile-number inventory records while ensuring data consistency across multiple enterprise platforms.

The ideal candidate will bring strong SQL, Advanced Microsoft Excel, and Power BI skills, along with experience in data reconciliation, validation, operational reporting, and KPI/SLA dashboard development.

What You'll Do / Key Responsibilities

  • Maintain accurate device, user, and mobile-number inventory records.
  • Reconcile data across Intune, carrier systems, asset records, and Smarsh.
  • Develop operational dashboards, compliance reports, and inventory reports.
  • Identify data mismatches, missing records, and potential capture gaps.
  • Support authorized audit, legal hold, search, and export workflows.
  • Prepare KPI/SLA reports and management dashboards.
  • Document reporting procedures and participate in incumbent knowledge transfer (KT).

Required Qualifications

  • Advanced Microsoft Excel and SQL skills.
  • Experience with Power BI or equivalent enterprise reporting tools.
  • Strong understanding of data reconciliation, validation, and quality analysis.
  • Experience in inventory and operational reporting.
  • Knowledge of data extraction, transformation, and reporting.
  • Experience with KPI/SLA reporting and exception analysis.

Preferred Qualifications

  • Experience with Microsoft Intune device inventory reporting.
  • Exposure to Smarsh reporting and communication capture reconciliation.
  • Knowledge of mobile carrier systems and telephone-number inventory.
  • Experience with device-user-mobile-number mapping.
  • Exposure to compliance and audit reporting.
  • Knowledge of Power Query and Microsoft Graph.
  • Financial services compliance exposure.
  • Microsoft Power BI Data Analyst Associate (PL-300) certification.
  • Familiarity with Smarsh reporting and archiving concepts.

Technical Skills / Certifications

  • SQL
  • Microsoft Excel
  • Power Query
  • Microsoft Power BI
  • Microsoft Power BI Data Analyst Associate (PL-300) Preferred
  • Microsoft Graph reporting Optional
  • Smarsh reporting/archiving concepts Preferred
  • ITIL Foundation Optional

What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.

#Hiring #DataAnalyst #SQL #PowerBI #AdvancedExcel #DataReporting #DataAnalytics #PowerQuery #DataQuality #MicrosoftIntune #ComplianceReporting #ITJobs

Similar jobs

Apply