Sr. Business Intelligence Analyst

Senior Business Intelligence Analyst

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.

Position Summary

The Senior 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 databases; 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.

Essential Responsibilities

• Prepares reporting, analytics, and dashboard development from concept to implementation.
• Analyzes, develops, and interprets data needs for end users.
• Assists in the development, implementation, and maintenance of the enterprise-wide reporting 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 systems 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.

Required Qualifications

• A bachelor's degree is required. Any and all must be from a recognized institutional accreditor.
• A minimum of 5 years in a higher education administrative environment.
• A minimum of 5 years of experience performing data analytics and data science solutions.
• A minimum of 5 years of work-related database management and developing reporting solution experience is required.
• A minimum of 5 years of developing business intelligence solutions and an understanding of key concepts in higher education derived from databases and/or data lake applications is 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

• A master's degree is preferred.
• 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.

If you are required to submit references in your application, please provide your current supervisor and two previous supervisor's contact information.

Please note - CCP will not contact your references until a contingent offer has been made. You will have the opportunity to alert your references and current employer prior to the reference check process beginning.

Thank you for your interest in opportunities at Community College of Philadelphia. Below is a summary of the comprehensive benefits package available to administrative employees.

Administrative employees receive a competitive benefits package that includes:

• Medical, prescription, dental, and vision coverage at no cost (PPO buy-up plan available at a cost)
• College-paid life insurance and long-term disability
• 403(b) retirement plan with a 10% College contribution when you contribute 5%
• Generous paid time off, including:
• Vacation time: 23 paid vacation days; prorated based on hire date
• Personal time: 22.5 hours annually (3 days - prorated based on hire date)
• Sick time: paid at 100% with appropriate documentation
• Paid bereavement leave
• Paid holidays
• Tuition remission (100%) for employees and eligible dependents
• Forgivable Loan Program
• Employee Assistance Program (EAP)
• Additional perks include winter break, spring break, and summer hours (4-day workweek)