SNOWFLAKE DATA ARCHITECT

$176,800 - $187,200/Yr

BCforward - New York, NY

Full-time - Mid Level

Remote - New York, NY

5,001-10,000 employees

Professional, Scientific, and Technical Services

About the position

The Snowflake Data Architect position at BCforward involves leading the migration of data from Oracle to Snowflake, providing technical expertise throughout the implementation process, and optimizing data architecture for performance. This role requires collaboration with various stakeholders to ensure successful project delivery and continuous improvement of Snowflake's offerings.

Responsibilities

• Develop comprehensive migration plans tailored to customer needs, ensuring a smooth transition from Oracle to Snowflake.
• Act as the technical expert for all aspects of Snowflake during implementation, guiding customers through the migration process.
• Design and optimize Snowflake's logical, conceptual, and physical data models.
• Implement performance tuning and database optimization techniques to ensure efficient data processing.
• Work closely with customers, system integrators, and internal teams to understand requirements and deliver robust solutions.
• Create detailed documentation and presentations to share learnings and best practices.
• Collaborate with Product Management, Engineering, and Marketing to enhance Snowflake's products and services.

Requirements

• Minimum 5-8 years of experience in data management solutions, with hands-on experience in migrating databases.
• Proficiency in SQL, Unix Shell/Python scripting, and performance tuning.
• Experience with AWS/Azure and Snowflake's features like RBAC controls, scalable virtual warehouses, and cost optimization.
• Certified Snowflake Cloud Data Warehouse Architect (desirable).
• Strong problem-solving abilities and excellent communication skills.

Nice-to-haves

• Experience with data security and access controls in Snowflake.
• Expertise in integrating Snowflake with cloud platforms like AWS and Azure.

Benefits

• Major medical insurance
• Health Savings Account (HSA)
• Dental insurance
• Vision insurance
• Employer-provided group life insurance
• Voluntary life insurance
• Short-term disability
• Long-term disability
• 401k