Snowflake Advancement Intelligence Engineer

Penn Information Systems & Computing

. Design, build, and troubleshoot 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 REST API development. Capable of designing and optimizing data models, managing integrations, and ensuring compliance with data security policies.

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 DevelopmentREST API DevelopmentETL ProcessesDimensional Data ModelingData Pipeline AutomationData TransformationMiddleware IntegrationAI-Driven AnalyticsData Security Compliance

Soft Skills

Project ManagementCommunicationProblem-SolvingRequirements GatheringTechnical Support

Tools & Technologies

SnowflakeSalesforceQlik CloudPosit ConnectAsanaJIRAGitLLMsCortex AIJSON

Certifications & Qualifications

SnowPro Core Certification

Industry Keywords

Higher Education AdvancementGift AccountingData Security PoliciesProduction SystemsData Integration

Tech Stack

Tools & technologies

CloudETLJavaScriptPythonSnowflakeSQL

About the role

Key responsibilities & impact

Design, build, and troubleshoot integrations and automated data pipelines between Snowflake, Salesforce, and external sources
Develop REST API-based connections with secure authentication, including short-lived tokens and key-pair/OAuth
Maintain daily ETL processes with error logging
Develop and optimize complex SQL queries, views, and middleware
Design dimensional data models and transformation layers for fundraising tools and actionable insights
Establish Git code-management practices, including branching, pull requests, and documentation-as-code
Version, audit, and recover SQL, R, and Python analytical scripts
Implement CI/CD principles for reliable, tested, automated deployment of data models
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 and report AI workload costs to leadership
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
Manage secrets, token rotation, and role-based access controls for AI services
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 API consumption, authentication and secrets, JSON processing, structured/semi-structured data transformation, and programmatic Snowflake connectivity
Production system-to-system integration experience, including brokering middleware or 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 SQL, JavaScript, or Python 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
Resume and cover letter required
Applicants should be prepared to discuss specific Snowflake projects and integrations and may complete a Snowflake SQL technical screening

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
Retirement plans, including Basic, Matching, and Supplemental plans
Pre-tax or Roth retirement savings options
Investment options through TIAA and Vanguard
Substantial time away from work
Long-term care insurance
Wellness and work-life resources
Professional and personal development resources
Access to University libraries, athletic facilities, arboretum, art galleries, and cultural and recreational activities
Discounts and special services
Flexible work options and flexible work hours
Forgivable home ownership loan for eligible employees in West Philadelphia
Adoption assistance for qualified expenses
Potentially required background check after a conditional offer