Data Scientist

Federal Energy Regulatory Commission; Washington (District of Columbia); On-site; USD 80,000 - 120,000; Full time

Job summary

The Federal Energy Regulatory Commission (FERC) is seeking a Data Scientist in Washington, DC to design and maintain data pipelines, and turn complex datasets into actionable insights for enforcement and regulatory accounting. The role requires hands-on experience with SQL/T-SQL, Python, and R, plus Databricks or Synapse for data processing.

You will analyze data using Power BI and SQL, present findings to the team and management, and collaborate with colleagues to implement quality control

Qualifications

• Develop and maintain data pipelines using SQL/T-SQL, Python, R, Databricks, or Synapse.
• Analyze data using Power BI, R, Python, and SQL to support enforcement decisions.
• Use GitHub for version control and collaboration.
• Present findings clearly to the team, the Division, or management orally and/or in writing.

Responsibilities

• Develop and maintain data pipelines and quality checks.
• Present analytical findings to leadership and stakeholders.
• Collaborate with enforcement teams to translate data into actionable insights.

Skills

SQL/T-SQL

Python

R

Databricks

Synapse

Power BI

GitHub

Data presentation

Education

Bachelor's degree in a quantitative field

Tools

Databricks

Synapse

Power BI

GitHub

Job description

Summary

The Federal Energy Regulatory Commission (FERC) is ranked within the top 5 mid-size agencies as a "Best Place to Work" in the Federal government! This Data Scientist position is located in the Office of Enforcement and Regulatory Accounting. For more information visit: Office of Enforcement and Regulatory Accounting (OERA)

Major Duties

As a Data Scientist some of your typical work assignments include: Develop and maintain data pipelines using SQL/T-SQL, Python, R, Databricks, or Synapse. Use Power BI, R, Python, SQL to analyze data and implement quality control checks. Use GitHub for version control and to collaborate with teammates. Clearly present findings, approach, and processes to the team, the Division, or management orally and/or in writing.

Education

This position has an education requirement and therefore, transcripts are required. Failure to submit a copy of your transcripts at the time of application will result in your application being marked incomplete and you will not receive further consideration. PASS/FAIL COURSES: If more than 10 percent of your undergraduate course work (credit hours) were taken on a pass/fail basis, your claim of superior academic achievement must be based upon class standing or membership in an honor society. GRADUATE EDUCATION: One academic year of graduate education is the number of credits hours your graduate school has determined to represent one academic year of full-time study. Such study may have been performed on a full-time or part-time basis. If you cannot obtain your graduate school's definition of one year of graduate study, 18 semester hours (or 27 quarter hours) should be considered as satisfying the requirement for one year of full-time graduate study.

Evaluations

You will be evaluated based on how well you meet the qualifications listed in this vacancy announcement. Your qualifications will be evaluated based on your application materials (e.g., resume, supporting documents), your responses to the application questionnaire, and your responses to all assessments required for this position. You will be assessed on the following competencies (knowledge, skills, abilities, and other characteristics): Attention to Detail Customer Service Decision Making Flexibility Integrity/Honesty Interpersonal Skills Learning Reasoning Self-Management Stress Tolerance Teamwork The USA Hire Assessments includes a cut score based on the minimum level of required proficiency in these 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. Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on an assessment may also result in your removal from consideration. To preview the application questionnaire, click the following link: https://apply.usastaffing.gov/ViewQuestionnaire/13050090

What to Expect Next

Once your complete application is received, we will conduct an evaluation of your qualifications and determine your ranking. You will be notified of the status of your application up to four times throughout the application process, via your USAJOBS dashboard. To verify the status of your application, both during and after the announcement open period, log on to your USAJOBS account. The application record in your USAJOBS account provides an option to "Track this application." Your "Applicant status" will also appear along with the dates you applied to this position and when your application was last updated. To learn more about your specific job status and how this helps you track jobs and applications visit: https://help.usajobs.gov/how-to/application/status Please notify us if your contact information changes after the closing date of the announcement. More than one selection for similar positions may be made from this announcement and the program office for that selection may vary. By applying, you agree to have your application shared with any interested selecting official(s).

