Senior Snowflake Software Developer
Req number:R7765
Employment type:Full time
Worksite flexibility:Hybrid
Who we areCAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Job SummaryWe are looking for a motivated Senior Snowflake Software Developer ready to take us to the next level! If you have expert-level skills in Snowflake Cloud Data Platform, SQL, and enterprise data engineering and are looking for your next career move, apply now.
Job DescriptionWe are looking for a
Senior Snowflake Software Developer to design, develop, and optimize Snowflake data solutions for enterprise-level applications. This position will be
full-time, and
hybrid. With employees expected to work onsite 3 days per week.
Only work authorizations that will not require sponsorship now or in the future will be considered.
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 NeedRequired:
- 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
Physical Demands - Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
- Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
- Must be able to communicate with customers/team members over the phone and in person
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
#LI-NA1
Reasonable accommodation statementIf you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to or .
EEO StatementIt is the policy of Computer Aid, Inc.(CAI) not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or protected veteran status, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment.
Employees and applicants of CAI will not be subject to harassment on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.
$70 - $80 per hour
The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.
Never miss an opportunity! Create an alert based on the job you applied for.
