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