The 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.
Design and develop complex data models, database schemas, and data pipelines for enterprise systems
Lead data migration planning and implementation from legacy to modern data structures
Write advanced SQL, T-SQL, and PL/pgSQL procedural code for Microsoft SQL Server and PostgreSQL databases
Architect and implement enterprise-level spatial data management solutions within RDBMS and geodatabases
Build advanced coding and infrastructure for optimal ETL processes using Cloud and SQL technologies
Conduct complex data quality analysis and implement comprehensive business and quality rules
Design and implement quality management processes for large-scale data migration activities
Lead efforts in re-designing infrastructure for greater scalability and optimizing data delivery
Automate manual processes and implement internal process improvements
Provide technical leadership for data-related issues and infrastructure needs
Collaborate with stakeholders to identify process improvement opportunities and propose system modifications
Structure and optimize both small and large data sets for efficient retrieval and analysis
Define and maintain complex domain definition requirements and permissible values
Lead development of comprehensive metadata records for data management systems and standards
Mentor junior team members and provide technical guidance on complex data engineering challenges
Bachelor's degree in Computer Science, Data Science, Engineering, or related technical field
Minimum 5 years of experience in data analysis and engineering activities including data schema development
Expert-level proficiency in SQL, Python programming, and database procedural languages
Extensive experience with data migration activities and ETL/ELT processes
Advanced knowledge of Microsoft SQL Server and PostgreSQL database systems
Strong experience with enterprise spatial data management and geodatabases
Proven ability to design and implement scalable data architectures
Experience with cloud platforms (Microsoft Azure or AWS) for data processing
Active NAC or NACI security clearance eligibility
Advanced degree in Computer Science, Data Engineering, or related field
Certification in cloud platforms (Azure Data Engineer, AWS Data Analytics)
Experience with ESRI Enterprise Geodatabases and ArcGIS platforms
Knowledge of modern data stack technologies and data lake architectures
Experience with Azure DevOps Server and Github for code management
Understanding of data governance and metadata management principles
Experience with API development and microservices architectures
Knowledge of machine learning and advanced analytics techniques
...Description SUMMARY Airport Communication Dispatchers provide the communication link for security and emergency services at the airport. They direct the response of Airport Police relative to all incidents involving passengers and visitors. SHIFT: Rotating...
...career advancement and growth within the organization Work weekends with a flexible weekday schedule Engage directly with valued... ...Compliance teams to resolve member issues Conduct advanced research into complex member escalations, including trade disputes and regulatory...
...Research Study Assistant - Northwestern University (MED?Neurology Department) Salary/Grade: NEX/9 Target hiring range: $19.00$21.30 per hour... ...and other tasks as required. Work schedule varies: weekend, evening, overnight, early morning shifts. Specific Responsibilities...
...and Torley and Standard Forged, which have been in continuous operations since 1869, the same year the first US transcontinental railroad was completed. We have been able to meet the needs of our customers with a steady, dependable and economical supply of high-quality...
...coverage with multiple plan options ~ Late-model fleet (7 years or newer) safe, reliable trucks What Youll Do: Safely operate a Class B flatbed truck with Moffett or Box Truck Deliver building material to commercial & residential job sites Load/unload...