Senior Data Warehouse Specialist

Contingent Job Posting - Senior Data Warehouse Specialist

Client: National Park Service (NPS)
Hiring Company: Diligent Consulting Inc.
Location: Lakewood, CO (Hybrid Eligible)
Expected Period of Performance: September 2025 - September 2029
Clearance: Must be able to obtain Public Trust (NACI)
Employment Type: W-2

This position is contingent upon award.
About the Program:

This role supports the National Park Service's National Information Services Center (NISC), which oversees NPS-wide enterprise GIS and alphanumeric data systems. The center serves a wide range of internal and public users across park regions and programs. This project enhances data management capabilities to support conservation, operational readiness, and digital modernization.
Join a mission-driven team enabling smarter data decisions across America's most iconic public lands.

Diligent Consulting Inc. is seeking a Senior Data Warehouse Specialist to support the National Park Service (NPS) by leading efforts to design, integrate, and modernize enterprise data solutions that combine geospatial and alphanumeric data. This is a contingent opportunity pending contract award.
Your Role Within the Company:

As a Senior Data Warehouse Specialist, you will:

• Lead strategy development and technical direction for NPS data integration and warehousing efforts.
• Perform data discovery and quality assessments across enterprise datasets.
• Design integration architecture, geospatially enabled data models, and scalable ETL/ELT pipelines.
• Develop and maintain data warehouse and data lake environments supporting both internal and public-facing systems.
• Prototype visualizations and dashboards (maps, reports, BI tools) that demonstrate value to end-users.
• Support the selection and implementation of reporting and visualization platforms (e.g., Power BI, Tableau, ArcGIS).
• Where applicable, integrate AI/ML capabilities into business intelligence workflows.

Top Qualifications:

• Minimum 5 years' experience in:
  
  • Building and maintaining geospatial and alphanumeric data warehouses or data lakes.
  • Developing visualizations, maps, dashboards, or reports for operational and analytical purposes.
  • Designing enterprise data architecture, including logical and physical data modeling.
• Strong knowledge of:
  
  • Data integration strategies and tools (geospatial and non-spatial).
  • Traditional and modern data warehousing stacks.
  • Self-service BI platforms (Power BI, ArcGIS Dashboards, Tableau).
• Demonstrated ability to:
  
  • Prototype solutions for stakeholder validation.
  • Consolidate data from diverse internal and external sources.
  • Enable decision support through smart data architecture and visualization tools.

Education & Clearance Requirements:

• Bachelor's degree in Computer Science, Data Science, GIS, or related field preferred.
• Must be a U.S. Citizen
• Must be eligible for Public Trust (NACI)
• NAC/NACI required for access to government systems and facilities