Business Intelligence Developer

University of Pennsylvania

About The Position

provide critical support and technical guidance to the Perelman School of Medicine in data analysis, reporting, and visualization. They will work closely with UPHS IT and PSOM Applications Development teams to ensure dashboard development and maintenance coordination. This position will report to the Senior IT Project Leader for dashboard development.

Requirements

Bachelor’s Degree, preferably in an analytical discipline and 2 to 3 years of experience in database management, development, or analysis or an equivalent combination of education and experience required.
Knowledge of Microsoft PowerBI, Access, Excel, and large data warehouses is needed.
Experience using warehouse data querying tools (Webi, Deski) and other data visualization tools (Tableau, Qlikview, others) is highly desirable.
Excellent analytical and communication skills.
Ability to work independently and with teams.
Ability to work on multiple projects simultaneously.
Experience with databases and query languages such as MSSQL, Oracle, T-SQL, or PL/SQL.
Experience in report designing, development, and deployment.
Experience in data analysis.
Experience in general reporting methodologies, including but not limited to charts, scheduled delivery of reports, ad-hoc execution of reports, metadata, and drill-downs/throughs.
Knowledge of data warehousing and data presentation techniques.
Experience in producing documentation and organizing training and education.
Must possess strong written and verbal communication skills in English.
Strong analytical, organizational, problem-solving, excellent communication, and customer service skills are required.
Ability to work independently.
Ability to interact with all levels of health system personnel, including IT management, consulting staff, clinicians, hospital administrators, etc.
Ability to prioritize developmental and operational tasks.

Nice To Haves

Prior financial analysis experience and knowledge of financial systems are desirable.
Experience using warehouse data querying tools (Webi, Deski) and other data visualization tools (Tableau, Qlikview, others) is highly desirable.

Responsibilities

Serve as a School-wide resource for reporting and dashboard development.
Provide technical and functional support for departments wanting to develop specialized dashboards.
Maintain existing School dashboards that cover all areas of the School’s operations, financial activity, and related metrics.
Work with School leadership to identify and develop metrics for all aspects of School operations and missions, transactional, strategic, and projections.
Support the development of critical metrics the highest-level leadership uses for strategic planning and budgeting.
Work with systems developers to develop new dashboards and implement other tools to disseminate reports and metrics to users.
Continually assess emerging technology and create new visualizations and other tools.
Develop templates and create “approved” and curated datasets for use by all PSOM PowerBI developers at both the School-wide and departmental levels.
Streamline and improve the security model in both existing and future PowerBI reports.
Develop and maintain an understanding of the data sources used across School activities (e.g., faculty, staff, students, finance, space, research, education, compliance, and other operational and strategic areas) to support reporting, dashboard development, and user needs.
As assigned, represent the School on University application/warehouse development teams.
Ensure that the School’s needs are addressed in the resulting applications and warehouses.

Benefits

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.
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.
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.
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.
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.
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.
Penn provides an array of resources to help you advance yourself personally and professionally.
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.
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 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 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.
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.