Job Title: Snowflake Developer (SQL & Alteryx)
Location: Remote
Duration: 6- 12 Months
Visa: USC
Must have SnowPro Core Certification or equivalent
Need a candidate who have an excellent experience in financial domain.
Job Summary
Client is seeking a skilled Snowflake Developer who combines strong SQL capabilities with hands-on experience in Alteryx. In this role, you will design and implement Snowflake-based data models and pipelines, develop robust transformation logic, and optimize performance. You will collaborate with data engineers, analysts, and business stakeholders to support regulatory, risk, and customer-focused data needs in a banking environment, while ensuring data quality, governance, and security.
Key Responsibilities
- Snowflake development and data modeling:
- Design, implement, and maintain Snowflake schemas, tables, views, materialized views, and data sharing
- Develop robust ELT/ETL transformations using Snowflake SQL, UDFs, and semi-structured data handling
- Implement and optimize Snowflake features such as warehouses, clustering, time travel, zero-copy cloning, streams, tasks, and data sharing
- Alteryx integration and workflow optimization:
- Build and maintain Alteryx workflows that connect to Snowflake as a data source/target
- Optimize Alteryx Designer/Server workflows for performance, scalability, and reliability
- Collaborate with data engineers to design efficient data pipelines and transformations
- Data quality, governance, and security:
- Implement data quality checks, data lineage, and metadata management
- Apply RBAC, masking policies, encryption, and network policies as appropriate for banking data
- Maintain documentation and support regulatory data requirements
- Collaboration and delivery:
- Translate business requirements into technical designs, data mappings, and specs
- Perform code reviews, contribute to design best practices, and ensure changes meet regulatory and security standards
- Partner with analytics, BI, and governance teams to fulfill reporting and analytics needs
- Testing, deployment, and automation:
- Write unit/integration tests for SQL and data pipelines; participate in CI/CD for data assets
- Automate routine maintenance and deployment tasks with Python, SQL, or shell scripting
- Incident response and support:
- Troubleshoot production issues, perform root-cause analysis, and implement durable fixes
- Create runbooks and knowledge base articles for common scenarios
- Documentation:
- Maintain data dictionaries, lineage, and design documentation for data assets