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.
Duties
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
Education
Education cannot be used to qualify for this position.
How you will be evaluated
ONLY two (2) pages of your resume will be reviewed. Additional information beyond your resume (e.g., cover letter, links embedded in your resume) will not be reviewed. Your qualifications will be evaluated based on your application materials (e.g., resume, supporting documents), your responses on the application questionnaire and to all assessments required for this position. Applicants who do not respond to the application questions may be rated ineligible. To be found minimally qualified, you must demonstrate proficiency in the competencies described in the Qualifications section of the job announcement and listed below. Your qualifications will be evaluated on the following competencies: Accountability, Attention to Detail, Customer Service, Decision Making, Flexibility, Influencing/Negotiating, Information Management, Integrity/Honesty, Interpersonal Skills, Learning, Oral Communication, Problem Solving, Reading Comprehension, Reasoning, Self-Management, Stress Tolerance, Teamwork, and Technical Competence Online Assessments: USA Hire Assessments: The USA Hire Assessments include a passing score based on the minimum level of required proficiency in critical general competencies. You must meet or exceed the cut score to be considered. You will not be considered for the position if you score below the cut score or fail to complete the assessment. Resume review: Your resume will be reviewed to confirm your qualifications for this position based on the required minimum qualifications. Applicants passing the online assessment process will have their application package reviewed and rated based on the competencies listed in the vacancy announcement by a Subject Matter Expert (SME). Interview: Applicants may be invited to in an interview to further assess their qualifications relative to the required minimum qualifications. We will provide the selecting official a sufficient number of names, when available, to consider at least three candidates per vacancy. If fewer than three eligible and available candidates per vacancy result, we will expand the group in accordance with our pre-announced supplement strategy and OPM policy.