Data Architect

Snowflake Architect

Location: ERIE PA (Onsite)

Duration: 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:

• 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.