Analytics Engineer at The University of Pennsylvania in FMC Tower-Development

Job description

University Overview The University of Pennsylvania, the largest private employer in Philadelphia, is a world-renowned leader in education, research, and innovation. This historic, Ivy League school consistently ranks among the top 10 universities in the annual U.S. News & World Report survey. Penn has 12 highly-regarded schools that provide opportunities for undergraduate, graduate and continuing education, all influenced by Penn’s distinctive interdisciplinary approach to scholarship and learning. As an employer Penn has been ranked nationally on many occasions with the most recent award from Forbes who named Penn one of America’s Best Large Employers in 2023. Penn offers a unique working environment within the city of Philadelphia. The University is situated on a beautiful urban campus, with easy access to a range of educational, cultural, and recreational activities. With its historical significance and landmarks, lively cultural offerings, and wide variety of atmospheres, Philadelphia is the perfect place to call home for work and play. The University offers a competitive benefits package that includes excellent healthcare and tuition benefits for employees and their families, generous retirement benefits, a wide variety of professional development opportunities, supportive work and family benefits, a wealth of health and wellness programs and resources, and much more. Posted Job Title Analytics Engineer Job Profile Title Application Developer Senior Job Description Summary Position Summary The Analytics Engineer is a technical architect within Advancement Prospect Analytics (APA), turning complex institutional data into actionable intelligence for fundraising and alumni relations. The role bridges raw data infrastructure and frontline fundraising strategy by designing, building, and maintaining data products on a modern cloud stack. The incumbent utilizes Snowflake for data warehousing and Salesforce NPSP for relationship management, engineering integrations that empower 18 schools and central DAR staff to identify and engage Penn's most impactful prospects. The role works across the full analytics workflow: Git for version control and peer review, Asana or JIRA for project tracking, and Qlik Cloud, Snowflake, and Posit Connect for deploying dashboards and predictive models that support the University's fundraising campaigns. This position reports directly to the Senior Director of Advancement Analytics in Development and Alumni Relations. Job Description Job Responsibilities Systems Architecture & Data Engineering Design, build, and troubleshoot system-to-system integrations and automated data pipelines between Snowflake, Salesforce, and external sources—including REST API–based connections, secure authentication (short-lived tokens, key-pair/OAuth), and daily ETL processes with error logging. Develop and optimize complex SQL queries, views, and middleware to ensure data integrity and high performance across the advancement ecosystem. Design dimensional data models and transformation layers that turn raw data into strategic fundraising tools and actionable insights. Development Workflow & Governance Establish and maintain best practices for code management in Git, including branching strategies, pull requests, and documentation-as-code. Ensure all analytical scripts (SQL, R, Python) are versioned, audited, and recoverable. Implement CI/CD principles for analytics to enable reliable, tested, automated deployment of data models. Project Management & Stakeholder Engagement Track project milestones, manage backlogs, and communicate project health. Coordinate requirements gathering for strategic initiatives, translating business needs into technical specifications and transparent timelines. Advise DAR users on the planning, selection, and implementation of data solutions to address specific business requirements. Advanced Analytics & AI Deploy and maintain visualization tools and statistical environments across Qlik Cloud, Sn