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
Tria Federal builds, modernizes, and operates mission-critical federal health platforms and programs. It was founded in 2021, and is headquartered in Arlington, Virginia, USA, with a workforce of 1001-5000 employees. Its website is https://triafed.com.