Policy Research Analyst

Pheaa•Harrisburg, PA

4d•Hybrid

About The Position

PHEAA is a nonprofit student aid organization that holds a mission of providing affordable access to higher education. This role employs advanced statistical reporting and analysis techniques, including multivariate models to calculate variations on data. It includes collecting, extracting, summarizing, and analyzing data for high-profile research projects. The role develops sophisticated projections and models of financial aid awards under various scenarios and requires trend analysis and economic forecasting skills. This position is responsible for coding and delivering reports using report writing tools, such as Statistical Analysis Software (SAS), Output Delivery System (ODS), Advanced Query Tools (AQT), Smart Simple Report Builder (Neo), Job Control Language (JCL) or other Structured Query Language (SQL) software at an expert level. In addition to this advanced experience with programming languages, the position requires senior-level experience and knowledge in relational and object-oriented databases and how to read data models. The role provides PHEAA Executive Staff, PHEAA Board, the General Assembly and other internal/external stakeholders with quality data to facilitate program planning, accountability, evaluation, and development.

Requirements

Bachelor’s degree in mathematics, statistics, economics, computer science, or related field and minimum of five years of demonstrated advanced knowledge of statistical and business software, including SAS or any equivalent combination of experience, training, and/or certification(s).
Demonstrated expertise in advanced data analysis techniques, such as analysis of variance, hierarchical linear modeling, latent class analysis, and non-parametric statistics.
Demonstrated expert-level use of SAS, SQL, and MS Office required.
Advanced data programming experience required.
Proven experience in data management and analysis with large, complicated datasets
Advanced experience analyzing data and drawing conclusions.
Senior-level experience in querying and reporting from relational and object-oriented databases.
High-level proficiency in Microsoft Excel.
A track record of adapting to shifting priorities, demands and timelines.
Proven effective communication and interaction with individuals throughout the organization, including IT, business units, and upper management.
Ability to adapt to change and implement quickly based on overall direction and needs of the organization.
Demonstrated effective time management, organization and prioritizing ability.
Demonstrated self-starter and self-motivator.
Excellent ability to handle confidential information.
Excellent analytical, critical thinking, organizational, problem solving, project management, and customer service skills.
Prioritize high-profile assignments, work independently with limited supervision, and initiate learning of new analysis techniques and programs.
Strong focus on accuracy and details.
Excellent written and verbal communication skills and the ability to express complex information in a concise manner to non-technical audiences.
Expertise in the clear and concise graphical presentation of data.
Exercise judgment and discretion in developing, applying, and interpreting data, guidelines, and procedures.
Perform advanced work involving the review and evaluation of complex agency programs and projects.
Develop and promote effective working relationships with all levels of Agency management.
Work effectively in a team environment and high-profile business unit.
Advanced knowledge and demonstrated proficiency in Microsoft Office.

Nice To Haves

VBA experience preferred.
Master’s degree and five years of progressively responsible professional analytical work in program analysis involving the use of statistical and data analysis techniques.
Mainframe computer experience helpful.

Responsibilities

Initiate and conduct complex original and collaborative research.
Provide reliable, relevant, and quality data and information to facilitate planning, accountability, program evaluation, and development of Agency policy positions.
Apply advanced mathematics, scientific methods and computer programming to define data requirements and analyze, test and evaluate information, including the projection of State Grant and Special Program applicants, recipients and dollar volume for the annual Commonwealth budget process and actual award determinations.
Use analytical techniques, such as linear and logistic regression, to answer research/policy questions.
Generate descriptive statistics, crosstabs and correlations for data.
Perform validation and testing of models to ensure adequacy or determine need for reformulation.
Conduct complex data management and analysis with large, complicated datasets.
Forecast State Grant Program and Special Program applicants, recipients, and dollar volume via an annual estimation process.
Redesign, maintain, and operate the annual State Grant Program forecasting system, which is currently SAS-based and involves senior-level skills in a high risk-based environment.
Create predictive financial aid models accounting for multiple, interactive scenarios and economic factors that can have budgetary and enrollment repercussions.
Analyze State Grant and other Agency program data utilizing SAS, SAS GRAPH, AQT, JCL, ODS, and SQL.
Track multi-year trends and identify key factors in determining the usage of Agency programs.
Participate in and contribute to relevant meetings to assist areas outside of State Grant and Special Programs with their research and policy needs.
Forecast staffing needs for the State Grant and Special Programs call center.
Develop high-profile, client-centric reports for PHEAA, its Board of Directors, the General Assembly, other government agencies, and external stakeholders and ensure that these reports are complete and accurate by verifying results.
Fulfill highly complex internal and external statistical data requests in a timely and clear manner, including bill analyses.
Deliver clear and succinct graphical presentations of data.
Verify reports of other analysts to ensure accuracy and quality control.
Automate routine activities and improve data collection through more efficient SAS coding and alternative technology.
Liaison between Research and Policy Analysis and other Agency divisions for issues related to data management, transfer and integrity.
Assess potential problems and recommend corrective action to resolve or mitigate associated risks.
Apply senior-level relational database knowledge to the management, analysis, and performance of agency databases.
Provide production support by identifying, analyzing, and updating production-driven records and/or processes.
Write scripts in Visual Basic (VBA) for production issues.
Develop databases for quality assurance efforts.
State Grant and Special Programs representative for agency-wide IT initiatives.
Comply with the Agency’s enterprise security and privacy policies and departmental procedures.
Other duties as assigned.