Business Intelligence Analyst

Position Summary

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.

Duties May Include:

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

Required Qualifications:

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

Desired Qualifications:

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:

• Medical, Dental & Vision Coverage – Full coverage for employees and family through CareFirst and VSP.
• Paid Time Off – Minimum of 2 weeks PTO in accordance with contract requirements.
• Paid Holidays – 11 federal holidays observed annually.
• Disability & Life Insurance – Short-term/long-term disability, life insurance, and AD&D coverage included.
• 401(k) Retirement Plan – Competitive plan managed through Ameritas.
• Professional Training – Formal training provided as required, with additional learning opportunities based on role.