Data Architect

Snowflake ArchitectLocation: ERIE PA (Onsite)Duration: Long termJob 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:15+ 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.