Required Documents

Failure to submit all required documentation by the closing date of this vacancy announcement, including adhering to the maximum two-page resume requirement, will result in removal from consideration and loss of any special hiring preference (e.g., veterans' preference, ICTAP/CTAP eligibility, Schedule A). REQUIRED DOCUMENTS FOR ALL CANDIDATES: RESUME (maximum of 2 pages in length): Your resume should describe your specialized experience and support your answers to the vacancy announcement questionnaire. You must ensure it contains the following information for each experience/position: Position title Name of employer Beginning and ending dates of employment (Month/Day/Year format) Hours worked per week Detailed description of job duties, accomplishments, related skills, and responsibilities to include any supervisory/managerial responsibilities and number of staff supervised (if applicable) Series and grade or equivalent (for federal positions) If the position has an education requirement or you are qualifying based on your education, you must list your education history, including the type of degree and your major of study. VACANCY QUESTIONNAIRE: You must submit and complete the online eligibility and vacancy questions. TRANSCRIPTS (only required when the position has an education requirement, or you are qualifying for the position based on your education): You MUST submit copies of your college transcripts to verify your education. Unofficial copies are acceptable; however, if selected you will be required to provide official transcripts before your effective date. OPTIONAL DOCUMENTS TO SUPPORT CAREER TRANSITION ASSISTANCE PROGRAM (CTAP)/INTERAGENCY CAREER TRANSITION ASSISTANCE PROGRAM (ICTAP) ELIGIBILITY: These programs apply to employees who have been involuntarily separated from a Federal service position within the competitive service or Federal service employees whose positions have been deemed surplus or no longer needed. To receive selection priority for this position, you must: 1) meet CTAP or ICTAP eligibility criteria; 2) be rated "Well Qualified" for the position; and 3) submit the appropriate documentation to support your CTAP or ICTAP eligibility. For more information about CTAP/ICTAP, visit: http://www.opm.gov/rif/employee_guides/career_transition.asp. The following documents are required: Reduction in Force or RIF notice - written notice of your expected separation, or other documentation of priority consideration status; Latest SF-50 noting your current position, grade level, and duty location; Last performance appraisal, including your rating; and Any documentation from your agency showing your current promotion potential.

Other Information

The duty location of this position is Washington, DC. When promotion potential is shown, future promotions will be dependent on your ability to perform the duties at a higher level, the continuing need for an employee assigned to the higher level, and administrative approval. If selected for this position, you will be required to: Complete a Declaration for Federal Employment (OF-306) to determine your suitability for Federal employment. Have your Federal salary payments made by direct deposit to a financial institution of your choice. Go through a Personal Identity Verification (PIV) process that requires two forms of identification from the Form I-9. Federal law requires verification of the identity and employment eligibility of all new hires in the U.S. FERC also participates in the USCIS Electronic Employment Eligibility Verification Program (E-Verify). For more information about E-Verify, including your rights and responsibilities, visit: http://www.uscis.gov/e-verify. Attend a mandatory ethics training. We are governed by the Office of Government Ethics (OGE) Standards of Conduct, the criminal conflict of interest statutes, and FERC's supplemental ethics regulation, which specifically prohibits FERC employees from holding certain energy-related securities. To comply with these regulations and statutes, divestiture of at least some energy securities is likely to be required after you begin employment. See 5 C.F.R. 2634-41; 18 U.S.C. 201-208; 5 C.F.R. 3401. If selected, you may also be required to file a financial disclosure statement within 30 days of appointment. Receive authorization from OPM on any job offer you receive, if you are or were (within the last 5 years) a political Schedule A, Schedule C, or Non-Career SES employee in the Executive Branch. As a condition of employment for accepting this position, you may be required to serve a one-year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider: your performance and conduct; the needs and interests of the agency; whether your continued employment would advance organizational goals of the agency or the Government; and whether your continued employment would advance the efficiency of the Federal service. Upon completion of your probationary period your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest.