"Business Intelligence Developer"

Job Details

Business Intelligence Developer
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 Business Intelligence Developer Job Profile Title Information Technology Project Leader Job Description Summary 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. Job Description Job Responsibilities

• Serve as a School-wide resource for reporting and dashboard development. Provide technical and functional support for departments wanting to develop specialized dashboards.
• The qualified individual will 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.

Qualifications

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

Job Location - City, State Philadelphia, Pennsylvania Department / School Perelman School of Medicine Pay Range $70,500.00 - $100,000.00 Annual Rate Salary offers are made based on the candidate's qualifications, experience, skills, and education as they directly relate to the requirements of the position, and in alignment with salary ranges based on external market data for the job's level. Internal organization and peer data at Penn are also considered. Special Requirements Background checks may be 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: ...
• Tuition: ...
• Retirement: ...
• Time Away from Work: ...
• Long-Term Care Insurance: ...
• Wellness and Work-life Resources: ...
• Professional and Personal Development: ...
• University Resources: ...
• Discounts and Special Services: ...
• Flexible Work Hours: ...
• Penn Home Ownership Services: ...
• Adoption Assistance: ...