Snowflake Advancement Intelligence Engineer

University of Pennsylvania

. Design, build, and troubleshoot system-to-system integrations and automated data pipelines between Snowflake, Salesforce, and external sources .

Posted 11/10/2026full-timePhiladelphia • Pennsylvania • United StatesMid-LevelSenior💰 $84,961 - $100,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data engineering with a strong focus on Snowflake, including advanced SQL proficiency and system-to-system integrations. Capable of implementing secure REST APIs, managing CI/CD processes, and optimizing data pipelines for analytics deployment.

Highest-signal resume keywords

Snowflake ExperienceAdvanced SQL FluencyPython ProficiencyGit Version ControlSnowPro Core Certification

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data EngineeringSQL QueriesREST API ImplementationETL ProcessesDimensional Data ModelingMiddleware DevelopmentData Pipeline OptimizationStored ProceduresUDFsData Transformation

Soft Skills

Project ManagementCommunicationRequirements GatheringProblem DiagnosisTechnical Support

Tools & Technologies

SnowflakeSalesforceQlik CloudPosit ConnectAsanaJIRACortex AI

Certifications & Qualifications

SnowPro Core Certification

Industry Keywords

Higher Education AdvancementGift AccountingData Security PoliciesPII HandlingAI-Driven Analytics

Tech Stack

Tools & technologies

CloudETLPythonSnowflakeSQL

About the role

Key responsibilities & impact

Design, build, and troubleshoot system-to-system integrations and automated data pipelines between Snowflake, Salesforce, and external sources
Implement REST API connections, secure authentication, and daily ETL processes with error logging
Develop and optimize complex SQL queries, views, and middleware
Design dimensional data models and transformation layers for strategic fundraising tools
Establish Git branching, pull request, documentation-as-code, versioning, auditing, and recovery practices
Implement CI/CD principles for reliable, tested, automated analytics deployment
Track project milestones, manage backlogs, and communicate project health
Gather requirements and translate business needs into technical specifications and timelines
Advise Development and Alumni Relations users on data solution planning, selection, and implementation
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
Monitor application health and provide technical support across Penn schools and centers
Monitor and optimize Snowflake Cortex AI credit consumption, set usage policies, and report AI workload costs
Define and enforce responsible LLM and Cortex AI guardrails, including data masking, PII handling, and output validation
Ensure AI pipelines and integrations comply with Penn data security policies, including secrets management, token rotation, and role-based access controls
Report directly to the Senior Director of Advancement Analytics

Requirements

What you’ll need

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
Minimum 3 years of recent, hands-on, production experience with Snowflake
Snowflake experience including warehouse sizing/cost management, RBAC, Streams & Tasks/Dynamic Tables, MERGE-based incremental loading, and stage-based ingestion of JSON, Parquet, and CSV
Advanced SQL fluency, including complex CTEs, window functions, MERGE, and CTAS
Experience designing dimensional/star-schema data models through reusable, production-grade views
Proficiency in Python for REST APIs, authentication and secrets, JSON transformation, and programmatic Snowflake connectivity
Demonstrated experience building and maintaining production system-to-system integrations and brokering middleware/services
Ability to diagnose failures across the stack, including IP allowlisting, network policies, and changing provider IP ranges
Proven experience with Git version control workflows
SnowPro Core Certification or higher strongly preferred
Experience with Salesforce NPSP and architecting its schemas within Snowflake preferred
Experience managing complex task dependencies in Asana or JIRA preferred
Experience writing stored procedures and UDFs preferred
Experience consuming Snowflake Marketplace data products and configuring Secure Data Shares preferred
Experience using LLMs for AI-driven text processing and analytics preferred
Familiarity with Snowflake Cortex AI functions and/or agent-building a plus
Proficiency in R or Python for data mining, statistical inference, and predictive modeling preferred
Understanding of the Higher Education Advancement lifecycle and gift accounting concepts preferred
Substantive, hands-on Snowflake experience
Applicants must be prepared to discuss Snowflake projects and integrations in detail and may complete a Snowflake SQL technical screening
Resume and cover letter required
Background checks may be required after a conditional job offer

Benefits

Comp & perks

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
Generous retirement plans, including Basic, Matching, and Supplemental plans
Substantial time away from work
Long-term care insurance
Wellness and work-life programs and resources
Professional and personal development resources
Access to University libraries, athletic facilities, arboretum, art galleries, cultural and recreational activities
Discounts and special services for arts, entertainment, transportation, mortgages, cars, cellular phone plans, movie tickets, and theme parks
Flexible work hours and work options
Forgivable home ownership loan for eligible employees in West Philadelphia
Adoption assistance for qualified expenses, up to two adoptions in the household