Snowflake Developer - SQL - Alteryx

Overview

Remote
$50 - $55
Contract - W2

Skills

Snowflake
SQL
Alteryx

Job Details

Snowflake Developer

Required Location: 100% Remote

Interview Required: Video

A senior (12+ years) Snowflake developer with 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. Candidate will 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 as well as Implement and optimize Snowflake features such as warehouses, clustering, time travel, zero-copy cloning, streams, tasks, and data sharing.

Please make sure that each submittal includes:

  1. Driver s license or State ID
  2. Link to the candidates LinkedIn account.

Job Description: Job Summary Flagstar Bank 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

Required Qualifications

  • Bachelor s degree in Computer Science, Information Systems, or a related field (or equivalent work experience)
  • 6+ years of Snowflake development experience (designing schemas, pipelines, and transformations)
  • Strong SQL skills with the ability to write complex queries and optimize performance
  • Practical experience building and maintaining Alteryx workflows that interact with Snowflake
  • Thorough understanding of Snowflake concepts: warehouses, clustering, time travel, zero-copy cloning, data sharing, streams/tasks, and security features
  • Experience with data governance, data quality, and metadata management
  • Familiarity with cloud environments (Snowflake on AWS/Azure/Google Cloud Platform) and cloud storage integrations
  • Scripting experience (Python, Bash, or similar) for task automation
  • Excellent problem-solving, communication, and collaboration skills
  • Ability to work effectively in a remote or distributed team and align with US banking/regulatory workflows

Preferred Qualifications

  • SnowPro Core Certification or equivalent
  • Alteryx Designer Core/Advanced Certification; experience with Alteryx Server administration
  • Banking/financial services domain experience and knowledge of regulatory requirements
  • Experience with data lineage tools (e.g., Collibra, Alation) and data governance frameworks
  • Familiarity with orchestration tools (e.g., Apache Airflow) and ETL/ELT best practices
  • Knowledge of BI/analytics tools (Tableau, Power BI) and data visualization needs

Work Environment and Benefits

  • Remote-friendly role based in the United States; occasional travel or on-site attendance may be required for onboarding or team meetings
  • Competitive salary commensurate with experience
  • Comprehensive benefits package (health, dental, vision, retirement plans, paid time off, and more)
  • Opportunity to work with a stable, well-established bank that embraces modern data platforms
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.