Senior Telecom Analyst

ADT•Boca Raton, FL

About The Position

The Senior Telecom Analyst supports the Telecom team across wireless signaling, from product and systems development through provisioning management and service and vendor billing. The role serves as a liaison between the business and vendors, validates invoices against contracted services and rates, and analyzes usage and billing data to identify discrepancies. The analyst uses SQL and Google BigQuery to aggregate usage across carriers and reconcile monthly billing against active signaling records. The position also investigates signaling failures, provisioning delays, and API synchronization errors across internal central-station software, billing engines, and carrier endpoints. It monitors cellular IoT fleets and SIM lifecycle states across multiple carrier platforms, identifies unusual usage and non-communicating devices, and makes mid-cycle tier adjustments to address pooling overages. The role collaborates with Product Management and Hardware Engineering on data-use baselines, firmware-over-the-air impacts, and SIM form factors and profiles. It requires strong wireless and cellular-network knowledge, data-analysis capabilities, familiarity with carrier connectivity management platforms, effective communication, sound judgment, organization, and the ability to work independently and present information to management.

Requirements

High school diploma or GED.
Minimum 4–6 years of experience managing cellular wireless or IoT connectivity at scale.
Hands-on experience with carrier IoT management platforms, such as Cisco IoT Control Center/Jasper, Verizon ThingSpace, or AT&T IoT, alongside central-station software.
Demonstrated understanding of cellular network architecture, including APNs, IP addressing, Cat-M, LTE, roaming profiles, and SIM provisioning states.
Proven ability to build complex SQL and Google BigQuery queries and use advanced Excel modeling, including pivot tables, Power Query, and VLOOKUPs, to reconcile large device-level CDR data.
Knowledge of signaling technologies, particularly wireless signaling.
Working knowledge of cellular network architecture and VPN infrastructure.
Comprehensive understanding of data structures for querying data and producing accurate, relevant reports.
Knowledge of Google Cloud Storage or similar tools for database queries supporting business decisions.
Knowledge and proficiency with carrier connectivity management platforms and technical standards, including eSIM/eUICC, Cat-M1, NB-IoT, private APNs, and static IPs.
Working knowledge of ADT implementations and ability to stay current with IoT industry trends.
Proficiency with Microsoft Office applications, including Excel, Word, Access, PowerPoint, Outlook, and Copilot or other AI applications, and internet tools.
Ability to access and operate vendor and partner web portals and applications.
Excellent communication and listening skills.
Strong cooperative, customer service, and interpersonal skills.
Good decision-making skills; highly organized and detail-oriented.
Self-motivated and able to work independently.
Ability to respond effectively to sensitive inquiries, define problems, collect data, establish facts, and draw valid conclusions.
Ability to use AI applications to analyze large datasets, detect anomalies, verify data, investigate disparities, and validate results.
Ability to exercise discretion and analyze problems, meet deadlines, and produce reports on schedule.
Ability to work effectively with people at all organizational levels and present information to top management.
Ability to apply formulas to calculate amounts such as discounts and percentages and to interpret written, oral, diagrammatic, or schedule-based instructions.
Ability to adapt to workplace changes, delays, unexpected events, and competing demands; concentrate on tasks; and understand the business environment and how the area of control fits within it.
Licensure as required by the applicable Authority Having Jurisdiction (AHJ), such as a Commonwealth of Massachusetts Security Systems Certificate of Clearance.

Nice To Haves

Experience in alarm, telematics, or remote-sensing industries.
MASterMind experience.
Industry certifications.

Responsibilities

Act as a liaison between the business and vendors.
Analyze vendor invoices and validate billed services against contracted rates.
Write SQL queries in Google BigQuery to aggregate usage data across carriers.
Reconcile monthly billing details against active signaling records to identify ghost lines and rate discrepancies.
Investigate signaling failures, provisioning delays, and API synchronization errors between MASterMind, billing engines, and carrier network endpoints.
Monitor cellular IoT fleets across carrier connectivity management platforms and identify unusual data spikes, runaway signaling, and non-communicating devices.
Execute mid-cycle tier adjustments to eliminate pooling overages.
Manage SIM lifecycle transitions across multi-carrier environments to help ensure devices are billed only when deployed in the field.
Collaborate with Product Management and Hardware Engineering to define data-usage baselines, assess FOTA data impacts, and select SIM form factors and profiles.
Perform other duties as assigned.