General Dynamics Information Technology

Snowflake Database Administrator

General Dynamics Information Technology

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $119,000 - $161,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AWSAzureCloudETLPySparkPythonSQLTerraform

About the role

  • Attend daily stand-up scrum calls and participate in Agile team ceremonies
  • Exercise strong interpersonal and communication skills while working independently and collaboratively within a high-performing agile team
  • Administer and optimize enterprise-scale Snowflake environments with petabyte-scale datasets and high concurrency workloads
  • Analyze complex business and technical requirements to design and implement performant and secure Snowflake database solutions
  • Collaborate with stakeholders, architects, data engineers, and developers to define, design, build, and maintain scalable Snowflake database environments
  • Design and optimize data architectures, partitioning strategies, and clustering keys for high-performance querying
  • Implement robust data governance and security models including RBAC, masking, tagging, and access controls
  • Support operational tasks and processes such as automation, orchestration, job scheduling, monitoring, performance tuning, and usage optimization
  • Lead performance investigations, query tuning, and workload analysis using Snowflake’s Query Profile, Resource Monitors, and optimization tools
  • Manage data ingestion strategies using various file formats (Parquet, JSON, Avro, ORC, Iceberg) and storage (AWS S3 etc.)
  • Establish and enforce Snowflake standards, best practices, and operational procedures including monitoring, alerting, tagging, and usage auditing
  • Coordinate and execute data migration, backup, cloning, and restoration strategies at scale
  • Implement and monitor data quality processes including validation, reconciliation, and lineage tracking
  • Identify and implement continuous process improvements and drive automation initiatives
  • Stay current with advancements in Snowflake features, best practices, and cloud-native data services
  • May serve as a task or team lead for Snowflake-specific initiatives
  • Serve as a subject matter expert in Snowflake administration and optimization at the enterprise scale

Requirements

  • Snowflake (Platform), Snowflake Data Warehouse, Snowflake GenAI skills
  • 5+ years of related IT/database administration experience
  • At least 2 years managing enterprise-scale Snowflake deployments
  • Proven experience managing petabyte-scale Snowflake environments in production
  • BA/BS in Computer Science, Information Systems, or related technical field, or equivalent combination of education, certifications, and experience
  • Hands-on experience with Python, Snowpark and PySpark
  • Experience in cloud-native ETL/ELT development using AWS Services, Databricks, or similar platforms
  • Solid experience in query optimization, resource management, Snowflake performance tuning, and capacity planning
  • Experience integrating Snowflake with Amazon S3, IAM, PrivateLink, and notification services (SNS, SES, Azure equivalents)
  • In-depth understanding of data governance, data security, RBAC, audit logging, compliance frameworks, replication, and data masking
  • Familiarity with DevOps, CI/CD pipelines, GitHub, and Agile development methodologies
  • Public Trust: Ability to obtain a Public Trust; candidate must have lived in the United States at least three (3) out of the last five (5) years and pass a public trust background investigation
  • Public Trust/Other Required: NACI (T1)
  • US Citizenship Required: No
  • Scheduled Weekly Hours: 40
  • Travel Required: None
  • Desired: Snowflake Snowpro Certifications preferred
  • Desired: Prior experience supporting CMS or other federal healthcare IT environments strongly preferred
  • Desired: Knowledge of data modeling, semantic layer design, dimensional modeling, and schema optimization for Snowflake
  • Desired: Strong understanding of data lineage, schema evolution, and data observability practices
  • Desired: Background in data engineering, analytics, or BI/reporting
  • Desired: Familiarity with cost optimization techniques and Snowflake credit management
  • Desired: Knowledge of Infrastructure as Code (IaC) using Terraform or CloudFormation