Data Architect _Snowflake (15+ Yrs Exp)

Prudent Technologies And Consulting - Dallas, TX

Full-time - Senior

Dallas, TX

Professional, Scientific, and Technical Services

About the position

The Data Architect position focuses on designing, developing, and maintaining scalable data pipelines using Snowflake and other ETL tools. The role requires extensive experience in data integration, database management, and collaboration with various stakeholders to ensure data accuracy and reliability. The architect will also be responsible for optimizing SQL queries and managing ETL processes to support data warehousing and analytics.

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

• 15+ years of experience in data architecture and pipeline development.
• 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.