REQ#: RQ211919Public Trust: None Requisition Type: Regular Your Impact

Own your opportunity to work alongside federal civilian agencies. Make an impact by providing services that help the government ensure the well being of U.S. citizens.

Job Description

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 reportsCloud monitoring dashboards, capacity planning, KPI metrics, and optimization recommendationsDesign and testing of DR and High Availability strategies for Snowflake DWaaSSupport for incident reports, root cause analysis, and vulnerability reports related to database accessPerformance OutcomesHigh-availability, secure Snowflake operations with measurable improvements in performance, cost efficiency, and reliabilityTimely 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 experienceStrong expertise in SQL, performance tuning, and workload managementExperience operating data platforms in AWS-based or hybrid cloud environmentsProven ability to automate infrastructure and administration using IaC and scriptingExperience with Terraform, dbt, Python, or similar automation frameworksFamiliarity with federal security, compliance, and audit processesSnowflake SnowPro Core or higher certificationTools & 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.