Analytics Engineer

Penn Information Systems & Computing

. Design, build, and troubleshoot 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, advanced SQL, and Python for building and optimizing data pipelines and integrations. Proficient in implementing CI/CD practices and managing project milestones while translating business needs into technical solutions.

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 DevelopmentETL ProcessesDimensional Data ModelingData TransformationSystem IntegrationStored ProceduresUDFsData Mining

Soft Skills

Project ManagementCommunicationProblem-Solving

Tools & Technologies

SnowflakeSalesforceQlik CloudPosit ConnectAsanaJIRA

Certifications & Qualifications

SnowPro Core Certification

Industry Keywords

Higher EducationAdvancement LifecycleGift AccountingData AnalyticsAI-Driven Analytics

Tech Stack

Tools & technologies

CloudETLPythonSQL

About the role

Key responsibilities & impact

Design, build, and troubleshoot integrations and automated data pipelines between Snowflake, Salesforce, and external sources
Develop 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 fundraising tools and actionable insights
Establish Git code-management practices, branching strategies, pull requests, and documentation-as-code
Version, audit, and maintain recoverability of 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
Support fundraising and alumni-relations analytics for 18 schools and central Development and Alumni Relations staff
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/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 production system-to-system integration experience, including middleware/services for non-native integrations
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 Snowflake schema architecture 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 higher education Advancement lifecycle and gift accounting concepts preferred
Resume and cover letter required
Background check 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, museums, cultural and recreational activities
Discounts and special services for arts, entertainment, transportation, mortgages, goods, and services
Flexible work options and flexible work hours
Forgivable home ownership loan for eligible employees in West Philadelphia
Adoption assistance for qualified expenses, up to two adoptions in the household