Data Reports Specialist

Citadel•Tamuning, GU

About The Position

Under the general supervision of the Senior Manager, Product Innovations & Analytics, the Data & Reports Specialist develops, maintains, and improves data integration processes, operational reporting, dashboards, and analytical solutions. The role extracts, validates, and integrates information from source systems into the Operational Data Store (ODS) and approved reporting platforms to provide accurate, timely, consistent, and secure business information. Working with Marketing, Billing, Finance and Accounting, Enterprise Sales, TSS, NEAT, Customer Care, IT-MIS, and other teams, the Specialist supports standardized KPIs, revenue and subscriber analysis, customer retention reporting, product performance evaluation, forecasting, and reporting automation.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Statistics, Mathematics, Business Analytics, or a related field; or an equivalent combination of education, technical training, and relevant work experience.
  • At least two years of relevant professional experience in data reporting, database development, business intelligence, analytics, ETL, or a related technical field.
  • Demonstrated SQL and reporting experience.
  • Practical Microsoft Access and Python experience.
  • Advanced Excel reporting skills.
  • Knowledge of relational databases, data warehousing, Operational Data Stores (ODS), and ETL processes.
  • Knowledge of SQL, Microsoft Access, Python, Excel, and business intelligence reporting tools.
  • Knowledge of data governance, information security, and confidentiality requirements.
  • Skills in developing reports, dashboards, KPIs, and automated reporting processes.
  • Skills in data validation, reconciliation, troubleshooting, and technical documentation.
  • Skills in analyzing operational, financial, customer, and subscriber data.
  • Ability to interpret data, identify trends and discrepancies, and communicate findings clearly.
  • Ability to collaborate across departments, prioritize deadlines, and work independently.
  • Ability to adapt to changing business needs and support continuous improvement.

Nice To Haves

  • Experience with telecommunications billing or subscriber analytics.
  • Experience with CostGuard or comparable systems.
  • Experience with Power BI, SQL Server Reporting Services, or comparable dashboard tools.
  • Experience with automated ETL and data reconciliation.
  • Relevant Power BI, database, Python/data analytics, or Microsoft Office certifications.

Responsibilities

  • Develop, maintain, monitor, and optimize ETL workflows and scheduled data loads across source systems, the ODS, and approved reporting platforms.
  • Create and maintain SQL queries, stored procedures, database scripts, and source-to-target mappings for reliable data extraction and processing.
  • Validate, cleanse, reconcile, and troubleshoot data to maintain accuracy, completeness, consistency, and timely availability; coordinate source-system issues with IT-MIS, data owners, and vendors.
  • Design, maintain, and enhance recurring and ad hoc operational reports, management dashboards, scorecards, standardized KPI definitions, and templates.
  • Develop and support Microsoft Access databases and reporting solutions, including queries, forms, reports, macros, and appropriate VBA automation.
  • Use SQL, Python, Excel, and other approved tools to automate data processing, report generation, validation, and recurring reporting activities.
  • Develop and maintain CostGuard custom reports for billing, customer accounts, ticketing, workflows, and related business requirements.
  • Prepare revenue monitoring, reconciliation, variance, and trend analyses to identify potential discrepancies or revenue leakage and support forecasting.
  • Analyze subscriber activations, additions, disconnections, migrations, upgrades, downgrades, churn, and retention trends.
  • Evaluate product and promotional performance, customer adoption, and relevant KPIs; provide analytical findings for business planning, budgeting, and management decisions.
  • Follow information security, confidentiality, access, and data governance requirements; test and validate reports, scripts, and data processes before deployment.
  • Maintain documentation, version control, approved backups, and recovery information for reporting assets, coordinating operational continuity with IT-MIS.
  • Gather reporting requirements, support new product and system initiatives, explain reports to users, and resolve cross-department reporting inconsistencies.
  • Identify improvements in data quality, reporting efficiency, and automation; maintain relevant technical and telecommunications knowledge and comply with company policies and assigned related duties.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service