Position SummaryThe Senior Data Analyst/Data Computer Systems Engineer will provide expert-level data development and data systems engineering services for the National Park Service enterprise data management systems. This position is responsible for developing and maintaining complex data processing software, managing data pipelines, and leading data migration activities across both alphanumeric and geospatial data systems. The role requires advanced technical expertise in SQL, Python programming, and enterprise-level spatial data management to support mission-critical data infrastructure and business requirements.Duties May Include:Design and develop complex data models, database schemas, and data pipelines for enterprise systemsLead data migration planning and implementation from legacy to modern data structuresWrite advanced SQL, T-SQL, and PL/pgSQL procedural code for Microsoft SQL Server and PostgreSQL databasesArchitect and implement enterprise-level spatial data management solutions within RDBMS and geodatabasesBuild advanced coding and infrastructure for optimal ETL processes using Cloud and SQL technologiesConduct complex data quality analysis and implement comprehensive business and quality rulesDesign and implement quality management processes for large-scale data migration activitiesLead efforts in re-designing infrastructure for greater scalability and optimizing data deliveryAutomate manual processes and implement internal process improvementsProvide technical leadership for data-related issues and infrastructure needsCollaborate with stakeholders to identify process improvement opportunities and propose system modificationsStructure and optimize both small and large data sets for efficient retrieval and analysisDefine and maintain complex domain definition requirements and permissible valuesLead development of comprehensive metadata records for data management systems and standardsMentor junior team members and provide technical guidance on complex data engineering challengesRequirementsRequired Qualifications:Bachelor's degree in Computer Science, Data Science, Engineering, or related technical fieldMinimum 5 years of experience in data analysis and engineering activities including data schema developmentExpert-level proficiency in SQL, Python programming, and database procedural languagesExtensive experience with data migration activities and ETL/ELT processesAdvanced knowledge of Microsoft SQL Server and PostgreSQL database systemsStrong experience with enterprise spatial data management and geodatabasesProven ability to design and implement scalable data architecturesExperience with cloud platforms (Microsoft Azure or AWS) for data processingActive NAC or NACI security clearance eligibilityDesired Qualifications:Advanced degree in Computer Science, Data Engineering, or related fieldCertification in cloud platforms (Azure Data Engineer, AWS Data Analytics)Experience with ESRI Enterprise Geodatabases and ArcGIS platformsKnowledge of modern data stack technologies and data lake architecturesExperience with Azure DevOps Server and Github for code managementUnderstanding of data governance and metadata management principlesExperience with API development and microservices architecturesKnowledge of machine learning and advanced analytics techniques