Community College of Philadelphia · 2 days ago
Senior Business Intelligence Analyst
Philadelphia, PA
Full-time
Onsite
Mid, Senior Level
$63K/yr - $103K/yr
5+ years expCommunity College of Philadelphia is an open-admission institution dedicated to promoting access to higher education. The Senior Business Intelligence Analyst is responsible for analyzing and enhancing the college-wide data lake and business intelligence support, transforming data into actionable knowledge for college leaders and administrators.
EducationE-LearningHigher Education
No H1B
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
Perform established maintenance tasks to keep the reporting platform going, including license management, data bridge service management, validation of scheduled refreshes, etc
Performs other duties as assigned
Qualification
Required
Bachelor's degree is required
A minimum of five (5) years in a higher education administrative environment
A minimum of five (5) years performing data analytics and data science solutions
A minimum of five (5) years work-related database management and developing reporting solution experience required
A minimum of five (5) years developing business intelligence solutions and an understanding of key concepts in higher education derived from Oracle 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
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
Benefits
College-paid medical, dental, drug, life and disability insurance
Tuition remission (for classes at the college)
Forgivable tuition loan (for classes at any accredited academic institution)
403(b) retirement plan with 10% College contribution with employee contribution 5%
Flexible spending accounts
Paid vacation, holiday and personal time
Partial remote work schedule for remote work eligible positions
Winter break: 1 week around the third week in December and New Years
Spring Break: 1 week in March
Summer Hours: 4-day work week (closed on Fridays) from the 2nd week in May through the 3rd week in August
Company
Community College of Philadelphia
Community College of Philadelphia is a school that offers liberal arts, sciences, career technologies, and continuing education.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
$3.2MKey Investors
National Telecommunications and Information Administration
2023-03-08Grant· $0.25M
2023-02-27Grant· $2.95M
Leadership Team
Alycia Marshall
President
Recent News
The Philadelphia Inquirer
2025-12-20
The Philadelphia Inquirer
2025-11-08
The Philadelphia Inquirer
2025-11-01
Company data provided by crunchbase