Senior Data Warehouse Specialist

Remote
Full Time
NPS
Mid Level

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


Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Human Check*