What are the responsibilities and job description for the Data Architect || Richardson, TX *(Onsite) | *LOCALS only || W2 hire - No C.2.C | (**No E.A.D, H 1) position at Prudent Technologies and Consulting, Inc.?
Role: Data Architect -
Location: Richardson, TX **(100% Onsite)
Duration: Long Term
We are seeking a highly skilled Data Architect with extensive experience in Snowflake, Data Build Tool (dbt), Snaplogic, SQL Server, PostgreSQL, Azure Data Factory, and other ETL tools. The ideal candidate will have a strong ability to optimize SQL queries and a good working knowledge of Python. A positive attitude and excellent teamwork skills are essential.
Key Responsibilities:
Data Pipeline Development: Design, develop, and maintain scalable data pipelines using Snowflake, DBT, Snaplogic, and ETL tools.
SQL Optimization: Write and optimize complex SQL queries to ensure high performance and efficiency.
Data Integration: Integrate data from various sources, ensuring consistency, accuracy, and reliability.
Database Management: Manage and maintain SQL Server and PostgreSQL databases.
ETL Processes: Develop and manage ETL processes to support data warehousing and analytics.
Collaboration: Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and deliver solutions.
Documentation: Maintain comprehensive documentation of data models, data flows, and ETL processes.
Troubleshooting: Identify and resolve data-related issues and discrepancies.
Python Scripting: Utilize Python for data manipulation, automation, and integration tasks.
