What are the responsibilities and job description for the Snowflake Architect position at Teksky LLC?
Title : Snowflake Architect
Location: Pittsburg, PA – Hybrid
Long Term
Job Overview:
We are seeking an experienced Snowflake Tech Lead/Architect to join our team. The ideal candidate will have a solid background in data architecture, cloud data warehousing, and analytics. As a Snowflake Tech Lead, you will be responsible for leading the design, development, and implementation of data solutions using Snowflake. You will collaborate closely with cross-functional teams to ensure data solutions are accurate, accessible, and secure.
Key Responsibilities:
- Lead the design and implementation of Snowflake solutions to meet business requirements.
- Collaborate with business stakeholders, data engineers, and analysts to gather requirements, ensuring data quality and integrity.
- Lead the development and maintenance of data models and pipelines using Snowflake.
- Manage diverse data sets (XML, JSON, CSV) from disparate sources.
- Optimize Snowflake performance, including query tuning and storage optimization.
- Manage and mentor a team of data professionals in Snowflake best practices.
- Develop and maintain ETL processes to integrate data from various sources.
- Monitor and troubleshoot data issues and implement solutions.
- Research and develop POCs to demonstrate business capabilities using Snowflake.
- Working with global team (onsite & offshore model) and guiding both shores to successfully drive the project/program.
- Stay updated with industry trends and advancements in Snowflake and related technologies.
Qualifications:
- 12 years of experience in data engineering, data warehousing, or related roles.
- Strong expertise in Snowflake architecture, SQL, and data modeling.
- Experience with ETL tools (Informatica) and data integration methodologies.
- Solid understanding of data warehousing concepts, metadata management, data lakes, and multi-dimensional models.
- Familiarity with AWS cloud platforms and data pipeline orchestration tools (e.g., Apache Airflow).
- Excellent problem-solving skills and attention to detail.
- Strong communication and leadership skills, with the ability to work collaboratively across teams.
Preferred Qualifications:
- Snowflake (SnowPro Core or higher) & AWS Cloud certification (CCP or higher)
- Experience with data visualization tools (e.g., Qlik, SAS) is an advantage.
- Knowledge of programming languages such as Python, Java, or Scala.
- Having experience in insurance domain is an advantage.
- Experience in Agile/Scrum methodologies.
