Note: The job is a remote job and is open to candidates in USA. Tria Federal is a company that delivers digital services and technology solutions to support the health and safety of veterans and civilians. They are seeking a Senior Data Engineer who will be responsible for administering and optimizing a complex data warehouse ecosystem utilizing Snowflake, collaborating with various teams to meet performance and security standards.

Responsibilities

• Administering, optimizing, securing, and maintaining a complex data warehouse ecosystem utilizing Snowflake
• 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

Skills

• 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
• 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 (managing IAM roles, policies, and S3 external stages)
• Team player with excellent executive function and communication skills
• US Citizen or Green Card
• 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

Benefits

• Top-tier benefits package to invest in your physical, mental, and financial health and wellness
• Opportunities to learn new skills
• Seize new challenges
• Advance your career as we grow

Company Overview