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 2029Clearance: Must be able to obtain Public Trust (NACI)Employment Type: W-2This 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
