Financial Analyst IV - CAP COS Print (https://www.governmentjobs.com/careers/houston/jobs/newprint/4755235) Apply  Financial Analyst IV - CAP COS Salary $2,910.59 - $3,514.91 Biweekly Location 611 Walker Street Job Type Full Time Job Number 35745 Department Finance Opening Date 12/09/2024 Closing Date 12/23/2024 11:59 PM Central + Description + Benefits + Questions POSITION OVERVIEW Applications accepted from: ALL PERSONS INTERESTED Job Classification: Financial Analyst IV Division: Financial Reporting & Operations Reporting Location: 611 Walker Street Workdays & Hours: MONDAY – FRIDAY 8:00 AM – 5:00 PM *Subject to Change* DESCRIPTION OF DUTIES / ESSENTIAL FUNCTIONS Coordinates and supports the development, implementation and monitoring of various financial activities, including preparation of full cost of service studies for the City of Houston and assist with the development of the City of Houston's Annual Indirect Cost Allocation Plan. RESPONSIBILITIES: + Identify the full costs of providing user fee services. + Establish revenue recovery and cost subsidy policy and recommendations. + Determine a defensible methodology and process to perform cost of service studies. + Apply General Accepted Accounting Principles (GAAP) and the Office of Management and Budget (OMB) Circular A-87 federal regulations when performing full cost of service studies. + Develop written results of cost-of-service studies. + Perform comparative user fee surveys, comparing the City of Houston user fees to other agencies. + Perform complex financial analysis and reconciliations. + Assist with the development of various cost models. + Develop data request schedules required to perform a full cost analysis and development of the annual Indirect Cost Allocation Plans in accordance with requirements to GAAP and 2 CFR Part 200, Uniform Administrative requirements, Cost Principles and Audit requirements. + Develop schedules with the proper data to calculate a full cost of service study and indirect cost rates. + Compile and analyze data; interpret results and draw conclusions and make recommendations. + Develop specialized reports working with a wide variety of financial data. + Document results of the analysis and study related to various cost elements. + Prepare and query SAP reports including interfacing with other City departments to successfully complete various analyses with quality results. + Represent Division Manager/Finance Department in meetings and gather information. + Negotiate solutions for problems of medium to high complexity as assigned by the Division Manager/Deputy Assistant Director. + Interpret administrative policies and oversee communication with department personnel regarding such policies. + Participate in evaluation and design of workflow, processes, various operations systems, etc. + Develop technological solutions and systems for continuous improvement programs and other appropriate applications. + Coordinate and conducts special long term and short-term projects. WORKING CONDITIONS This position is physically comfortable; the individual has discretion about walking, standing, etc. There are no major sources of discomfort in a normal office environment. MINIMUM REQUIREMENTS EDUCATION REQUIREMENTS Requires a Bachelor's degree in Finance, Accounting, Business Administration or a closely related field. EXPERIENCE REQUIREMENTS Six years of professional experience in finance, economics, budget analysis or a closely related field are required. SUBSTITUTIONS Experience cannot be substituted for the Bachelor’s degree requirement. A Master's degree in Finance, Accounting, Business Administration or a closely related field may be substituted for two years of the above experience requirement. LICENSE REQUIREMENTS: None PREFERENCES Preferences will be given to candidates with: + Prefer knowledge of Generally Accepted Accounting Principles (GAAP), 2 CFR Part 200 Office of Management and budget (OMB) guidelines and demonstrates abilities in handling various projects simultaneously developing cost models. + Experience in interpreting and remaining in compliance with federal and state regulations related to grants management. Special consideration will be given to applicants with: Experience in grant writing and management; SAP and financial reporting experience as well as applicants with strong Microsoft Office products such as Excel, Word, PowerPoint and Publisher. Work is substantially complex and varied and requires the interpretation of technical and detailed guidelines, policies and procedures in combination. Analytical ability is needed to gather and interpret data. **Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6.** GENERAL INFORMATION SELECTION / SKILLS TESTS REQUIRED - Yes The department will administer and the applicant must successfully complete a skills-assessment relevant to job description. SAFETY IMPACT POSITION - No If yes, this position is subject to random drug testing if a promotional position; candidate must pass an assignment drug test. SALARY INFORMATION Factors used in determining the salary offered include the candidate's qualifications as well as the pay rates of other employees in this classification. Pay Grade: 25 APPLICATION PROCEDURES Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during posting opening and closing dates shown. Applications must be submitted online at: www.houstontx.gov or call (832)393-6051. To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm If you need special services or accommodations, call (832)393-6051. (TTY 7-1-1) If you need login assistance or technical support call 855-524-5627. Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process. All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of the information provided. EOE - Equal Opportunity Employer The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy. The city offers a competitive benefits program, including competitively priced health coverage and a defined contribution pension plan. Benefits include: + Medical + Dental + Vision + Wellness + Supplemental Insurance + Life insurance + Long-term disability + Retirement pension + 457 deferred compensation plan + Employee Assistance Program + 10 days of vacation each year + 11 city holidays, plus one floating holiday + Compensable Sick Leave + Personal Leave + Flexible schedules + Hybrid-Telework for eligible positions + Professional development opportunities + Transportation/parking plan + Section 125 pretax deductions + Dependent Care Reimbursement Plan + Paid Prenatal, Parental and Infant Wellness Leaves + Healthcare Flexible Spending Account For plan details, visit http://www.houstontx.gov/hr/benefits.html 01 Are you a veteran who served on active duty in the Armed Forces (United States Army, Navy, Air Force, Marines Corps, or Coast Guard) for more than 90 consecutive days and received either an honorable discharge or a general discharge under honorable conditions? + Yes + No 02 Which best describes your education and experience? + Master's Degree or beyond in Finance, Accounting, Business Administration or a closely related field and AT LEAST four (4) years of professional experience in finance, economics, budget analysis or a closely related field. + Master's Degree or beyond in Finance, Accounting, Business Administration or a closely related field and LESS THAN four (4) years of professional experience in finance, economics, budget analysis or a closely related field. + Bachelor's Degree in Finance, Accounting, Business Administration or a closely related field and AT LEAST six (6) years of professional experience in finance, economics, budget analysis or a closely related field. + Bachelor's Degree in Finance, Accounting, Business Administration or a closely related field and LESS THAN six (6) years of professional experience in finance, economics, budget analysis or a closely related field. 03 Which area of concentration did you obtain your degree? + Accounting + Finance + Business Administration + Other + I have no degree 04 Which of the following best describes your experience in federal and state grants area? + Less than one (1) year of experience + One (1) year of experience + Two (2) years' experience + Three (3) years' experience + Four (4) years' experience + Five (5) years' experience + More than five (5) years' experience + I have no experience 05 Please indicate your level of proficiency in the Microsoft Office Suite. + BASIC MICROSOFT OFFICE SUITE: Create a new document, enter text, and save it; navigate in a document and perform a search; format cells, rows, and columns; modify a database and insert data from another; application; create title and bullet slides; work with text, drawn objects, and drawing tools. + INTERMEDIATE MICROSOFT OFFICE SUITE: Create mail merges, sort and filter them; customize toolbars; run and record Macros; filter data and manage a filtered list; create and modify some Macro commands; create, modify, and format charts; create basic Macros to automate forms and data entry; customize the appearance and functionality of reports; use hyperlinks and perform data integration. + ADVANCED MICROSOFT OFFICE SUITE: Manage Macro commands, create dialogue boxes, and understand the notions of Visual Basic application programming; use advanced functions (Names, VLOOKUP, IF, IS); work with Pivot Tables; manage Macro commands: concepts, planning, operations, execution, modification, interruption; use Visual Basic to create a public function or event procedures, or add general procedures in a form module; plan and examine an application, develop a distributed application design. + None of the above 06 Which of the following best describes your experience with SAP Financial Systems? + Less than one (1) year of experience + One (1) year of experience + Two (2) years' experience + Three (3) years' experience + Four (4) years' experience + Five (5) years' experience + More than five (5) years' experience + I have no experience 07 Please indicate which of the following you have strong knowledge of and have worked with on a daily or weekly basis. (Check all that apply) + Generally Accepted Accounting Principles (GAAP) + 2 CFR Part 200 Office Management and Budget (OMB) Guidelines + Ability to understand developing cost models + Interpreting and remaining in compliance with federal and state regulations related to grants management + Development of cost modeling and indirect cost allocation plans + None of the above 08 How many years of verifiable progressive professional experience do you have in financial analysis and reconciliation? + Less than one (1) year of experience + 1 - 2 years of experience + 3 - 4 years of experience + 4 - 5 years of experience + More than 5 years of experience + I have no experience 09 Please explain your progressive professional experience in financial analysis and reconciliation. (Please note: stating 'See Resume' may delay your application process) 10 How many years of verifiable progressive professional experience do you have in financial reporting, including SAP Funds Management? + Less than one (1) year of experience + One (1) year of experience + Two (2) years' experience + Three (3) years' experience + Four (4) years' experience + Five (5) years' or more experience + I have no experience 11 Please describe your experience in preparing Audit reports. (Please note: 'See Resume' may delay your application process) 12 Are you currently a City of Houston Employee? + Yes + No Required Question