Job Description
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!
Salary: Grade 18 ($111,180.00 – $152,859.58)
Shift: Monday through Friday 8:00 AM – 5:00 PM
Location: Harrisburg, PA.
Department: Internal and IT Audit
The Lead Data Scientist/Analytics Auditor works under general supervision, this role is responsible for conducting independent and objective IT analysis and extracting of IT audit data. This includes creating test cases and preparing data sets, tables, graphs, and statistical analysis. This role collaborates with all team members of the Internal Audits department.
Primary Duties and Responsibilities
Data Analytics
- Analyze and evaluate complex data from different sources, discover patterns hidden within raw data, create insightful variables, and develop competing models.
- Analyze data from information technology audits as assigned and in accordance with internal audit methodology and established auditing standards.
- Work on assignments involving moderately complex to complex issues where the analysis of situations or data requires an in-depth evaluation of variable factors
- Provide subject matter expertise to Internal Audits (IA) regarding data visualization, SQL, R and Python to all business units.
- Create test cases, identifying scope of testing with risk-based approach for each audit or scope of work.
- Prepare analysis data sets, tables, listings, graphs, and statistical analysis.
- Design and build data analytics solutions for Internal Audits based upon risk, scope, and audit project objectives.
- Collaborate effectively with Internal Audit team and management to understand data, analytical, and reporting needs then produce and deliver solutions to support those needs.
- Identify access, consolidate and manage data that is relevant to support audit objectives; data management includes administration of Internal Audit data repository while following Data Governance guidelines and best practices.
- Provide preliminary to final data analysis reports, extracts, or searchable records for the Internal Audit department.
- Develop visualization analytics and reporting to present scenarios from data, both at a high level to highlight potential risks and at the detailed level to enable root cause analyses.
- Collaborate with the audit teams to build strategic self-service data products that enable auditors to more efficiently and effectively work with data and identify potential risk.
- Create and executive the most complex Structured Query Language (SQL) queries.
- Ensure audit methodology is followed, including all appropriate documentation and requirements.
- Using mathematical and statistical modeling, identify, interpret, and project trends in current and new data sources.
- Collaborate on interpretation and presentation of findings.
- Design, produce, deploy, and maintain metrics dashboards, ad hoc and scheduled reporting, and high-impact and intuitive visualization of relevant, and often complex, data for management and senior executives.
- Develop and/or implement processes/change management for enhancing metrics, dashboards and scorecards.
- Monitor and interpret data from metrics systems in relation to applicable policies and procedures.
- Provide superior analyses and interpretation/evaluation of strategies which includes presentation preparation for leadership review.
- Propose and implement innovative analytics for both trending metrics and predictive analysis that are operationally relevant.
- Perform and document audit procedures to assess the security and configuration controls of information systems (e.g., applications, databases, operating systems, networks).
- Draw conclusions and provide recommendations in a clear, concise and constructive manner, both orally and in writing.
- Document results in the audit work papers and audit report.
Other Duties and Responsibilities
- Keep track of and accurately report time spent on a timely basis.
- Keep up-to-date and increase knowledge in the areas of auditing, information technology, business, organization initiatives, and maintain professional certifications.
- 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, or other related discipline and 7-10 plus years of programing, coding, data analyst experience and experience within a Financial Services or any equivalent combination of knowledge, training, and/or certification(s). Accounting background and/or CPA certification required.
- Advance experience in applying advanced statistical modeling technologies to solve problems.
- Proficient in one or more statistical analysis programs (JMP, SPSS, etc.)
- Advance experience with Tableau, SAS, SQL, Oracle, ACL. or other analytic and visualization tools or programming languages.
- Advanced skills in R programming and Python.
- Advance experience with ACL or a similar query language.
- Demonstrated programming experience and ability to work with multiple programming languages and technologies, including various web related languages and SQL.
- Database design and SQL Experience (PostgreSQL or MS SQL)
- Advanced programming skills (Object Oriented, Data Types, Methods, Algorithms, Generics, Interfaces, Delegates, Inheritance, Repetitions, Classes, Polymorphism, Arrays).
- Detail-oriented with high degree of accuracy.
- Strong analytical, problem-solving, and critical-thinking skills.
- Excellent verbal and written communication skills.
- Demonstrated proficient ability to adhere to and promote audit quality.
- Experience handling multiple projects and tasks simultaneously while effectively managing time constraints, setting priorities and meeting deadlines.
- Demonstrated experience auditing general computer controls and IT control testing of applications, operating systems, and databases.
- Knowledge of the concepts, theories, principles, and practices of IT auditing, including internal control concepts.
- Demonstrated knowledge of National Institute of Standards and Technology (NIST) and Federal Information Security Management (FISMA).
- Knowledge of information technology principles.
- Demonstrated understanding of business processes, internal controls, and risk management.
- Ability to identify and evaluate business and technology risks, internal controls which mitigate risks, and related opportunities for internal control improvement.
- Experienced in time reporting, risk assessment and control mapping automation.
- Advanced experience in continuous auditing and auditing tools.
- Experience with visualization tool.
- Experience with Risk Assessment development, continuous auditing, application and general controls environments.
- Knowledge of accounting and financial systems.
- 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.
PHEAA’s environment welcomes and supports our employees, customers, and stakeholders; we seek out and value differing perspectives and contributions. Our organizational culture promotes diversity, equity, and inclusion at all levels of the organization.
Required Experience
Bachelor’s degree
Accounting background and/or CPA certification required.