Sql Financial Analyst Remote Jobs in Portland, OR

Summary
About the Position: Serves as the Business Systems Financial Analyst for the Northwestern Division (NWD). The work provides operational duties in a wide range of analytical and evaluative work such as program analysis, metrics and budget analysis, custom report writing, management process and information system integration. Primarily focused and an integral part of the Regional Hydropower mission at the intermediate command level.
Learn more about this agency
Duties
Help

• Serve as a financial management business systems analyst responsible for the planning, design, adaptation, and installation of standard and mission unique accounting, budgeting, manpower, and strategic planning systems.
• Direct appropriation reporting for Large Capital, Small Capital, Columbia River Fish Mitigation (CRFM) and Fish and Wildlife, provide oversight and analysis to identify coding issues, shortfalls, and concerns for the division office.
• Evaluate the Enterprise Data Warehouse, DCPDS, CEFMS and P2 automated systems to determine design changes required to implement and integrate the systems.
• Provide CEFMS, Standard Query Language (SQL) Enterprise Data Warehouse (EDW), Power BI and query support to district financial analysts.
• Build for Future Success: Training, Innovation, and Teaming: Support to NWD RM Team both Division and Regionally (Panels, Teambuilding, Lunch and Learns, Standard Operating Procedures written, and etc.)

Requirements
Help
Conditions of employment

• Appointment may be subject to a suitability or fitness determination, as determined by a completed background investigation.
• DOD Financial Management Level II certification required in accordance with the National Defense Authorization Act (NDAA) 2012, Public Law 112-81, Subtitle F-Financial Management, section 1051, amending 10 United States Code, section 1599d.
• Certification is required for this position within 24 months of assignment.

Qualifications
Who May Apply: Only applicants who meet one of the employment authority categories below are eligible to apply for this job. You will be asked to identify which category or categories you meet, and to provide documents which prove you meet the category or categories you selected. See Proof of Eligibility for an extensive list of document requirements for all employment authorities.

• Current Department of Army Civilian Employees
• Domestic Defense Industrial Base/Major Range and Test Facilities Base Civilian Personnel Workforce
• Interagency Career Transition Assistance Plan
• Land Management Workforce Flexibility Act
• Military Spouses, under Executive Order (E.O.) 13473
• Priority Placement Program, DoD Military Reserve (MR) and National Guard (NG) Technician Eligible
• Priority Placement Program, DoD Military Spouse Preference (MSP) Eligible
• Priority Placement Program, DoD MR and NG Preference Eligible Tech Receiving Disability Retirement
• Priority Placement Program, DoD Retained Grade Preference Eligible
• Veterans Employment Opportunity Act (VEOA) of 1998

In order to qualify, you must meet the experience requirements described below. 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). You will receive credit for all qualifying experience, including volunteer experience. Your resume must clearly describe your relevant experience; if qualifying based on education, your transcripts will be required as part of your application. Additional information about transcripts is in this document.
Specialized Experience: One year of specialized experience which includes 1) Applying knowledge of financial database systems, software and Automated Data Processing (ADP) policies and procedures in order to evaluate effectiveness and efficiency of operations; 2) Applying knowledge of system software to determine the source of failures and define alternate system approaches to solve automation and database problems; and 3) Analyzing financial systems to determine design changes required to implement the systems. This definition of specialized experience is typical of work performed at the next lower grade/level position in the federal service (GS-12).
Some federal jobs allow you to substitute your education for the required experience in order to qualify. For this job, you must meet the qualification requirement using experience aloneno substitution of education for experience is permitted.
Time in Grade Requirement: Applicants who have held a General Schedule (GS) position within the last 52 weeks must have 52 weeks of Federal service at the next lower grade or equivalent (GS-12).
Education
FOREIGN EDUCATION: If you are using education completed in foreign colleges or universities to meet the qualification requirements, you must show the education credentials have been evaluated by a private organization that specializes in interpretation of foreign education programs and such education has been deemed equivalent to that gained in an accredited U.S. education program; or full credit has been given for the courses at a U.S. accredited college or university. For further information, visit: https://sites.ed.gov/international/recognition-of-foreign-qualifications/.
Additional information

• Male applicants born after December 31, 1959, must complete a Pre-Employment Certification Statement for Selective Service Registration.
• You will be required to provide proof of U.S. Citizenship.
• This position requires a 1 year probationary period during which the agency evaluates your fitness and whether your continued employment advances the public interest. In making this determination, the agency may consider your performance and conduct; agency needs and interests; whether your continued employment supports organizational or Government goals; and whether it promotes the efficiency of the Federal service. Continued employment requires written certification that it advances the public interest.
• Direct deposit of pay is required.
• Selection is subject to restrictions resulting from Department of Defense referral system for displaced employees.
• If you have retired from federal service and you are interested in employment as a reemployed annuitant, see the information in the Reemployed Annuitant information sheet.
• This is a Human Capital & Resource Management Career Field position.
• Multiple positions may be filled from this announcement.
• Salary includes applicable locality pay or Local Market Supplement.
• Payment of Permanent Change of Station (PCS) costs is not authorized, based on a determination that a PCS move is not in the Government interest.

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 here: https://help.usastaffing.gov/Apply/index.php?title=Reasonable_Accommodations_for_USA_Hire
Expand Hide additional information
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
Benefits
Help
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Review our benefits
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.