IT Project Leader Sr. Data Engineer, Wharton Computing (Hybrid-Eligible)

IT Project Leader Sr. Data Engineer, Wharton Computing (Hybrid-Eligible)

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 Employers By State in 2021.

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.

COVID-19 vaccination is a requirement for all positions at the University of Pennsylvania. New hires are expected to be fully vaccinated before beginning work at the University. For more information about Penn's vaccine requirements, visit the Penn COVID-19 Response website for the latest information.

Posted Job Title
IT Project Leader Sr. Data Engineer, Wharton Computing (Hybrid-Eligible)

Job Profile Title
Information Technology Project Leader Senior

Job Description Summary
The Analytics team is responsible for providing the business units of the School with data and decision-making tools to support and enhance on-going business operations. Reporting to the Director of Analytics, this position will be responsible for the planning, development, monitoring, and ongoing maintenance of data pipelines, data lakes, and the data warehouse, and for the support of analytics, reporting, and BI tools for the various business units, providing easily accessible and usable data brought together from disparate sources. This position will work directly with departmental analysts and data scientists to plan, execute, evaluate, and refine large and multiple simultaneous data projects involving analytics requirements gathering, data models, and pipelines to deliver both targeted and enterprise solutions. This position will design databases and data lakes, build pipeline processes using ETL tools, APIs, and other automation tools, monitor and maintain the former, and tune databases for efficient analysis. Will review, develop, or recommend modification of procedures to solve complex problems, taking into consideration cloud-based offerings and costs. Will ensure adherence to departmental technical, quality assurance, and security standards. Will create documentation and assist with end-user training.

Job Description

Job Responsibilities

We are looking for a Senior IT Project Leader to join the Wharton team! The Research & Analytics team is responsible for providing the business units of the School with data and decision-making tools to support and enhance ongoing business operations. Reporting to the Director of Analytics, you will be responsible for the planning, development, and ongoing maintenance of data pipelines, data lakes, and data warehouses across multiple projects and business units. You will also develop and support various reporting and BI tools for a wide array of end users, providing them with easily-accessible and usable data combined from disparate sources. You will work directly with departmental analysts and data scientists to plan, execute, evaluate, and refine multiple simultaneous data projects involving analytics, data modeling, and pipeline requirements to deliver both targeted and enterprise solutions. You will design databases and data lakes, build pipeline processes using ETL tools, APIs, and other automation tools, monitor and maintain the former, and tune databases for efficient analysis. You will review, develop, or recommend modification of procedures to solve complex problems, taking into consideration cloud-based offerings and costs. You will ensure adherence to technical, quality assurance, and security standards, create documentation and assist with end-user training.

This position requires a devotion to teamwork, an eagerness to learn about different domains, the ability to be successful working independently, and a passion for data! As you will be required to work directly with end users and clients, you must have excellent customer service and communication skills. We welcome applicants with database experience in any relational database. Data warehouse, AWS/cloud, and visualization experience a plus.

Qualifications

• BA/BS in Computer Science or related discipline and 5 years relevant work experience required or equivalent combination of education and experience
• Strong knowledge of relational database design and SQL required
• Experience with Python and data-related Python libraries (Pandas, Requests, JSON, etc.) required
• Experience working with/ingesting data from REST APIs required
• Knowledge of data models and structures and various file types (JSON, CSV, Parquet)
• Demonstrated project management experience for large and multiple simultaneous projects required
• Recent demonstrated experience in needs assessment required
• Creative problem-solving skills required
• Strong analytical skills required
• Ability to communicate clearly and concisely required
• Demonstrated ability to learn new skills both technical and non-technical and the desire to continue doing so required
• Demonstrated ability to multi-task and work effectively within tight turnaround schedules required
• Excellent verbal and written communication skills, especially client communication, and interpersonal skills required
• Experience with technical writing required

Preferred for all candidates:

• Experience with AWS tools (Redshift, Redshift Spectrum, S3, Lambda, IAM, Athena, Glue, Boto3) and Terraform or other automation techniques is strongly preferred
• Understanding data warehouses and data lakes is strongly preferred
• Experience with an ETL tool such as Informatica is strongly preferred
• Experience with programming patterns and principles, advanced SQL, version control
• Ability to work under tight timelines while juggling multiple priorities
• Knowledge of machine learning and/or NLP programming techniques
• Systems administration and Linux experience
• Experience with visualization tools and techniques a plus, especially Power BI
• Polyglot programming skills

Job Location - City, State
Philadelphia, Pennsylvania
Hybrid Eligible - This position is eligible for a hybrid work schedule with a work week divided between working onsite and working remotely.

Department / School
Wharton School

Pay Range
$74,476.00 - $162,146.00
Salary offers are made based on the candidate's qualifications, experience, skills, and education as they directly relate to the requirements of the position, as well as internal and market factors and grade profile.

Affirmative Action Statement
Penn adheres to a policy that prohibits discrimination on the basis of race, color, sex, sexual orientation, gender identity, religion, creed, national or ethnic origin, citizenship status, age, disability, veteran status, or any other legally protected class.

Special Requirements
Background check required after a conditional job offer is made. Consideration of the background check will be tailored to the requirements of the job.

University 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.
  

​

To learn more, please visit: https://www.hr.upenn.edu/PennHR/benefits-pay


To apply, visit https://wd1.myworkdaysite.com/en-US/recruiting/upenn/careers-at-penn/job/Tangen-Hall---6th-Floor/IT-Project-Leader-Sr-Data-Engineer--Wharton-Computing--Hybrid-Eligible-_JR00067005



jeid-7799e96c99bfc34a9a3c76f1dc0b2641