Partners Health Management is establishing a new Enterprise Data Ecosystem to modernize and unify their data platform capabilities.
Requirements
- Expert-level SQL with deep Snowflake-specific expertise in query optimization, performance tuning, and architecture.
- Strong understanding of data warehousing, ETL/ELT, and modern cloud data architectures.
- Strong knowledge of integrating Snowflake with BI platforms, and related tools.
- Proven track record of designing high-performance, cost-efficient data solutions.
- Hands-on experience with Snowpark, Snowflake tasks, streams, and time travel.
- Knowledge of event streaming platforms (Kafka, Event Hubs) is a plus.
- Strong leadership, problem-solving, and communication skills.
Responsibilities
- Architect, design, and implement advanced, enterprise-grade Snowflake data pipelines and integrations leveraging features such as tasks, streams, external tables, and secure data sharing.
- Lead Snowflake-centric data modeling (dimensional, data vault, and hybrid) to deliver high-performance, cost-optimized solutions.
- Design frameworks for real-time and batch data processing.
- Develop and implement a comprehensive analytics and reporting strategy aligned with Partners and NC DHHS goals and initiatives.
- Develop advanced transformation logic directly in Snowflake using SQL, Snowpark (Python or Scala), and stored procedures.
- Build and maintain reusable semantic models in Power BI for self-service analytics.
- Implement materialized views, clustering keys, and query optimization techniques for maximum performance.
Other
- Bachelor’s degree in Computer Science, Data Science, Engineering, or related field; or equivalent experience.
- 5+ years of experience in data engineering, with at least 3 years of direct Snowflake architecture and development experience.
- Proven track record of delivering enterprise-grade Snowflake solutions integrated with Azure.
- SnowPro Advanced Architect or SnowPro Core certification.
- Experience with Snowpark, Snowflake security administration, and advanced cost optimization techniques.
