Seize your opportunity to make a personal impact supporting the Case Management Modernization (CMM) Program. The CMM program is an initiative to support the Administrative Office of the US Courts (AO) in developing a modern cloud-based solution to support all 204+ federal courts across the United States.

GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. The Snowflake Administrator will work as part of the CMM Enterprise Data Warehouse (EDW) team to deploy a secured cloud-native EDW platform and support the statutory and operational reporting, data cataloging, and other analytical objectives.

The Snowflake Administrator is responsible for the design, administration, optimization, and secure operation of the Snowflake DWaaS environment supporting the CMM EDW. This role ensures high availability, performance, cost efficiency, security compliance, and seamless support to data engineering, BI, and analytics teams in a federal cloud environment.

Key Responsibilities

• Manage and optimize Snowflake environments including account setup, configuration, scaling, performance tuning, and warehouse management to ensure reliable and efficient data operations.
• Create, maintain, and govern databases, schemas, roles, and RBAC access controls aligned with AO security, IAM, and compliance policies.
• Monitor and troubleshoot data pipelines, query performance, concurrency, and resource utilization to maintain uptime and cost efficiency.
• Implement cost-optimization strategies (auto-suspend/resume, right-sizing, workload isolation) and contribute to financial reporting, forecasting, and TCO analysis.
• Automate and document administrative activities such as environment provisioning, user/role management, data loading, and monitoring using Terraform, dbt, SQL, Python, or equivalent tooling.
• Collaborate with data engineers, BI developers, and architects to design efficient data models, optimize ELT workflows, and improve overall platform performance.
• Support security audits, ATO artifacts, incident response, DR/HA testing, and operational runbooks related to Snowflake services.

• Documentation of data architectures, data models, performance metrics, runbooks, and progress reports
• Cloud monitoring dashboards, capacity planning, KPI metrics, and optimization recommendations
• Design and testing of DR and High Availability strategies for Snowflake DWaaS
• Support for incident reports, root cause analysis, and vulnerability reports related to database access
• Performance Outcomes
  • High-availability, secure Snowflake operations with measurable improvements in performance, cost efficiency, and reliability
  • Timely delivery of operational documentation, metrics, and remediation actions supporting EDW governance

REQUIRED EXPERIENCE

• Strong experience with database or cloud data platform administration, including hands-on Snowflake experience
• Strong expertise in SQL, performance tuning, and workload management
• Experience operating data platforms in AWS-based or hybrid cloud environments
• Proven ability to automate infrastructure and administration using IaC and scripting

• Experience with Terraform, dbt, Python, or similar automation frameworks
• Familiarity with federal security, compliance, and audit processes
• Snowflake SnowPro Core or higher certification
• Tools & Technologies: Snowflake, AWS, Terraform, dbt, SQL, Python, CI/CD pipelines, monitoring/observability tools

QUALIFICATIONS

• 7+ years experience in Server database maintenance and database administration or similar role.
• Bachelor's degree in Computer Science, Information Technology, or related field.

• Excellent presentation and communication (oral and written) skills.

• Consultant mindset with the ability to work with high level customer stakeholders and build excellent customer relationship.

• Experience identifying and applying industry tools, solutions, methods best practices, and emerging technologies.

• Strong analytical skills and problem-solving skills with the ability to formulate and communicate recommendations for improvement.

• Demonstrated ability to work effectively, independently, and as part of a team.