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 CJLRM3EV1q Apply tot his job