Summary The Office of Inspector General is an independent office within the EPA that helps the agency protect the environment in a more efficient & cost effective manner. We perform audits, evaluations, & investigations of the EPA to promote economy, efficiency, and to prevent and detect fraud, waste and abuse. We strive to provide solutions to problems that ultimately result in making America a cleaner and healthier place. Responsibilities This position is located in the Office of Strategic Analysis and Results, Data Analytics Directorate. The Data Analytics Directorate supports the Office of Audit, the Office of Evaluation, and the Office of Investigations by leveraging advanced analytics that highlight key risk areas to program integrity within EPA programs and operations. Responsibilities The ideal candidate will perform the following duties: Assist in developing the best practices and methodologies for creating and maintaining Power BI dashboards; Utilize SQL to query databases and Python/R to extract, transform, and load data; and Develop new dynamic statistical data visualizations using Power BI software for audits, evaluations, and investigative matters. Analyze user needs across diverse stakeholder groups to identify common solutions to unique issues. Requirements Conditions of Employment You must be a U.S. citizen. Background Investigation Required. This is a Public Trust Position. Employment in this position requires a background investigation. If you are selected and cannot obtain a favorable security determination within a reasonable period of time due to disclosed or undisclosed background issues, the tentative employment offer may be withdrawn. If you are a male born after December 31, 1959 you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. Selectees will be required to complete a "Declaration of Federal Employment", (OF-306), prior to appointment and the appropriate background investigation forms to determine suitability for Federal employment. False statements or responses on these forms can jeopardize your employment opportunity and subject you to disciplinary action, including removal from Federal service. The selectee will be required to complete a Personal Identity Verification (PIV) process that requires two forms of identification from the I-9 Form. We will compare information provided on the I-9 Form to records available from the U.S. Department of Homeland Security. The system confirms employee’s identity and eligibility to work in the United States. Learn more about e-verify, including your rights and responsibilities. Depending on your status, this position may require serving a 1-year probationary period. Qualifications All applicants must have 1 year of specialized experience equivalent to at least the next lower grade level in the Federal Service. Specialized experience is experience that has equipped the candidate with the particular knowledge, skills, and abilities to perform successfully the duties of the position. Qualifying specialized experience must demonstrate the following: GS-12: 1) Apply code writing and programming languages (SQL, Python, R, SAS, Power Query, DAX) to analyze disparate and large datasets; 2) Apply code writing and programming languages (Python, R) to extract, transform and load disparate and large datasets; 3) Create and present data visualizations using Power Bl Desktop, 12 Analyst Notebook or similar Link Analysis software, ArcGIS Pro, Tableau and/or SAP Business Objects; 4) Document work product and create written reports for clients; and 5) Experience working with audits, evaluations, and/or investigations. GS-13: 1) Leads and advises a small team on the best practices and methodologies for analyzing and reporting on data; 2) Apply code writing and programming languages (SQL, Python, R, SAS, Power Query, DAX) to analyze disparate and large datasets; 3) Apply code writing and programming languages (Python, R) to extract, transform and load disparate, large, structured and unstructured datasets; 4) Create and present data visualizations using Power Bl Desktop, 12 Analyst Notebook or similar Link Analysis software, ArcGIS Pro, Tableau and/or SAP Business Objects; 5) Apply automation processes to data collection, transformation, and reporting products to reduce manual processes; 6) Document work product and create written reports for clients; and 7) Experience working with audits, evaluations, and/or investigations. Evidence of the above specialized experience must be supported by detailed documentation of duties performed in positions held. Your resume is the key means we have for evaluating your skills, knowledge, and abilities as they relate to this position. Therefore, we encourage you to be clear and specific when describing your experience. We will not make assumptions regarding your experience or based on job titles alone. If your resume does not support your questionnaire answers, we will not allow credit for your response(s). Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience. Applicants must meet the qualifications for this position within thirty (30) days of the closing date of this announcement. Education This position does not have a mandatory education requirement. Additional Information EPA OIG provides reasonable accommodations to applicants with disabilities on a case-by-case basis. If you need a reasonable accommodation for any part of the application or hiring process, please contact the Human Resources Specialist listed in this vacancy announcement. Payment of relocation expenses is NOT authorized. All the information you provide will be verified by a review of the work experience and/or education as shown on your application, by checking reference and through other means, such as the interview process. Any exaggeration of your experience, false statements, or attempts to conceal information may be grounds for not hiring you or for firing you after you begin work. Additional selections may be made through this vacancy announcement.