Snowflake Administrator

Overview

Req : RQ211919

Type of Requisition: Regular

Clearance Level Must Be Able to Obtain: None

Public Trust/Other

Required:

None

Job Family: Data Science and Data Engineering

Skills:

Database Performance, Data Modeling, Data Operations, Data Warehouse, Enterprise Data

Experience:

7 + years of related experience

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.

• 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

• 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 Snow Pro Core or higher certification

• Tools & Technologies :
  Snowflake, AWS, Terraform, dbt, SQL, Python, CI/CD pipelines, monitoring/observability tools

• 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.

The likely salary range for this position is $148,750 - $201,250. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a…