Data Reports Specialist

CITADEL Pacific Ltd

Tamuning (GU)

On-site

USD 65,000 - 90,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

CITADEL Pacific Ltd is seeking a Data & Reports Specialist to develop, maintain, and optimize data integration, reporting, and analytics across multiple teams. You will work with Marketing, Billing, Finance, Enterprise Sales, and IT-MIS to deliver standardized KPIs, revenue insights, and forecasting support.

The role emphasizes data governance, secure reporting, and automation using SQL, Python, and BI tools. Strong collaboration and communication skills are essential.

Qualifications

  • Bachelor's degree or equivalent in a related field.
  • At least two years in data reporting, database development, BI, analytics, ETL, or related field.
  • SQL and reporting experience; practical Access and Python experience; advanced Excel.
  • Preferred: Power BI, SSRS, CostGuard or similar dashboards/ETL tools.

Responsibilities

  • Develop, maintain, and optimize ETL workflows across source systems, the ODS, and reporting platforms.
  • Create SQL queries, stored procedures, and data mappings for reliable extraction and processing.
  • Validate and reconcile data; coordinate issues with IT-MIS, data owners, and vendors.
  • Design and maintain operational reports, dashboards, scorecards, and KPI templates.
  • Support CostGuard reports for billing, customer accounts, and workflows.
  • Prepare revenue monitoring, variance, and trend analyses; support forecasting.
  • Follow data governance, security, and documentation practices; ensure deployment readiness.

Skills

SQL
Python
Excel
Data governance
Business intelligence
Reporting

Education

Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Statistics, Mathematics, Business Analytics, or a related field

Tools

Microsoft Access
Power BI
SQL Server Reporting Services
CostGuard

Job description

Job Summary:

Under the general supervision of the Senior Manager, Product Innovations & Analytics, the Data &Reports Specialist develops, maintains, and improves data integration processes, operationalreporting, dashboards, and analytical solutions. The role extracts, validates, and integratesinformation from source systems into the Operational Data Store (ODS) and approved reportingplatforms to provide accurate, timely, consistent, and secure business information.

Working with Marketing, Billing, Finance and Accounting, Enterprise Sales, TSS, NEAT, CustomerCare, IT-MIS, and other teams, the Specialist supports standardized KPIs, revenue and subscriberanalysis, customer retention reporting, product performance evaluation, forecasting, and reportingautomation.

Essential Duties and Responsibilities:
A. Data Management & Integration

Develop, maintain, monitor, and optimize ETL workflows and scheduled data loads acrosssource systems, the ODS, and approved reporting platforms.

Create and maintain SQL queries, stored procedures, database scripts, and source-to-targetmappings to support reliable extraction and processing.

Validate, cleanse, reconcile, and troubleshoot data to maintain accuracy, completeness,consistency, and timely availability; coordinate source-system issues with IT-MIS, dataowners, and vendors.

B. Reporting, Business Intelligence & Automation

Design, maintain, and enhance recurring and ad hoc operational reports, managementdashboards, scorecards, and 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, reportgeneration, validation, and recurring reporting activities.

Develop and maintain CostGuard custom reports for billing, customer accounts, ticketing,workflows, and related business requirements.

C. Business Performance Analytics

Prepare revenue monitoring, reconciliation, variance, and trend analyses to identify potentialdiscrepancies 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.

D. Governance, Collaboration & Improvement

Follow information security, confidentiality, access, and data governance requirements; testand validate reports, scripts, and data processes before deployment.

Maintain documentation, version control, approved backups, and recovery information forreporting assets, coordinating operational continuity with IT-MIS.

Gather reporting requirements, support new product and system initiatives, explain reports tousers, and resolve cross-department reporting inconsistencies.

Identify improvements in data quality, reporting efficiency, and automation; maintain relevanttechnical and telecommunications knowledge and comply with company policies andassigned related duties.

Minimum Qualification Requirements:
Education:

Bachelor's degree in Computer Science, Information Technology, InformationSystems, Data Analytics, Statistics, Mathematics, Business Analytics, or a related field; or an equivalent combination of education, technical training, and relevant work experience.

Experience:

At least two (2) years of relevant professional experience in data reporting, databasedevelopment, business intelligence, analytics, ETL, or a related technical field. Demonstrated SQLand reporting experience, practical Microsoft Access and Python experience, and advanced Excelreporting skills.

Preferred:

Telecommunications billing or subscriber analytics; CostGuard or comparablesystems; Power BI, SQL Server Reporting Services, or comparable dashboard tools; automated ETLand data reconciliation experience.

Licensure/Certification:

None required. Relevant Power BI, database, Python/data analytics, orMicrosoft Office certifications are preferred.

Special Knowledge, Skills & Abilities:
Knowledge of:

Relational databases, data warehousing, Operational Data Stores (ODS), and ETLprocesses.

SQL, Microsoft Access, Python, Excel, and business intelligence reporting tools.

Data governance, information security, and confidentiality requirements.

Skills in:

Developing reports, dashboards, KPIs, and automated reporting processes.

Data validation, reconciliation, troubleshooting, and technical documentation.

Analyzing operational, financial, customer, and subscriber data.

Ability to:

Interpret data, identify trends and discrepancies, and communicate findings clearly.

Collaborate across departments, prioritize deadlines, and work independently.

Adapt to changing business needs and support continuous improvement

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Reports Specialist
Data Reports Specialist

CITADEL Pacific Ltd. • Tamuning (GU)

On-site
USD 65,000 - 90,000
Data Reports Specialist
Data Reports Specialist

CITADEL • Tamuning (GU)

On-site
USD 68,000 - 98,000
Data & Reporting Analyst
Data & Reporting Analyst

Dev • Louisville (KY)

On-site
USD 55,000 - 75,000
Data Analytics Analyst 4 4PC- 890
Data Analytics Analyst 4 4PC- 890

4P Consulting Inc. • Atlanta (GA)

On-site
USD 75,000 - 95,000
Data Analyst
Data Analyst

Spectraforce • Columbia (SC)

On-site
USD 60,000 - 85,000
Reporting Analyst 2 4P/889
Reporting Analyst 2 4P/889

4P Consulting Inc. • Atlanta (GA)

On-site
USD 75,000 - 110,000
Data Specialist
Data Specialist

Stellar Consulting Solutions, LLC • St. Louis (MO)

On-site
USD 65,000 - 90,000
DATA ANALYST I
DATA ANALYST I

Formosa Plastics Corporation • Livingston (NJ)

On-site
USD 110,000 - 130,000
Business Intelligence Developer
Business Intelligence Developer

Communication Service for the Deaf (CSD) • Austin (TX)

On-site
USD 90,000 - 130,000
Data Analyst
Data Analyst

Easy Recruiter • Lexington (MA)

On-site
USD 70,000 - 90,000