Senior Applications Developer - Snowflake

At Curriculum Associates (CA), we believe a diverse team leads to diversity in thinking, making our products better for teachers and students. If you read this job description, feel energized by what you see here, and believe you could bring passion and commitment to the role, but you aren’t sure you meet every qualification, please apply! Above all, we are looking for the right person!

Summary:  

As a Senior Snowflake Developer, you'll lead the design, development, and maintenance of sophisticated software applications using Snowflake and other data technologies, ensuring they align with the needs of our internal teams and external clients. Collaborating closely with our IT teams, project managers/Agile leads, and end-users, both in India and US, you'll analyze requirements, devise solutions, and deliver top-tier software solutions. 

Essential duties/responsibilities:  

• Analyze requirements: Collaborate with stakeholders to scrutinize requirements for new software applications or enhancements, guaranteeing that developed software fulfills customer needs. 

• Design software solutions: Contribute to crafting detailed design specifications for data models, schemas, views, and stored procedures using Snowflake features such as time travel, zero copy cloning, and secure data sharing based on gathered requirements, steering the development process to ensure the resulting software meets functional and technical demands. 

• Develop and deploy scalable software: Write clean, maintainable, and well-documented data pipelines using Snowflake SQL, Snowpipe, and other tools to ingest, transform, and deliver data from various sources, leveraging your expertise to ensure scalability, complexity, efficiency and lead deployment activities of that code in multiple environments. 

• Integrate software components: Seamlessly integrate software components into a fully functional software system, ensuring compatibility and interoperability with existing systems for smooth communication and data exchange. 

• Perform unit testing: Conduct thorough unit testing of developed queries and components, ensuring data quality and accuracy by implementing data validation, testing, and monitoring frameworks and tools adhering to quality standards and expected performance levels. 

• Debug and troubleshoot: Skillfully debug and troubleshoot software applications, swiftly identifying and resolving issues encountered during development or deployment to ensure uninterrupted operation and minimal downtime for end-users. 

• Provide technical support: Offer expert technical support and guidance to end-users by applying Snowflake best practices such as partitioning, clustering, caching, and compression, empowering them to utilize the software effectively and troubleshoot any encountered issues. 

• Stay updated with technology: Remain abreast of emerging technologies, trends, and best practices in Snowflake and data domain, integrating relevant advancements into our software solutions. 

• Collaborate with team: Foster effective communication and coordination throughout the software development lifecycle by collaborating with IT team members, data engineers, project managers, and end-users, ensuring a collaborative work environment and successful project delivery.  

• Mentor and lead junior developers.  

• Document processes: Document processes, procedures, and technical specifications related to software development and deployment, facilitating knowledge sharing within the team and streamlining future development efforts. 

Required Job Skills and Abilities:  

• Expertise with software development tools, including integrated development environments (IDEs), version control systems (e.g., Git), and issue tracking systems (e.g., Jira), DevOps principles and CI/CD pipelines. 

• Experience providing technical support and guidance to end-users during the implementation and deployment of software applications. 

• Strong analytical thinking skills to understand complex requirements and design software solutions accordingly.  Ability to read and understand other developer’s code  

• Proficiency in industry standard testing methodologies and debugging techniques to ensure software quality and identify and resolve issues. 

• Ability to document processes, procedures, and technical specifications related to software development and deployments  

Required Education and Experience:  

• Bachelor's degree in computer science, Information Technology, Software Engineering, Statistics, or a related field. A combination of relevant education and professional experience may be considered instead of a bachelor's degree 

• At least 5 years of experience in data engineering, data warehousing or data analysis 

• At least 3 years of experience in Snowflake and data integration tools such as AWS AppFlow, Spark or Kafka 

• Proficiency in one or more programming languages such as SQL and Python   

• Strong problem-solving skills and attention to details 

• Excellent communication skills, both verbal and written  

• Experience with iPaaS tools (e.g., Workato) and/or Salesforce DataCloud a plus