University of Pennsylvania · 20 hours ago
Analytics Engineer
Philadelphia, PA
Full-time
Onsite
Mid, Senior Level
$84K/yr - $95K/yr
3+ years expThe University of Pennsylvania is a prestigious Ivy League institution known for its leadership in education and research. The Analytics Engineer will play a crucial role in transforming complex data into actionable insights to support fundraising strategies, focusing on data integration and management within a cloud-based environment.
EducationContinuing EducationEdTechSTEM EducationUniversities
Responsibilities
Lead the design and implementation of scalable, automated data pipelines between Snowflake, Salesforce, and external data sources
Develop and optimize complex SQL queries, views, and associated middleware to ensure data integrity and high performance across the advancement ecosystem
Architect data models and transformation layers that translate raw data into strategic fundraising tools and actionable insights
Establish and maintain best practices for code management using GitHub, including branching strategies, pull requests, and documentation-as-code
Ensure all analytical scripts (SQL, R, Python) are versioned, audited, and recoverable
Implement CI/CD (Continuous Integration/Continuous Deployment) principles for analytics to ensure reliable, tested, and automated deployment of data models
Act as a technical project lead by utilizing Asana and/or JIRA to track milestones, manage backlogs, and communicate project health
Coordinate requirements gathering for long-term strategic initiatives, translating complex business needs into technical specifications and transparent project timelines
Advise DAR users on the planning, selection, and implementation of data solutions to address specific business requirements
Maintain deployment of visualization tools and statistical environments in Qlik, Snowflake and Posit. Leverage LLMs (proprietary or open-source) for text processing, such as analyzing donor contact reports or automating prospect bios
Monitor application health and provide high-level technical support to users across 18 University schools and centers
Qualification
Required
Bachelor of Science and 3 to 5 years of experience data engineering, systems analysis, or a related technical field or equivalent combination of education and experience is required
Demonstrated proficiency in Snowflake SQL and advanced relational data modeling
Proven experience with Git/Version Control workflows and managing complex task dependencies in Asana or JIRA
Preferred
Experience with Salesforce NPSP (Non-Profit Success Pack) and architecting schemas specifically within a Snowflake environment
Experience using LLMs (OpenAI, Anthropic, or open-source equivalents) for AI-driven text processing and analytics
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
Benefits
Health, Life, and Flexible Spending Accounts: Penn offers comprehensive medical, prescription, behavioral health, dental, vision, and life insurance benefits to protect you and your family’s health and welfare. You can also use flexible spending accounts to pay for eligible health care and dependent care expenses with pre-tax dollars.
Tuition: Take advantage of Penn's exceptional tuition benefits. You, your spouse, and your dependent children can get tuition assistance here at Penn. Your dependent children are also eligible for tuition assistance at other institutions.
Retirement: Penn offers generous retirement plans to help you save for your future. Penn’s Basic, Matching, and Supplemental retirement plans allow you to save for retirement on a pre-tax or Roth basis. Choose from a wide variety of investment options through TIAA and Vanguard.
Time Away from Work: Penn provides you with a substantial amount of time away from work during the course of the year. This allows you to relax, take vacations, attend to personal affairs, recover from illness or injury, spend time with family—whatever your personal needs may be.
Long-Term Care Insurance: In partnership with Genworth Financial, Penn offers faculty and staff (and your eligible family members) long-term care insurance to help you cover some of the costs of long-term care services received at home, in the community or in a nursing facility. If you apply when you’re newly hired, you won’t have to provide proof of good health or be subject to underwriting requirements. Eligible family members must always provide proof of good health and are subject to underwriting.
Wellness and Work-life Resources: Penn is committed to supporting our faculty and staff as they balance the competing demands of work and personal life. That’s why we offer a wide variety of programs and resources to help you care for your health, your family, and your work-life balance.
Professional and Personal Development: Penn provides an array of resources to help you advance yourself personally and professionally.
University Resources: As a member of the Penn community, you have access to a wide range of University resources as well as cultural and recreational activities. Take advantage of the University’s libraries and athletic facilities, or visit our arboretum and art galleries. There’s always something going on at Penn, whether it’s a new exhibit at the Penn Museum, the latest music or theater presentation at the Annenberg Center, or the Penn Relays at Franklin Field to name just a few examples. As a member of the Penn community, you’re right in the middle of the excitement—and you and your family can enjoy many of these activities for free.
Discounts and Special Services: From arts and entertainment to transportation and mortgages, you'll find great deals for University faculty and staff. Not only do Penn arts and cultural centers and museums offer free and discounted admission and memberships to faculty and staff. You can also enjoy substantial savings on other goods and services such as new cars from Ford and General Motors, cellular phone service plans, movie tickets, and admission to theme parks.
Flexible Work Hours: Flexible work options offer creative approaches for completing work while promoting balance between work and personal commitments. These approaches involve use of non-traditional work hours, locations, and/or job structures.
Penn Home Ownership Services: Penn offers a forgivable loan for eligible employees interested in buying a home or currently residing in West Philadelphia, which can be used for closing costs or home improvements.
Adoption Assistance: Penn will reimburse eligible employees on qualified expenses in connection with the legal adoption of an eligible child, such as travel or court fees, for up to two adoptions in your household.
Company
University of Pennsylvania
The University of Pennsylvania is an American private Ivy League Research University that excels in producing future leaders.
10001+ employees
H1B Sponsorship
University of Pennsylvania has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7)
2024 (3)
2023 (2)
2022 (3)
2021 (5)
2020 (6)
Funding
Current Stage
Late StageTotal Funding
$81.46MKey Investors
National Science FoundationUS Department of EnergyParent Project Muscular Dystrophy
2024-08-28Grant
2023-06-26Grant· $18M
2022-09-15Grant· $55M
Leadership Team
Mark Dingfield
Executive Vice President
Angela Duckworth
Rosa Lee and Egbert Chang Professor
Recent News
The Philadelphia Inquirer
2026-02-04
The Philadelphia Inquirer
2026-02-04
The Philadelphia Inquirer
2026-01-22
Company data provided by crunchbase