Snowflake Architect

2 days ago

Erie, Pennsylvania, United States Match Point Solutions Full time
Job Overview

MatchPoint Solutions is a fast-growing, young, energetic global IT-Engineering services company with clients across the US. We provide technology solutions to various clients like Uber, Robinhood, Netflix, Airbnb, Google, Sephora, and more. Recently, we have expanded to working internationally in Canada, China, Ireland, UK, Brazil, and India. Through our culture of innovation, we inspire, build, and deliver business results, from idea to outcome. We keep our clients on the cutting edge of the latest technologies and provide solutions by using industry-specific best practices and expertise.

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.
  • Work with a global team (onsite & offshore model) and guide 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.