Senior Snowflake DBA/Data Engineer

Tria Federal (Tria); United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Tria Federal in the United States is seeking a Senior Snowflake Database Administrator / Data Engineer to administer, optimize, secure, and maintain a complex Snowflake data warehouse.

You will work with Product Owners, Data Engineers, Architects, and Scrum/Kanban teams to meet performance, security, and cost goals in an Agile environment. The role demands deep Snowflake knowledge, strong SQL, and AWS experience for scalable data pipelines.

Qualifications

• Minimum 9 years of experience with a Bachelor's Degree.
• 2+ years on Snowflake administration with 10+ years of overall tech experience as a developer or DBA.
• Ability to work independently and effectively with little to no supervision.
• Strong Snowflake Platform Administration experience, including virtual warehouse optimization, RBAC design, and account configuration.
• Deep understanding of Snowflake architecture (Storage, Compute, Cloud Services, Time Travel, and Zero-Copy Cloning).
• Must have advanced SQL skills for performance tuning, query profiling, and administrative scripting.
• Demonstrated ability to use python or shell script to automate DB administration
• AWS experience (IAM roles, policies, and S3 external stages)
• Team player with excellent executive function and communication skills
• US Citizen or Green Card.

Responsibilities

• Administer, optimize, secure, and maintain a complex Snowflake data warehouse ecosystem.
• Collaborate with Product Owners, Data Engineers, Architects, and Scrum/Kanban teams to ensure alignment with platform performance standards, security requirements, cost-allocation goals, and Agile delivery expectations.
• Assist in design and governance of data pipelines and data models to support mission-critical analytics.

Skills

Snowflake Admin

SQL

Python scripting

AWS

RBAC design

Time Travel

Zero-Copy Cloning

Shell scripting

Education

Bachelor’s Degree

Tools

Terraform

Schemachange

Snowpipe

Job description

Who We Are

Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow.

Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow.

We are proud to employ and support military veterans

who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply.

The Senior Snowflake Database Administrator / Data Engineer will be responsible for administering, optimizing, securing, and maintaining a complex data warehouse ecosystem utilizing Snowflake. The admin will work closely with Product Owners, Data Engineers, Architects, and Scrum/Kanban teams to ensure alignment with platform performance standards, security requirements, cost-allocation goals, and Agile delivery expectations.

Mandatory Requirements

• Minimum 9 years of experience with a Bachelor’s Degree
• 2+ years on Snowflake administration with 10+ years of overall tech experience as a developer or DBA
• Ability to work independently and effectively with little to no supervision.
• Strong Snowflake Platform Administration experience, including virtual warehouse optimization, RBAC design, and account configuration.
• Deep understanding of Snowflake architecture (Storage, Compute, Cloud Services, Time Travel, and Zero-Copy Cloning).
• Must have advanced SQL skills for performance tuning, query profiling, and administrative scripting.
• Demostrated ability to use python or shell script to automate DB administration
• AWS experience (managing IAM roles, policies, and S3 external stages)
• Team player with excellent executive function and communication skills
• US Citizen or Green Card.

Preferred Requirements

• Prior Java or Other software development experience
• Scaled Agile Framework (SAFe) experience; certification preferred.
• Snowflake certifications (SnowPro Core or SnowPro Advanced: Administrator).
• Infrastructure as Code (IaC) experience using Terraform or Schemachange for Snowflake object provisioning.
• CLI Linux experience and automation of data pipelines (Snowpipe, Streams, Tasks).
• FinOps and cost optimization experience (implementing resource monitors and credit alerts).
• Experience working with Centers for Medicare and Medicaid (CMS) information systems.
• CMS/Medicare or Medicaid claims data experience

Why Tria?

What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success.

As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow.

California Consumer Privacy Act (CCPA)

We are committed to protecting your privacy. As part of our compliance with the California Consumer Privacy Act (CCPA), we want to inform you about how we collect, use, and protect your personal information during the job application process. For more details, please review https://www.oag.ca.gov/privacy/ccpa.