[Remote] Senior Snowflake Data Engineer

Note: The job is a remote job and is open to candidates in USA. Peraton is a next-generation national security company that drives missions of consequence spanning the globe. The Senior Snowflake Data Engineer will be responsible for designing, developing, and optimizing data pipelines while also serving as a backup Snowflake administrator, collaborating with various teams to ensure alignment with performance standards and Agile delivery expectations.ResponsibilitiesThe Senior Snowflake Data Engineer will split responsibilities between hands-on data engineering (pipeline development, data modeling, performance tuning) and backup platform administration (RBAC, cost optimization, backup recovery)They will work closely with Product Owners, Data Engineers, Architects, and Scrum/Kanban teams to ensure alignment with platform performance standards, security requirements, architectural designs, and Agile delivery expectationsSkillsMinimum of 12 years with BS/BA; Minimum of 10 years with MS/MA; Minimum of 7 years with Ph.D7+ years of overall tech experience as Snowflake/Java/Python/ETL Developer and 2+ year of Snowflake AdministrationAbility to work independently and effectively with little to no supervisionStrong Snowflake Platform Administration and Development experience, including virtual warehouse optimization, complex RBAC design, data modeling, and schema managementDeep understanding of Snowflake architecture (Storage, Compute, Cloud Services, Time Travel, Fail-safe, and Zero-Copy Cloning)Hands-on experience developing efficient data pipelines, utilizing Snowflake features like Snowpipe, Streams, Tasks, and Stored Procedures (SQL/Python/Java)Must have advanced SQL skills for writing complex analytical queries, data transformation, performance tuning, and query profilingDemonstrated ability to use Python or shell scripting to automate database administration and data engineering workflowsAWS experience (managing IAM roles, security policies, and S3 external stages)Team player with excellent executive function and communication skillsUS Citizen or Green Card Holder and must have been in the US for 3 of the last 5 yearsMust be able to obtain a Public Trust clearancePrior Java, Python, or other object-oriented software development experienceExperience designing and implementing disaster recovery, data replication, and backup/failover strategies in Snowflake across regions or cloud providersScaled Agile Framework (SAFe) experience; certification preferredSnowflake certifications (SnowPro Core, Advanced Administrator, or Advanced Data Engineer)Infrastructure as Code (IaC) experience using Terraform or Schemachange for Snowflake object and pipeline provisioningCLI Linux experience and automation of cloud-native data architecturesFinOps and cost-optimization experience (implementing resource monitors, credit alerts, and optimizing warehouse compute efficiency for incremental loads)Experience working with Centers for Medicare and Medicaid (CMS) information systemsCMS/Medicare or Medicaid claims data experienceBenefitsDepending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.Company OverviewPeraton Fearlessly solving the toughest national security challenges. It was founded in 1992, and is headquartered in Woodbridge, New Jersey, USA, with a workforce of 10001+ employees. Its website is https://www.peraton.com/.