Senior Software Developer
CAI

Senior Software Developer
Req number:
R2117
Employment type:
Full time
Worksite flexibility:
Hybrid
Job Summary
As a Senior Snowflake Developer you will design, implement, and optimize data solutions using the SF cloud data platform. You will play a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics.
Job Description

We are searching for a Senior Snowflake Developer to design, implement, and optimize data solutions using the SF cloud data platform. Plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics. This is a Hybrid position - 3 Days On-Site, 2 Days Remote. Interview: In Person ONLY

What You'll Do

• A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform
  
• This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the organization
  
• Data Architecture: Collaborate with data architects to design and develop Snowflake data models and schemas
  
• Create and maintain a well-structured data warehouse and data lake architecture
  
• Data Integration: Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake
  
• Ensure data integration processes are efficient, reliable, and scalable
  
• Design and implement data pipelines using Snowflake features like tasks and streams
  
• Performance Optimization: Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys
  
• Identify and resolve performance bottlenecks in data processing
  
• SQL Development: Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs
  
• Ensure SQL code follows best practices for readability and performance
  
• Security and Access Control
  
• Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data
  
• Audit and monitor data access and user activities
  
• Data Quality Assurance
  
• Define and implement data quality checks and validation processes to maintain data accuracy
  
• Establish data quality rules and alerts to proactively identify issues
  
• Documentation: Create and maintain technical documentation for data models, ETL processes, and data dictionaries
  
• Document best practices, standards, and guidelines for Snowflake development
  
• Version Control and Deployment: Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects
  
• Coordinate the deployment of changes to Snowflake environments
  
• Monitoring and Alerts: Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues
  
• Troubleshoot and resolve incidents related to data processing and performance
  
• Backup and Recovery: Implement backup and recovery strategies to ensure data integrity and availability
  
• Develop and test data recovery procedures
  
• Collaboration: Collaborate with data engineers, data scientists, and business analysts to understand data requirements and provide data solutions
  
• Work with cross-functional teams to support data-related projects and initiatives
  

What You'll Need

Required:

• 7+ years of experience as a Snowflake developer or data engineer with a focus on data warehousing and ETL
  
• Snowflake certification(s) is a plus
  
• Strong SQL skills and proficiency in data modeling and database design
  
• Knowledge of cloud data warehousing concepts and best practices
  
• Familiarity with data integration tools and technologies
  
• Solid understanding of data governance, data security, and compliance requirements
  
• Experience with version control systems and deployment processes
  
• Excellent problem-solving and troubleshooting skills
  
• Strong communication and collaboration abilities
  
• Ability to work in an Agile or iterative development environment. development environment
  
• 5+ years of experience as a Snowflake developer (Required - 5 years)
  
• 7 + years of experience as a data engineer with a focus on data warehousing and ETL (Required - 7 years)
  
• Strong SQL skills and proficiency in data modeling and database design
  
• Knowledge of cloud data warehousing concepts and best practices
  
• Experience with data integration tools and technologies (Required - 7 years)
  
• Solid understanding of data governance, data security, and compliance requirements (Required - 7 years)
  
• Experience with version control systems and deployment processes (Required - 7 years)
  
• Strong Experience with problem-solving and troubleshooting skills (Required - 8 years)
  
• Experience working in an Agile or iterative development environment (Required - 7 years)
  
• Bachelor's or Master's degree in computer science, data engineering, or a related field (Required - 4 years)
  

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
  
• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
  
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
  

Reasonable Accommodation Statement

If 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 application.accommodations@cai.io or (888) 824 - 8111.

Equal Employment Opportunity Policy Statement

It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being 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 being a protected veteran, 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 due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being 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.

This job has expired.