What are the responsibilities and job description for the Senior Snowflake Software Developer position at Apton, Inc.?
Must be capable of being on-site day one.
Job Description
We are looking for a Senior Snowflake Software Developer to design, develop, and optimize Snowflake data solutions for enterprise-level applications. This position will be hybrid. With employees expected to work onsite 3 days per week.
What You’ll Do
- Design and maintain Snowflake data schemas, models, and data lake architectures
- Develop efficient, automated ELT pipelines to ingest data from diverse enterprise sources into Snowflake
- Build data transformation pipelines utilizing dbt (Data Build Tool) and native Snowflake features like tasks and streams
- Write custom data engineering scripts, automation pipelines, and UDFs using Python and Snowpark
- Optimize query performance and virtual warehouse sizing using query profiles and automatic clustering
- Monitor, audit, and optimize Snowflake credit consumption and warehouse spending
- Write complex SQL queries, analytical functions, and advanced stored procedures
- Implement robust security and data governance measures, including RBAC, masking policies, and encryption
- Establish automated data quality validation frameworks, monitoring alerts, and observability dashboards
- Manage database infrastructure and dbt models as code within version control systems (Git) using automated CI/CD deployment pipelines
- Implement disaster recovery strategies utilizing Snowflake Replication, Failover Groups, and Time Travel
- Collaborate with cross-functional data, science, and analytics teams in an Agile/Scrum environment
What You'll Need
Required:
- Bachelor’s or Master’s degree in computer science, data engineering, or a related field.
- 7 years of experience in data warehousing, data modeling, and enterprise data engineering.
- 3 years of direct, hands-on production engineering experience inside Snowflake.
- Strong proficiency in Python development tailored for data engineering, including hands-on Snowpark experience.
- Proven production experience using modern transformation tools, specifically dbt (Data Build Tool).
- Solid experience with Snowflake cost management, infrastructure optimization, and performance tuning.
- Deep understanding of enterprise data security, role-based access control (RBAC), and governance compliance.
- Experience managing infrastructure as code via Git and automated CI/CD deployment pipelines.
- Excellent problem-solving, communication, and Agile collaboration skills.
Preferred:
- Snowflake certifications (such as SnowPro Core or Advanced).
- Agile Scrum team collaboration experience.