What are the responsibilities and job description for the Snowflake Data Architect position at Smart IT Frame LLC?
Key Responsibilities:
- Design, implement, and manage the Snowflake data warehouse, including schema design, data models, and storage management.
- Develop and optimize ETL/ELT processes to ensure efficient data integration and transformation.
- Collaborate with data engineering and analytics teams to understand data requirements and provide best practices for data architecture.
- Create and maintain data pipelines, ensuring data quality, consistency, and security.
- Design and implement data governance and data security frameworks within Snowflake.
- Optimize Snowflake environment for performance, scalability, and cost efficiency.
- Conduct performance tuning, troubleshooting, and query optimization.
- Monitor and maintain data replication, backups, and disaster recovery plans.
- Stay up-to-date with the latest Snowflake features and releases, and recommend relevant upgrades or enhancements.
- Provide technical leadership and mentorship to junior team members.