PHEAA is seeking a SAS Programmer (Policy Research Analyst) to join their team. 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), 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 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.
SALARY: Commensurate with experience ($64,132 - $109,025 - Pay Grade 16)
LOCATION: Harrisburg, PA. Hybrid: On-site/Remote Schedule Available.
JOB RESPONSIBILITIES
STATISTICAL ANALYSIS, MODELING AND FORECASTING
- 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 in order to assist areas outside of State Grant and Special Programs with their research and policy needs.
SAS PROGRAMMING AND STATISTICAL REPORT WRITING
- 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.
BUSINESS PROCESS ANALYSIS/SUPPORT
- 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.
- Other duties as assigned.
Required Skills
MINIMUM QUALIFICATIONS: 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 the equivalent combination of certifications, experiences, and/or training.
- 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. VBA experience necessary.
- 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 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.
- This position will support a federal government contract. Applicants must be able to obtain Public Trust security clearance as required of federal government contractors to include a background check conducted by the U.S. Government to determine eligibility and suitability for federal contract employment for public trust or sensitive positions. For this level of clearance, the federal government requires applicants to possess U.S. citizenship. In light of this federal government requirement, PHEAA WILL BE UNABLE TO HIRE APPLICANTS WITHOUT UNITED STATES CITIZENSHIP FOR SUCH POSITIONS.
PREFERRED QUALIFICATIONS: 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.
Required Experience
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 the equivalent combination of certifications, experiences, and/or training.