Skip to main content

This job has expired

Business Intelligence Analyst

Employer
Community College of Philadelphia
Location
Main Campus

Job Details

Position Title:

Business Intelligence Analyst

Requisition Number:

SCA00512

General Description:

The Business Intelligence Analyst is responsible for analyzing, developing and enhancing the operation of all aspects of a college-wide data lake and business intelligence support. The primary role is to assemble and transform data into actionable knowledge for the use of college leaders and administrators including: executive level reports and dashboards; designing, building, and normalizing data and data bases and locating and extracting data from the College’s enterprise systems and other internal and external data resources. The Business Intelligence Analyst is responsible for creating, implementing and maintaining data lakes and business intelligence applications and databases.

Specific Responsibilities:

• Prepares reporting, analytics, and dashboard development from concept to implementation.

• Analyzes, develops and interprets data needs for end users.

• Assists in development, implementation, and maintenance of the enterprise-wide systems and data warehouse solutions.

• Serves as a resource to all levels of management for reviewing, analyzing, designing/creating, and implementing institutional reports, dashboards and data warehouse solutions.

• Provides training and documentation on reporting systems and solutions as needed for all levels of staff.

• Understands conceptual and physical data models using relational and dimensional data modeling techniques.

• Maintains system storage structures for warehousing system needed for reporting solutions.

• Deliver quality customer services to both internal and external constituents in a professional, helpful and courteous manner.

• Performs other duties as assigned.

Minimum Qualifications:

• Bachelor’s degree is required.

• A minimum of 5 years in a higher education administrative environment.

• A minimum of 5 years performing data analytics and data science solutions.

• A minimum of 5 years work-related database management and developing reporting solution experience required.

• A minimum of 5 years developing business intelligence solutions and an understanding of key concepts in higher education derived from databases and/or data lake applications required.

• Knowledge of relational database management systems and concepts and experience with Oracle (9i or higher) database, and SQL required.

• Experience in report development using Argos, Tableau and reporting tools in a higher education environment required.

• Ability to carry out assigned responsibilities with minimal supervision required.

• Ability to efficiently and professionally communicate with client personnel and co-workers required.

• Ability to maintain sensitivity, understanding and respect for a diverse academic environment, inclusive of students, faculty, and staff of varying social, economic, cultural, ideological, and ethnic backgrounds required.

Preferred Qualifications:

• Master’s degree is preferred. Any and all must be from a recognized institutional accreditor.

• Extensive experience in Ellucian’s suite of products preferred.

• Knowledge and/or experience with PL/SQL, HTML, XML, and Java preferred.

• Knowledge of data modeling, star schema, and denormalized data models preferred.

• Experience with Ellucian’s Banner system, Operational Data Store or Enterprise Data Warehouse and Amazon Web Services preferred.

Work Location:

Main Campus

Special Instructions to Applicants:

All College employees must be fully vaccinated, or have an approved exemption from the College and submit to regular COVID testing as an accommodation.

Interested persons should complete an online application

Cover letter of interest and resume REQUIRED

Names and contact information of 3 professional references OPTIONAL

Review of applications will commence on January 6, 2021 and will continue until the position is filled.

Applicants must be legally eligible to work in the U.S. Community College of Philadelphia is an Affirmative Action, Equal Opportunity and Equal Access Employer. The College encourages applications from individuals from traditionally underrepresented groups.

Salary Grade or Rank:

3

Salary Range:

Salary commensurate with relevant work experience

Job Posting Open Date:

12/16/2021

Type of Position:

Administrator

Employment Status :

Full-Time

Organization

Working at Community College of Philadelphia

Welcome to Community College of Philadelphia, a public, open-admission institution that provides both academic resources and support services to help students achieve their academic goals. As the largest public institution of higher education in Philadelphia, the College has served more than 685,000 of the city's residents since 1965. We serve a diverse population of students, from recent high school graduates starting here on their path to a bachelor's degree, to adults looking to change careers. On our Main Campus or at any of our three Regional Centers within Philadelphia, we offer the convenience our students need to fit classes into their busy schedules.

We seek to empower our community through education, one individual at a time. More than 90 percent of our graduates remain in the area and strengthen our local economy. It is our mission to prepare Philadelphians for a new career or transfer to a four-year college so that they can achieve their educational and career goals.

Community College of Philadelphia is dedicated to promoting a work environment which attracts and retains talented, high caliber faculty and staff, and which challenges each of us to achieve at the highest level while contributing to the mission of the College.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert