107 applicants

Company

Original Job Post

Community College of Philadelphia · 2 days ago

Data Reporting and Query Analyst II

Philadelphia, PA

Full-time

Hybrid

Mid Level

$54K/yr - $54K/yr

4+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

E-LearningEducation

Insider Connection @Community College of Philadelphia

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Design and create data structures to produce reports for senior management.

Write SQL scripts to create data structures and transform data.

Manage data in relational databases using SQL programming language.

Create and publish complex reports and dashboards for institutional effectiveness.

Provide leadership in developing and maintaining Institutional Research Intelligence Dashboards.

Engage with campus constituencies to understand data needs and design data-collection strategies.

Manage research and evaluation projects, overseeing analysis and dissemination of deliverables.

Utilize data management best practices and maintain confidentiality and respect for a diverse academic environment.

Represent the Institutional Research office and participate in College committees.

Assist and train junior research analysts in business processes and technical skills.

Maintain project documentation and support institutional research.

Support in the administration and analysis of institutional research, surveys, and focus groups.

Pursue continuous professional development and recommend new technologies and reporting strategies.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data managementReport deliveryData analysisSQLSQL programmingMS ExcelLarge datasetsData optimizationDiverse backgroundsProblem-solvingAnalytical abilityOral communicationWritten communicationTime managementMulti-taskingProject managementTeamworkSensitivityTableauMicrosoft BIArgosData queryingData manipulationSPSS

Required

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.