6385 - Data Specialist

Alakaʻi Services and Poe'hana Group, Inc.; Shiloh (IL); On-site; USD 95,000 - 145,000; Full time

Job summary

Alakaʻi Services and Poe'hana Group, Inc. leads telecommunications data initiatives, focusing on inventory research, data integration, and reporting to support federal transition programs.

The role requires building and maintaining authoritative databases, reconciling high-volume data, and delivering dashboards with Power BI or Tableau for stakeholders.

Qualifications

• Bachelor’s degree in a data-related field required.
• 7+ years in database administration, development, data analysis, or related roles.
• Experience reconciling high-volume records from multiple systems.
• Advanced Excel and relational database skills; knowledge of ETL and data-quality practices.

Responsibilities

• Administer and maintain program databases; protect and store data.
• Design data structures and test changes; document changes.
• Interact with stakeholders to determine data-access requirements and volumes.
• Collect, profile, normalize, reconcile, and validate data from multiple sources.

Skills

Advanced Excel

Relational databases

Data analysis

Education

Bachelor’s degree in Data Analytics or related

Master’s degree preferred

Tools

SQL Server

Oracle

PostgreSQL

Power BI

Tableau

Job description

Lead telecommunications inventory research, data integration, database administration, reconciliation, validation, tracking, and reporting for a potential federal telecommunications transition and support program. Establish and maintain an authoritative transition inventory that supports customer planning, telecommunications ordering, cutovers, disconnects, and program reporting.

Key Responsibilities

• Administer and maintain program databases using appropriate database management systems to organize, protect, and store data.
• Ascertain user requirements; create database structures; and test, coordinate, and document database changes.
• Interact with development personnel, system owners, and end users to determine data-access requirements, transaction rates, volumes, and other information needed to develop and maintain integrated databases.
• Collect, import, profile, normalize, reconcile, and validate data from multiple Government, customer, billing, and telecommunications-provider sources.
• Develop data structures, data dictionaries, required fields, validation rules, status definitions, source-to-target mappings, and change-control procedures.
• Reconcile discrepancies involving service identifiers, agencies, locations, quantities, usage, billed amounts, features, equipment, contacts, and service status.
• Maintain traceability from master records to source data and supporting validation evidence.
• Create and manage discrepancy, exception, duplicate, unmatched-record, and customer-validation queues.
• Coordinate data validation and correction with federal customers, service providers, system owners, and technical personnel.
• Integrate order, installation, cutover, disconnect, and external status information into the transition database.
• Produce recurring, cumulative, customer-level, exception, aging, and management reports and dashboards.
• Implement controls for completeness, validity, accuracy, consistency, uniqueness, timeliness, and traceability.
• Protect controlled and nonpublic information and comply with applicable access, safeguarding, and records-management requirements.

Qualifications

• Bachelor’s degree in Data Analytics, Data Science, Information Systems, Computer Science, Database Management, Business Analytics, Mathematics, Statistics, or a related discipline required.
• Minimum 7 years of database administration, database development, data analysis, data quality, configuration management, or inventory-management experience required.
• Demonstrated experience reconciling high-volume records from multiple systems containing incomplete, inconsistent, or conflicting data.
• Advanced Microsoft Excel and relational database skills.
• Strong analytical, research, documentation, and stakeholder-coordination abilities.
• Experience supporting federal, telecommunications, logistics, asset-management, billing, or enterprise IT datasets preferred.
• Master’s degree preferred.
• Microsoft, Oracle, SQL, Power BI, data-management, or comparable technical certification preferred.
• U.S. citizenship and the ability to work remotely from an authorized location within CONUS are required. Periodic on-site support at Scott Air Force Base, Illinois, may be required for government-furnished equipment support and other mission needs.
• Must be available and prepared to begin work at the anticipated contract start date of November 6, 2026.

Required Systems, Tools, and Framework Experience

• Microsoft Excel, including advanced formulas, lookup functions, pivot tables, data validation, and Power Query
• Microsoft Access, SQL Server, Oracle, PostgreSQL, or comparable relational database platforms
• SQL for data extraction, transformation, reconciliation, validation, and reporting
• Microsoft Power BI, Tableau, or comparable dashboard and visualization tools
• Microsoft Office Suite, Teams, and SharePoint
• Data dictionaries, source-to-target mappings, metadata management, and master-data-management practices
• ETL and data-quality tools or controlled scripting for repeatable data processing
• Configuration management, version control, change logging, and audit-trail practices
• Telecommunications inventory, billing, provisioning, and order-management systems
• Federal records-management, information-safeguarding, and role-based access requirements

Required Specialized Experience

• Establishment and administration of authoritative inventory or master-data repositories.
• Comparison and reconciliation of data from federal systems, vendor portals, spreadsheets, billing files, and customer-maintained sources.
• Familiarity with enterprise telecommunications inventory, billing, ordering, provisioning, or vendor-management platforms.
• Analysis of telecommunications service records, quantities, usage, billing, ownership, features, equipment, and managed-service components.
• Development of matching rules, duplicate detection, exception queues, discrepancy-resolution workflows, and data-quality metrics.
• Coordination of record validation with customers, system owners, service providers, and technical subject-matter experts.
• Integration of order, installation, cutover, discontinue, and operational-status information into an auditable database.
• Production of recurring, cumulative, customer-level, management, and exception reports from high-volume datasets.

Equal Opportunity Employer Statement

We are an Equal Opportunity Employer and provide equal employment opportunity to all applicants and employees in accordance with applicable federal and state laws. All qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity or expression, marital status, ancestry, genetic information, pregnancy status, or any other characteristic protected by law.