Snowflake Developer

Job Title: Snowflake Developer

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.

Remote Work & Interview

Location: 100% Remote.
Interview required: Video.
Visa: No Opt.
Client is flexible on rate.

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/GCP) 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.

Please make sure that each submittal includes:

1. Driver’s license or State ID.
2. Link to the candidate’s LinkedIn account.
3. You must follow the submittal format provided below.

Candidate Must Have’s on a resume and for submittal:

1. How many years working with Snowflake Developer.
2. How many years working with Alteryx.
3. How many years working with SQL.
4. How many years working with (unspecified).
5. How many years working with (unspecified).

Please provide all the below Submittal Format details with each submittal. It is required for the client Management system.

• Full Name.
• Rate.
• Location.
• Availability to Interview: One Day’s notice.
• Availability to Start.
• Email Address.
• Phone Number.
• Visa Status.
• Education – College/Year of graduation.
• Link to LinkedIn.
• Certifications (Please list).

#J-18808-Ljbffr