Snowflake Data Architect _Onsite Role

Prudent Technologies And Consulting - Richardson, TX

Full-time - Mid Level

Richardson, TX

Professional, Scientific, and Technical Services

About the position

The Senior Snowflake Data Architect role is a long-term contract position focused on designing, developing, and maintaining scalable data pipelines and managing databases. This position requires a strong technical background in Snowflake and related technologies, as well as collaboration with various stakeholders to ensure data integrity and efficiency.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, DBT, Snaplogic, and ETL tools.
• Write and optimize complex SQL queries to ensure high performance and efficiency.
• Integrate data from various sources, ensuring consistency, accuracy, and reliability.
• Manage and maintain SQL Server and PostgreSQL databases.
• Develop and manage ETL processes to support data warehousing and analytics.
• Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and deliver solutions.
• Maintain comprehensive documentation of data models, data flows, and ETL processes.
• Identify and resolve data-related issues and discrepancies.
• Utilize Python for data manipulation, automation, and integration tasks.

Requirements

• Proficiency in Snowflake, DBT, Snaplogic, SQL Server, PostgreSQL, and Azure Data Factory.
• Strong SQL skills with the ability to write and optimize complex queries.
• Knowledge of Python for data manipulation and automation.
• Knowledge of data governance frameworks and best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.

Nice-to-haves

• Relevant certifications (e.g., Snowflake, Azure) are a plus.