Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
CITADEL in Guam is seeking a Data & Reports Specialist to develop, maintain, and optimize data integration processes, ETL workflows, and reporting solutions. The role collaborates with Marketing, Billing, Finance, Sales, IT, and others to support KPI definitions, revenue analytics, and reporting automation.
The specialist will use SQL, Python, Excel, and Access to validate data, generate recurring reports, and support data governance. A 2+ year background in data reporting and BI is preferred.
Job Summary:
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.
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 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, data owners, and vendors.
Design, maintain, and enhance recurring and ad hoc operational reports, management dashboards, 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, report generation, validation, and recurring reporting activities.
Develop and maintain CostGuard custom reports for billing, customer accounts, ticketing, workflows, and related business 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 (2) 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, and advanced Excel reporting skills.
Telecommunications billing or subscriber analytics; CostGuard or comparable systems; Power BI, SQL Server Reporting Services, or comparable dashboard tools; automated ETL and data reconciliation experience.
None required. Relevant Power BI, database, Python/data analytics, or Microsoft Office certifications are preferred.