The Senior Business Intelligence Analyst/Data Warehousing Specialist will provide expert-level knowledge and experience in building complex data integrations, geospatial and alphanumeric data warehouses, and data lakes that consolidate and geospatially enable data for enterprise-wide analysis. This position leads the development of comprehensive data integration strategies that support user needs for mapping, reporting, and self-service business intelligence activities across the National Park Service. The role requires advanced technical expertise in data warehousing, modern data stack technologies, and the ability to coordinate complex projects with multiple stakeholders and technical teams.
Lead development of comprehensive data integration strategy for NPS enterprise systems
Design and implement complex data warehouses, data lakes, and geospatial data warehouses
Architect data integration solutions consolidating data from various GIS datasets, enterprise systems, and external sources
Lead assessment and implementation of integration, geospatial mapping, reporting, and visualization tools
Design and develop enterprise data architecture supporting diverse business requirements
Conduct advanced analysis of data warehouse and business intelligence activities to identify required resources
Lead design of integration architecture, data service patterns, and conduct complex source-to-target mapping
Develop sophisticated data lake and geospatial data warehouse models integrating multiple data sources
Create high-level logical and physical data models for both alphanumeric and geospatial systems
Design and implement comprehensive metadata solutions for ETL/ELT processes
Lead development of advanced database scripts and tools supporting automated data movement
Implement ETL, ELT, and service-based technologies for enterprise data automation
Evaluate source systems and provide recommendations for enterprise system enhancements
Lead analysis of NPS data infrastructure to identify gaps and develop integration plans
Design and prototype advanced reports, dashboards, and maps for diverse end user communities
Implement AI and Machine Learning technologies for business intelligence mining
Coordinate complex tasks with NISC team members and enterprise stakeholders
Requirements
Bachelor's degree in Computer Science, Data Science, Information Systems, or related field
Minimum 5 years of experience building data warehouses including spatial data components
Extensive experience working with data dashboards, reports, maps, and visualizations from aggregated data
Expert knowledge of ETL/ELT processes and modern data warehousing technologies
Advanced skills in SQL, Python, and data modeling techniques
Experience with both traditional data warehouse and data lake architectures
Proven ability to coordinate complex technical projects with multiple stakeholders
Experience with cloud-based data platforms and services
Active NAC or NACI security clearance eligibility
Advanced degree in Data Science, Computer Science, or related field
Certification in cloud data platforms (Azure Data Engineer, AWS Data Analytics)
Experience with modern data stack technologies (Snowflake, Databricks, etc.)
Advanced knowledge of geospatial data integration and analysis techniques
Experience with AI/ML platforms and advanced analytics tools
Knowledge of real-time data streaming and event-driven architectures
Experience with DataOps and automated data pipeline management
Understanding of data governance and enterprise metadata management
Benefits
At Trinity Global Consulting (TGC), we value our employees and provide a comprehensive benefits package that includes:
Responsibilities Peraton is looking for aDigital Forensic Examiner to support the Air Force Office of Special Investigations at Joint Base San Antonio-Lackland in support of a federal agency, focused on sensitive on-going criminal investigations and operations. Using...
Experienced Used Car Sales Professionals - We Want You!Join the Pre-Owned Sales Team at Melloy Chevrolet Los LunasAre you a proven closer in used car sales? Ready to take your income and career to the next level? Melloy Chevrolet in Los Lunas is looking for experienced...
...standing, lifting, and moving for extended periods A team player committed to maintaining a safe and clean kitchen At least 16 years old, with good communication and time-management skills Why Join Us? Become a key part of a brand-new, locally owned restaurant...
...A Car Sales Associate, or Auto Sales Representative, is responsible for selling cars, trucks and vans for personal and commercial use. Their duties include meeting with customers to discuss their needs, promoting sales offers at their dealership and participating in test...
...DAY WORKWEEK - 4 10'S.- MON-THUR. GREAT COMPANY! GREAT CULTURE! GREAT BENEFITS! Fitting, fabricating, cutting, silver brazing, welding (TIG, MIG (STT/PULSE), SMAW). Typical applications will be on pipe/tubing ranging in size from 1/4" to 6" in diameter and .025...