Fiscal Analyst Print (https://www.governmentjobs.com/careers/durhamnc/jobs/newprint/4778633) Apply  Fiscal Analyst Salary $62,608.00 - $97,032.00 Annually Location Durham, NC Job Type Full time with benefits Remote Employment Flexible/Hybrid Job Number 25-05246 Department Water Management Opening Date 02/07/2025 Closing Date 2/24/2025 11:59 PM Eastern + Description + Benefits + Questions Position Description Work, Serve, Thrive. With the City of Durham Advance in your career while making a real difference in the community you serve. Hiring Range: $62,608.00 - $79,831.00 Work Day/Hours: 8:00 am. - 5:00 p.m. The City of Durham’s Department of Water Management (DWM) (https://www.durhamnc.gov/944/Water-Management) wants YOU to join our team of more than 380 talented and dedicated employees that provide critical water and sewer services for Durham’s 309,000 plus residents. Not only do we deliver the Best Tasting Water in the state to our customers each and every day, but we also make sure that the wastewater leaving our facilities is carefully treated to protect the environment. We have a wide-ranging variety of positions open to match your skill set – mechanics, engineers, maintenance specialists, technicians, customer billing techs, and much more. If you have a passion for managing vital water resources, protecting the environment, providing excellent customer service, and keeping the water and wastewater in the pipes, bring your skills and talent to Durham! This position is responsible for handling accounting and tracking expenses of the Department of Water Management’s Capital Improvement Plan (CIP) projects. CIP projects are multi-year, multi-part construction projects funded by several different funding sources. The position serves as a designated subject matter expert, ensuring that accounting principles are followed as phases of projects are started, completed, or re-organized. In addition, the position will have the vital role of facilitating clear and successful communication across a range of CIP stakeholders including utility engineers, City budget administrators, and construction firms, among others. Duties/Responsibilities Capital Improvement Plan (CIP) Implementation and Facilitation + Reviewing and processing CIP contract administration requests, transfers, and adjustments + Making journey-level entry into the City’s various project management, contracting, and budgeting systems + Providing accounting oversight on capital spending + Contributing to the development of the annual CIP ordinance, calculating the funds each major project should receive from the different revenue sources, such as a dedicated CIP account or a bond issuance + Researching and recommending new potential funding sources + Leading collaboration with Water Management staff, City Budget staff, state and federal agencies, vendors, and other internal and external stakeholders + Assisting with data collection, analysis, and reporting related to the City’s Capital Improvement Plan Financial Analysis + Developing reports on financial metrics for capital improvement projects and monitoring financial performance + Independently evaluating and analyzing issues that arise and making recommendations to address them + Projecting future capital costs and related revenues as part of the annual water and sewer rate-setting process + Collecting data and analyzing project cash flow and other trends Minimum Qualifications & Experience + Bachelor’s degree or Equivalent in accounting, business or public administration or a directly related field + One year of experience in area of assignment + Expertise in Microsoft Excel Additional Preferred Skills + Additional analysis tools, like SQL, Access, Power BI, Python, R, etc. will be very helpful, but are not required Benefits – General Full-Time Employees + 12-13 paid holidays per year + 13 standard work days of vacation per year + 13 standard work days of sick leave per year, which accumulates indefinitely; sick leave may be used toward early retirement + 2 weeks paid military leave per year + Medical, dental, vision, and supplemental life insurance plans + State and City retirement plans + Short and long term disability plans + Paid temporary disability leave for specified conditions + City contribution of 13.6% into the N.C. State Retirement System + Paid funeral leave + Employee Assistance Program - personal and family counseling + Paid life insurance equal to annual salary + 48 hours for volunteer work each year* + 4 hours parental leave each year + Workman's Compensation Insurance + 457 Deferred Compensation Plans Benefits - Part-Time (1,000 hours or more per year) + 401(k) retirement plan (5.0% of salary) + State retirement plan Benefits Part-Time (Average 30 hours per week over 12 month period) + 401(k) retirement plan (5.0% of salary) + State retirement plan effective first day of the month following date of hire + Health insurance effective first day of the month following date of hire + Dental and life insurance, after one year of service + Pro-rated vacation, pro-rated sick, pro-rated floating holiday, parttime holiday pay (based on scheduled hours for that day) after one year of service 01 Where did you first hear about this opportunity? + City of Durham Website + Walk in + Job fair + Employee referral + Professional organization ***Please list the organization in "other" box below*** + Internet posting ***Please list the specific web site in the "other" box below*** + Craig's List + Facebook + LinkedIn + GlassDoor + governmentjobs.com + Monster.com + Indeed.com + Employment Security Commission + Magazine/Newspaper + Other 02 If you listed "other" above please give specific web site, organization, or publication. 03 Please select your highest level of COMPLETED education. + Less than a High School Diploma or Equivalent (GED, HiSET, TASC) + High School Diploma or Equivalent (GED, HiSET, TASC) + Associates Degree + Bachelor's Degree + Master's Degree + Doctoral Degree (PhD, Juris Doctorate) 04 How many years of related experience do you have? + No related experience + Less than 1 year of related experience + 1 year but less than 4 years related experience + 4 years but less than 8 years related experience + 8 or more years related experience 05 Do you have any prior work experience with analysis tools? (such as SQL, Access, Power BI, Python, R, etc.) + Yes + No 06 Please list any additional analysis tools (such as SQL, Access, Power BI, Python, R, etc.) that you have experience with 07 How would you rate your experience level with MS Excel? + No experience + Beginner level + Intermediate level + Advanced level + Expert level 08 Please briefly describe a complex operation you solved with Excel: Required Question