Position TitleSr. Business Intelligence AnalystRequisition NumberSCA00747General Description
The Sr. 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.
College Intro
Success starts at Community College of Philadelphia. Innovators and difference makers work at Community College of Philadelphia. Diversity thrives at Community College of Philadelphia. We are a college that is committed to promoting a work environment that attracts and retains talented and diverse faculty and staff. We challenge each other and ourselves to achieve at the highest level while contributing to the mission of the College and the betterment of Philadelphia. We value and support an intellectually dynamic community to prepare our students for global citizenship. Join us and become a part of a community that has long been and will continue to be generators of generational chance in this city and beyond.
Community College of Philadelphia is an open-admission, associate-degree-granting institution which provides access to higher education for all who may benefit. Its programs of study in the liberal arts and sciences, career technologies, and basic academic skills provide a coherent foundation for college transfer, employment and lifelong learning. The College serves Philadelphia by preparing its students to be informed and concerned citizens, active participants in the cultural life of the city, and enabled to meet the changing needs of business, industry and the professions. To help address broad economic, cultural and political concerns in the city and beyond, the College draws together students from a wide range of ages and backgrounds and seeks to provide the programs and support they need to achieve their goals.
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 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 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 LocationMain CampusBenefits Summary
Benefits:
“Success Starts Here” at Community College of Philadelphia. We recognize that our success as a college and the success of our students starts with our employees. Our employees are vital to our success. Our total compensation package includes a comprehensive offer of benefits that are unrivaled by most.
Full-time faculty and staff benefits include:
• 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
Additional College benefits:
• 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
For More information about the College benefits and eligibility based on employee class, please visit:https://www.myccp.online/human-resources/benefits-eligibility
Salary Grade or Rank4Min Salary/Hourly Rate$62,672.00Max Salary/Hourly Rate$103,410.00Job Posting Open Date03/26/2024Job Posting Close DateType of PositionAdministratorJob CategoryEmployment Status Full-TimeSpecial Instructions to Applicants
Special Instructions to Applicants:
Interested persons should complete an online application.
• Cover letter of interest and CV/resume REQUIRED.
• Name and contact information for three (3) references REQUIRED.
• Employment offers are contingent upon successful completion of background checks in accordance with the Pennsylvania Child Protective Services Law.
• Must be legally eligible to work in the U.S. Community College of Philadelphia is an affirmative action, equal opportunity and equal access employer.
• Community College of Philadelphia is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.
