DATA ENGINEER

Summary This position is located in the Office of Inspector General, Office of Data, Analytics, and Technology (ODAT). The Office of Inspector General is an independent office within EPA that helps the agency protect the environment in a more efficient and cost-effective manner. We consist of auditors, program analysts, investigators, and others with extensive expertise. Although we are a part of EPA, Congress provides us with our funding separate from the agency, to ensure our independence. Responsibilities As a DATA ENGINEER GS-2210-13, the incumbent will be responsible for building and maintaining the on-premises and cloud infrastructures that collect, transform, and store data at scale while ensuring data quality, security and accessibility for data scientists, data analysts, statisticians, and business intelligence (BI) reporting platforms. Typical work assignments may include the following under supervision: Designs and maintains data pipelines that feed into different IT systems including, but not limited to, on-premises SQL and Oracle databases, Amazon Web Services (AWS) environments, BI reporting platforms, and Microsoft Office 365 Builds and maintains data pipelines for ODAT involving audit, evaluation, and investigative oversight projects Implements data architecture, governance, and compliance solutions for on-premises and cloud environments Develops production-grade extraction, transformation, and loading (ETL) pipelines for ingesting and transforming large, disparate data from databases, Application Programming Interface (API)s, and web-scraped feeds Orchestrates with Airflow/Luigi and accelerates processing with Spark/PySpark or similar tools Applies advanced techniques for data modeling and analytics to meet oversight needs; and provides technical leadership in the development or modernization of IT data systems Requirements Conditions of Employment Must be a U.S. Citizen or National 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 Depending on your status, this position may require serving a 1-year probationary period 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 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 Qualifications This announcement will close at 11:59 PM (ET) on 10/17/2026. Applicants must meet all qualifications and eligibility requirements by the close date. Minimum Qualification Requirement: Under the updated Competency-Based Qualification Standard for the IT Management Series (2210), applicants must: Meet or exceed all required general competencies at the minimum proficiency level for the GS-13 grade, Meet or exceed all required technical competencies established for this announcement for the GS-13 grade, and Demonstrate you have the required specialized experience for the position. You may be considered ineligible and removed from further consideration for the position, if you fail to meet any of the criteria above. Specialized Experience: You must demonstrate the competencies required to successfully perform the duties of the position. These competencies are normally attained through one year of specialized experience equivalent to the next lower grade level of the position being filled. You may qualify for the GS-13 grade level, if you possess at least one year of specialized experience equivalent to the GS-12 grade level in the federal sector, or the equivalent in the private sector. Specialized experience is experience that has equipped the candidate with the particular knowledge, skills, and abilities to perform successfully the duties of the position. For this position your specialized experience must demonstrate the following: Designing a production Extract, Transform, and Load (ETL) pipeline to ingest data from disparate sources into an enterprise environment feeding both, Structured Query Language (SQL) databases and Business Intelligence (Power BI) reporting endpoints; Implementing controls to ensure data compliance and governance standards (e.g., metadata tagging, role-based access, data cataloging) across both, cloud and on-premises environments; Implementing a testing and monitoring strategy to guarantee data integrity; AND Leading or participating orally in meetings to collect data and technical requirements. 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). Experience must be validated through the assessment process, consistent with OPM's skills-based hiring policy. Competencies Being Evaluated: Attention to Detail Is thorough when performing work and conscientious about attending to detail. Customer Service Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services. Decision Making Makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals; causes change. Information Management Identifies a need for and knows where or how to gather information; organizes and maintains information or information management systems. Interpersonal Skills Shows understanding, friendliness, courtesy, tact, empathy, concern, and politeness to others; develops and maintains effective relationships with others; may include effectively dealing with individuals who are difficult, hostile, or distressed; relates well to people from varied backgrounds and different situations. Oral Communication Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately. Problem Solving Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. Teamwork Encourages and facilitates cooperation, pride, trust, and group identity; fosters commitment and team spirit; works with others to achieve goals. Technical Competency Uses knowledge that is acquired through formal training or on-the-job experience to perform one's job; works with, understands, and evaluates technical information related to the job; advises others on technical issues. Education Education cannot be used to qualify for this position. Additional Information The selectee will be required to complete a Personal Identity Verification (PIV) process that requires two forms. 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. 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. Payment of relocation expenses is NOT authorized. Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments, based on your adjudication decision. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments. (https://appsupport-usastaffing.opm.gov/hc/en-us/sections/45063131363475-Reasonable-Accommodation-Information) If you are claiming CTAP/ICTAP eligibility, you must submit proof by 10/17/2026 that you meet the requirements of 5 CFR 330.605(a) for CTAP and 5 CFR 330.704 for ICTAP or you will not receive priority consideration. The proof includes a copy of the agency notice, your most recent Performance Rating, and your most recent SF-50 noting current position, grade level, and duty station. To be considered well-qualified and exercise selection priority of this vacancy, you must earn a minimum score of 85 (prior to the assignment of veteran's preference) on the rating criteria for this position. VETERANS PREFERENCE: If claiming 5-point veteran preference you MUST submit copy number 4 of the DD-214. If you are claiming 10-point veteran preference you MUST submit an SF-15, Application for 10-point Veteran's Preference AND all other required documents in order to be granted the preference. Additional information on veteran's preference is available at: http://www.fedshirevets.gov/job/veterans.aspx