SUMMARY
The Journey Data Warehouse Specialist plays a key role in building and maintaining modern data architectures that support the National Park Service’s (NPS) mission. This position is responsible for developing and managing data integrations, including geospatial and alphanumeric data warehouses and data lakes. By consolidating data from diverse sources and enabling advanced mapping, reporting, and self-service business intelligence (BI) tools, this role directly supports data-driven decision-making and operational efficiency. The specialist works collaboratively with cross-functional teams to design scalable data solutions, implement innovative analytics approaches, and ensure data quality and integrity across complex environments. Success in this role requires strong technical expertise, an analytical mindset, and the ability to translate complex data needs into actionable strategies that support organizational goals.
COMPENSATION & BENEFITS
Salary Range: $100,000 - $118,000
Comprehensive federal benefits package available to full-time employees, including health insurance, paid time off, and retirement plan participation.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES
- Building data integrations such as geospatial and alphanumeric data warehouses and/or data lakes.
- Consolidating and geospatially enabling data, and publishing those data to meet user needs for mapping, reporting, and geospatial analysis or self-service business intelligence (BI) activities.
- Supporting GIS and alphanumeric data integration and presentation, including taking data from various sources (GIS datasets, enterprise systems, external sources) and integrating them.
- Performing data and application analysis, harvesting sources, consolidating, integrating, and publishing data.
- Performing data systems analysis and, in some cases, presenting project plans, tracking project status, and identifying risks.
- Developing a strategy for NPS data integration, including the development and implementation of any needed work plans.
- Leading reviews and helping identify key geospatial and alphanumeric data from source systems (data discovery).
- Coordinating with other project staff and stakeholders on data integration, data quality, and standards development.
- Developing and maintaining enterprise data architecture to support business requirements.
- Assessing different implementation, geospatial mapping, reporting, and visualization tools and making suggestions on best platforms.
- Analyzing data warehouse or business intelligence (BI) activities and identifying required essential resources.
- Designing different data movement processes and conducting quality control tests on data.
- Designing integration architecture, data service or exchange patterns, and conducting source to target mapping.
- Developing data lake, data warehouse, or geospatial data warehouse model and design.
- Modeling data structures and designing data/geospatial services by creating high-level logical and physical data models.
- Developing designs for all metadata relating to various Extract, Transform, and Load (ETL) or Extract/Load/Transform (ELT) processes.
- Developing and maintaining database scripts and tools to support data movement jobs.
- Using ETL, ELT, or other service-based technologies and tools to automate movement of data.
- Evaluating source systems and making recommendations for system enhancements.
- Scrutinizing NPS data infrastructure, identifying gaps, and developing plans to integrate current systems with the desired future data integration layer/model.
- Monitoring processes and developing plans to expedite gathering and accessing all relevant metadata.
- Preparing designs for needed data integration systems and recommending measures to improve performance.
- Developing and implementing geospatial and alphanumeric strategies for user access to data.
- Developing and prototype reports, dashboards, and maps for use by end users.
- Defining metadata standards for the data integration layer.
- Conducting troubleshooting on all data movement processes.
- Integration of geospatial data and database platforms with cloud-based services such as Dataverse and Data Lake.
- Implementation of available Artificial Intelligence (AI) and Machine Learning technologies to business intelligence mining.
- Providing briefings and reports on milestones status, next steps, and risks.
- Coordinating tasks with other NISC team members and stakeholders.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
SKILLS AND QUALIFICATIONS
- Journey level: Possesses and applies expertise on multiple complex work assignments. Assignments may be broad in nature, requiring originality and innovation in determining how to accomplish tasks. Operates with appreciable latitude in developing methodology and presenting solutions to problems. Contributes to deliverables and performance metrics.
- Task planning, project management, and coordination skills to work effectively with other data and project team members and leadership.
- Experience in a variety of data warehousing tools from both the traditional data warehouse and data lake perspective, and from techniques used in the Modern Data Stack and/or other modern approaches to managing spatial data warehouses.
- Experience in data analysis, presentation, or self-service BI approaches to develop proof of concept and prototype reports and maps.
- Strong understanding and ability to plan and design modern databases and data structures, including geospatial.
- Strong analytical and time management skills.
- Experience with computer programming, distributed systems, database design and administration.
- Attention to detail.
- Excellent written and verbal communication skills.
- Self-motivated and able to handle tasks with minimal supervision or questions.
- Ability to deliver a high level of customer service.
- Experience in integrating geospatial and alphanumeric data, creating geospatial maps, and utilizing business intelligence tools for data visualization and reporting.
EDUCATION & EXPERIENCE
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical field is required.
- Minimum of 3 years of experience working with data warehouses, data lakes, or business intelligence solutions in enterprise or large-scale environments.
- Hands-on experience designing and implementing ETL/ELT processes, data pipelines, and data integration workflows.
- Experience developing and maintaining data models (logical and physical) and supporting data architecture initiatives.
- Practical experience with data visualization, reporting, and dashboard development to support self-service BI and analytical needs.
- Familiarity with cloud-based data platforms and services (e.g., Microsoft Azure, AWS, Google Cloud) is preferred.
SUPERVISORY RESPONSIBILITY
- No supervision is required for this position.
- As a Senior level personnel, this position may provide oversight of others.
WORK ENVIRONMENT
- Work can be performed at the contractor's facility or at the National Park Service (NPS) facility at Building 50, Denver Federal Center, Lakewood, CO 80225.
- Remote work is allowed with COR or task inspector approval.
Our Values:
Native American Owned & Proud | Accountable | Team Focused | Innovative | Visionary | Excellence
PHYSICAL DEMANDS
- Frequently required to sit, talk, and use hands to operate equipment.
- Occasionally required to lift objects up to 25 pounds.
- Requires close vision, distance vision, and the ability to focus for extended periods.
AAP/EEO Statement
Ho-Chunk, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. However, preference may be extended to persons of Indian descent in accordance with applicable laws.
