Senior Business Intelligence/Data Warehouse Specialist

Savan is seeking a Senior Business Intelligence/Data Warehouse Specialist to lead a data integration and analytics modernization effort in support of the National Park Service (NPS). This senior-level role will design and implement scalable geospatial and alphanumeric data lakes and warehouses, automate ETL/ELT pipelines, and deliver actionable business intelligence products—such as Power BI dashboards and ArcGIS web maps—to support self-service analytics and resource vulnerability assessments across the enterprise. The ideal candidate brings deep experience with both traditional and modern data architectures, a strong understanding of spatial data systems, and the ability to translate user needs into integrated, sustainable solutions. Key Responsibilities:

• Lead the development of an enterprise data integration strategy, including lifecycle planning and phased execution.
• Conduct data discovery with source system owners and identify priority geospatial and tabular datasets.
• Design and implement logical and physical data models (e.g., star/snowflake schemas, spatial models) and integration architecture.
• Build and manage cloud/hybrid data lakes and warehouses using SQL Server, PostgreSQL/PostGIS, and Azure Data Lake/Storage.
• Automate ETL/ELT pipelines using Azure Data Factory, SSIS, and Python; document workflows and metadata.
• Prototype and publish dashboards, maps, and services using Power BI, ArcGIS Online, and REST APIs.
• Define and enforce metadata and data quality standards; monitor KPIs and address data quality issues.
• Evaluate and recommend improvements to BI and mapping platforms based on evolving needs and technologies.
• Coordinate with NISC developers, DBAs, and data governance staff to ensure alignment on standards, security, and compliance.
• Support stakeholder communication through milestone briefings, risk assessments, and demonstrations.

Minimum Qualifications:

• 5–10 years of experience building enterprise-scale data warehouses, including geospatial components.
• Proven experience delivering dashboards, reports, and visualizations from aggregated data sources.
• Proficiency in data warehousing tools and platforms (SQL Server, PostgreSQL/PostGIS, Azure, etc.).
• Experience with Modern Data Stack concepts and spatial data warehousing approaches.
• Strong background in data integration, ETL/ELT processes, and BI/reporting tools.
• Bachelor’s degree in Data Science, Information Systems, Computer Science, GIS, or a related field (Master’s degree preferred).

Preferred Certifications:

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Certified: Azure Data Engineer Associate (DP-203)
• Certified Data Management Professional (CDMP – Data Integration track)
• Esri Enterprise Geodata Management Professional

Work Location and Schedule:  Denver, CO or Remote Application Process Submit your application to the link on this page.  Applicants selected for interviews will be notified by email or phone. Compensation Savan believes in offering fair and competitive compensation to all employees. Our salary structures are based on industry standards, market conditions, and the specific demands of each role. Salary determination for potential new employees is influenced by a combination of factors, including years of experience, educational qualifications, specialized skills and expertise relevant to the job, complexity, and scope of the role's responsibilities, internal salary structures, as well as the geographic location of the job. Salary history will not be used in compensation decisions.  EEO, including disability and veterans. Savan is an Equal Opportunity Employer and is committed to a workplace free of discrimination. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), gender identity, sexual orientation, national origin, age (40 or older), marital status, disability, genetic information, status as a protected veteran, or any other applicable legally protected characteristics. If you are an individual with a disability and would like to request reasonable accommodation for the employment process, please email your request to [email protected]. For more information about our company, please visit our website at www.savangroup.com.   Experience RequirementsExperienced Apply To This Job