Snowflake Advancement Intelligence Engineer

University of Pennsylvania
•$84,961 - $100,000

About The Position

The Snowflake Advancement Intelligence Engineer is a technical architect within Advancement Prospect Analytics (APA), responsible for turning institutional data into actionable intelligence for fundraising and alumni relations. The role designs, builds, and maintains data products on a modern cloud stack, bridging data infrastructure with frontline fundraising strategy. It uses Snowflake for data warehousing and Salesforce NPSP for relationship management, and engineers integrations that support 18 schools and central Development and Alumni Relations (DAR) staff in identifying and engaging prospects. The role works across the analytics workflow using Git for version control and peer review, Asana or JIRA for project tracking, and Qlik Cloud, Snowflake, and Posit Connect for deploying dashboards and predictive models. The position reports directly to the Senior Director of Advancement Analytics in Development and Alumni Relations. Responsibilities include building and troubleshooting integrations and automated data pipelines; developing SQL, data models, and transformation layers; maintaining code management, versioning, auditability, and CI/CD practices; coordinating requirements and project tracking; advising DAR users on data solutions; deploying and supporting visualization and statistical environments; using Snowflake Cortex AI; and overseeing AI cost, governance, and security. The role requires substantive hands-on Snowflake experience and may include a Snowflake SQL technical screening as part of the interview process. Applicants should provide a resume and cover letter with their application.

Requirements

  • Bachelor's degree and 3–5 years of experience in data engineering, systems analysis, or a related technical field, or an equivalent combination of education and experience.
  • At least 3 years of recent, hands-on production experience with Snowflake, including warehouse sizing and cost management, RBAC, Streams & Tasks or Dynamic Tables, MERGE-based incremental loading, and stage-based ingestion of semi-structured data such as JSON, Parquet, or CSV.
  • Advanced SQL fluency, including complex CTEs, window functions, MERGE, and CTAS, and experience designing dimensional or star-schema data models through reusable, production-grade views.
  • Proficiency in Python for consuming REST APIs, handling authentication and secrets, parsing and transforming structured or semi-structured data, and connecting programmatically to Snowflake.
  • Demonstrated experience building and maintaining production system-to-system integrations, including middleware or services that connect systems without native integration capabilities.
  • Ability to independently diagnose failures across the integration stack, including network-layer issues such as IP allowlisting, network policies, and changing provider IP ranges.
  • Proven experience with Git version control workflows.

Nice To Haves

  • SnowPro Core Certification or higher; candidates without a current certification should be prepared to demonstrate equivalent hands-on Snowflake expertise.
  • Experience with Salesforce NPSP and architecting its schemas within a Snowflake environment.
  • Experience managing complex task dependencies in Asana or JIRA.
  • Experience writing stored procedures in SQL, JavaScript, or Python and UDFs for procedural data transformation logic.
  • Experience consuming Snowflake Marketplace data products and configuring inbound or outbound Secure Data Shares.
  • Experience using LLMs, including OpenAI, Anthropic, or open-source equivalents, for AI-driven text processing and analytics; familiarity with Snowflake Cortex AI functions or agent-building is a plus.
  • Proficiency in R or Python for data mining, statistical inference, and predictive modeling.
  • Understanding of the higher-education advancement lifecycle, including prospect pipeline management, annual giving, and major gifts, along with gift accounting concepts such as hard versus soft credit and recognition types.

Responsibilities

  • Design, build, and troubleshoot system-to-system integrations and automated data pipelines between Snowflake, Salesforce, and external sources, including REST API connections, secure authentication, and daily ETL processes with error logging.
  • Develop and optimize complex SQL queries, views, and middleware to ensure data integrity and performance across the advancement ecosystem.
  • Design dimensional data models and transformation layers that turn raw data into fundraising tools and actionable insights.
  • Establish and maintain Git code-management practices, including branching strategies, pull requests, and documentation-as-code.
  • Ensure analytical scripts in SQL, R, and Python are versioned, audited, and recoverable.
  • Implement CI/CD principles for analytics to support reliable, tested, automated deployment of data models.
  • Track project milestones, manage backlogs, and communicate project health.
  • Coordinate requirements gathering for strategic initiatives and translate business needs into technical specifications and transparent timelines.
  • Advise DAR users on planning, selecting, and implementing data solutions for business requirements.
  • Deploy and maintain visualization tools and statistical environments across Qlik Cloud, Snowflake, and Posit Connect.
  • Leverage Snowflake Cortex AI for data engineering and AI-driven analytics tasks.
  • Monitor application health and provide technical support to users across Penn schools and centers.
  • Monitor and optimize Snowflake Cortex AI credit consumption, set usage policies, and report AI workload costs to leadership.
  • Define and enforce responsible-use standards for LLMs and Cortex AI functions, including data masking, PII handling, and output validation before deployment.
  • Ensure AI-driven pipelines and integrations comply with Penn data security policies, including secrets management, token rotation, and role-based access controls for AI services.

Benefits

  • Comprehensive medical, prescription, behavioral health, dental, vision, and life insurance benefits.
  • Flexible spending accounts for eligible health care and dependent care expenses.
  • Tuition assistance for employees, spouses, and dependent children at Penn; dependent children may also receive assistance at other institutions.
  • Basic, matching, and supplemental retirement plans, with pre-tax or Roth savings options and investment options through TIAA and Vanguard.
  • Substantial time away from work during the year.
  • Long-term care insurance for eligible employees and family members.
  • Wellness and work-life programs and resources.
  • Professional and personal development resources.
  • Access to University resources, including libraries, athletic facilities, cultural and recreational activities.
  • Discounts and special services, including arts and entertainment, transportation, mortgages, and other goods and services.
  • Flexible work options and work hours.
  • Forgivable home-ownership loan for eligible employees buying a home or currently residing in West Philadelphia, usable for closing costs or home improvements.
  • Adoption assistance reimbursement for eligible qualified expenses, for up to two adoptions in the household.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service