Accounting Software Coding Jobs in York, PA (NOW HIRING)

PHEAA is a nonprofit student aid organization that holds a mission of providing affordable access to higher education.
Give back tomorrow by joining us today!
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.
Salary: Grade 16, Commensurate with experience starting at $71,439.00
Shift: Monday - Friday 8:00 AM -5:00 PM Hybrid 2 days Required Onsite
Location: Headquarters- 1200 North 7th Street Harrisburg PA 17102
Department: State Grant & Special Programs
Benefits: Please click here to learn about PHEAA's Total Rewards Benefits.
Primary Duties and 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 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.
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.
Other Duties and Responsibilities
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.
Required Skills
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. VBA experience preferred.
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.
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.
Essential Duties and Responsibilities
Physical Requirements and Work Environment
Perform work required for this position in an open environment and/or via remote or hybrid arrangement.
Remain sedentary for significant periods of time.
Utilize computer keyboard for extended periods.
Occasional extended hours required.
Must be able to use a personal computer.
ADDITIONAL KNOWLEDGE, SKILLS, AND ABILITIES
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.
PHEAA's environment welcomes and supports our employees, customers, and stakeholders; we seek out and value differing perspectives and contributions.
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 any equivalent combination of experience, training, and/or certification(s).