Business Intelligence/Data Warehouse - Junior

Business Intelligence/Data Warehouse - Junior

SUMMARY

The Journey Data Warehouse Specialist plays a key role in building and maintaining modern data architectures that support the National Park Services (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: $70000 - $100000
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

• Bachelors 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 contractors 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.

Applicant must live in the U.S. and be authorized to work in the U.S.

Sanborn offers a comprehensive health and wellness program which includes medical dental vision 401k holiday PTO EAP disability and life insurance benefits.

TO APPLY: Visit our website: under the Careers menu option to apply. We are accepting applications for this position until July 19 2025. Sanborn is a Veteran/Disability Equal Opportunity Employer.