Analytics Engineer

University of Pennsylvania

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

Posted 9/28/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, SQL, and Python for building and optimizing data pipelines and integrations. Proficient in implementing CI/CD principles and managing project milestones while translating business needs into technical specifications.

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 TransformationStored ProceduresUDFsData Mining

Soft Skills

Project ManagementCommunicationRequirements GatheringProblem DiagnosisTechnical Support

Tools & Technologies

SnowflakeSalesforceQlik CloudPosit ConnectAsanaJIRA

Certifications & Qualifications

SnowPro Core Certification

Industry Keywords

Higher Education AdvancementGift AccountingData EngineeringSystems AnalysisAI-Driven Analytics

Tech Stack

Tools & technologies

CloudETLPythonSQL

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-based 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 and actionable insights
Establish Git code-management practices, including branching strategies, pull requests, and documentation-as-code
Ensure SQL, R, and Python analytical scripts are versioned, audited, and recoverable
Implement CI/CD principles for reliable, tested, automated deployment of data models
Track project milestones, manage backlogs, and communicate project health
Coordinate requirements gathering 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
Report directly to the Senior Director of Advancement Analytics in Development and Alumni Relations

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, structured/semi-structured data 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 with 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 preferred
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
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
Tuition assistance for dependent children at other institutions
Basic, Matching, and Supplemental retirement 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 programs and resources
Professional and personal development resources
Access to University libraries, athletic facilities, arboretum, art galleries, cultural and recreational activities
Discounts on arts, entertainment, transportation, mortgages, cars, cellular phone plans, movie tickets, and theme parks
Flexible work options, including non-traditional work hours, locations, and/or job structures
Forgivable home ownership loan for eligible employees in West Philadelphia
Adoption assistance for qualified expenses, up to two adoptions in the household