Data Reporting and Query Analyst II at Community College of Philadelphia in Philadelphia, Pennsylvania

Job Description:

Posting Details

Position Information

Position Title	Data Reporting and Query Analyst II
Requisition Number	SCA00770
General Description	Reporting to the Director, Institutional Research, the Data Reporting and Query Analyst II is responsible for the production of both standard and customized data reports to support decision-making by various College constituents, including decisions related to student success, program review, and planning. This position demonstrates technical expertise and leadership in developing, implementing and maintaining systems to collect data; and produces statistics, analysis, and reporting relative to internal and external requests for data to support the College’s strategic plan and objectives. #ID23
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	Design and create data structures to produce reports that make data actionable and to facilitate decision making for senior management. Write SQL scripts that enable the creation of data structures and transform data for use with available platforms. Manage data in relational databases using SQL programming language to query, inspect, and code data in preparation for analysis; and create project documentation. Use enterprise databases, static external databases, and other sources to create, test, and publish complex reports and dashboards for institutional effectiveness. Provide leadership in the development, testing, publishing, and maintenance of the centralized Institutional Research Intelligence Dashboards and work to streamline reporting activities and processes. Demonstrate technical expertise for reporting responsibilities related to institutional projects with an emphasis on state, federal, and externally mandated reporting to fulfill compliance regulations. Provide leadership to the IR team to identify the best means to display data, e.g., dashboards, charts, reports, pivot tables and subsequently build the same. Engage in collaborative relationships with campus constituencies to understand data needs and requirements, and design data-collection strategies, dashboards, benchmarking studies, and effectiveness outcomes using available tools. Manage all phases of assigned research and evaluation projects and oversee the analysis and dissemination of deliverables. Utilize data management best practices and ensure the highest level of rigor in the use of data to produce information that is consistent. Maintain confidentiality, sensitivity, understanding, and respect for a diverse academic environment, inclusive of students, faculty, and staff of varying social, economic, cultural, ideological and ethnic backgrounds. Represent the Institutional Research office on behalf of the Director of Institutional research as requested. Participate on College committees, task forces and work groups in support of the College’s mission and vision as assigned. Assist and train junior research analysts in the business processes of the Office of Institutional Research as well as technical skills as need. Creates and maintains project documentation to support the consistency, efficiency, and integrity of Institutional Research Representing the College at institutional research consortia (e.g. PACCC) Supports in the administration and analysis of institutional research, surveys, and focus groups used to identify and improve organizational and institutional effectiveness Seeks and pursues the continuous professional development necessary to maintain updated and relevant skills in a quickly changing field; recommends the adoption of new technologies and reporting strategies as appropriate. Other duties as assigned.
Minimum Qualifications	Bachelor’s degree in a related field required. Any and all degree(s) must be from a regionally accredited institution of higher learnings. A minimum of four (4) years of full-time experience in data management and analysis and delivery of high-quality reports and presentations required. Previous work experience in a higher education environment required. Demonstrated proficiency managing and analyzing large datasets from varying sources required, Strong oral and written communication skills and analytical ability required. Ability to write SQL scripts required. Proficiency with SQL programming to develop, tune and optimize reports/queries required. Proficiency using MS Excel and related tools required to manage, analyze, and report data required. Ability to work independently and take initiative required. Ability to demonstrate effective time management and multi-tasking required. Ability to manage complex projects effectively and communicate ideas and data outcomes accurately and clearly required. Ability to work effectively within a team required. An understanding of, and sensitivity to, the diverse academic, socioeconomic, cultural and ethnic backgrounds of community college staff and students required.
Preferred Qualifications	Master’s degree preferred. Experience using Tableau, Microsoft BI and Argos preferred. Expert level knowledge of data querying and manipulation of data within statistical packages such as SPSS and/or R preferred.
Work Location	Main Campus
Benefits 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 Rank	3
Min Salary/Hourly Rate	$54,498.00
Max Salary/Hourly Rate	$89,921.00
Job Posting Open Date	06/24/2024
Job Posting Close Date
Type of Position	Administrator
Job Category
Employment Status	Full-Time
Special 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.

Supplemental Questions

Required fields are indicated with an asterisk (*).

1. * How did you hear about Community College of Philadelphia?
   • CareerBuilder.com
   • Higheredjobs.com
   • LinkedIn
   • The Chronicle
   • Veterans Job Fair
   • Professional & Technology Diversity Career Fair
   • AL DIA - Diversity Career Fair
   • Community College of Philadelphia Website
   • Indeed.com
   • Other
2. * If your answer to the above question is Other, please note the source below. If this question does not apply to you, enter N/A.

   (Open Ended Question)

3. * What is the highest level of education you have completed?
   • No Response
   • High School/GED
   • Associates Degree
   • Bachelor's Degree
   • Master's Degree
   • Doctorate
   • Other
4. * Do you have a minimum of four (4) years of full-time experience in data management and analysis and delivery of high-quality reports and presentations?
   • Yes
   • No
5. * Do you have previous work experience in a higher education environment?
   • Yes
   • No

Documents Needed to Apply

Required Documents

1. Resume
2. Cover Letter/Letter of Application

Optional Documents

1. References

PI243011743

Apply Now