What are the responsibilities and job description for the Data Architect (Snowflake) position at Triveni IT?
Job Summary
We are seeking a highly skilled Data Architect with extensive expertise in Snowflake for a part-time, short-term contract role. This position will focus on designing, building, and managing scalable data architectures for a specific project based in the Philadelphia area. The ideal candidate will have strong hands-on experience with Snowflake and be able to contribute to building innovative and high-performance data solutions. Please note that the first week of this role will require on-site presence, followed by a remote work setup.
Key Responsibilities
- Design and implement robust, scalable, and secure data architecture using Snowflake's cloud-based platform for a short-term project.
- Develop and optimize data models (conceptual, logical, and physical) to support project-specific analytics and reporting needs.
- Create and optimize ETL / ELT pipelines for ingesting, transforming, and loading data into Snowflake.
- Implement performance-tuning strategies to ensure efficient data processing, query performance, and cost optimization within Snowflake.
- Collaborate with project teams to integrate Snowflake with other data platforms, tools, and systems (e.g., AWS, Azure, GCP, Tableau, Power BI).
- Define and implement data governance, security policies, and compliance frameworks for data stored in Snowflake.
- Work closely with internal teams and stakeholders to ensure that data solutions meet project requirements.
- Oversee Snowflake accounts, monitor workloads, and troubleshoot any data-related issues that arise.
Required Skills and Qualifications