Business Intelligence/Data Warehouse - Senior

Business Intelligence/Data Warehouse - Senior

SUMMARY

The Senior Data Warehouse Specialist serves as a technical leader responsible for designing building and maintaining advanced data warehouse and data lake solutions that integrate geospatial and alphanumeric data. This role plays a critical part in consolidating data from diverse sources enabling advanced mapping reporting and self-service business intelligence (BI) capabilities across the organization. The specialist works closely with cross-functional teams to develop and optimize data architecture support enterprise-level decision-making and improve data accessibility and quality. This position requires a strong blend of technical expertise strategic thinking and the ability to translate complex data into meaningful insights that support mission goals and drive operational efficiency

COMPENSATION & BENEFITS

Salary Range: $95000 - $120000

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.
• Illustrating the ability to create advanced geospatial analytics and visualizations that drive strategic insights and support data-driven decision-making across the organization.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

SKILLS AND QUALIFICATIONS

• Senior level: Possesses and applies comprehensive knowledge across key tasks and high impact assignments.
• Plans and leads major technology assignments.
• Evaluates performance results and recommends major changes affecting project growth and success.
• Functions as a technical expert across multiple project assignments.
• May supervise others.
• 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 closely related technical field is required; a Masters degree is strongly preferred.
• Minimum of 5 years of progressive experience in data warehousing business intelligence or data architecture within complex or enterprise-level environments.
• Extensive hands-on experience designing building and managing data warehouses and/or data lakes including integrating geospatial and alphanumeric data sources.
• Strong experience developing and implementing ETL/ELT processes and data integration pipelines using modern data tools and platforms.
• Demonstrated expertise in data modeling (logical and physical) data architecture design and metadata management practices.
• Experience working with cloud-based data platforms and services (e.g. Microsoft Azure AWS Google Cloud) and supporting scalable secure data solutions.
• Proven ability to collaborate with cross-functional teams to translate business requirements into technical solutions including developing dashboards reports and advanced analytics products.
• Relevant advanced certifications (e.g. Microsoft Certified: Azure Solutions Architect Expert AWS Certified Big Data Specialty Google Professional Data Engineer) are highly desirable and may substitute for some experience..

SUPERVISORY RESPONSIBILITY

• Supervision may be 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.