Business Systems Administrator

City of Durham; Durham (NC); On-site; USD 79,000 - 95,000; Full time

Job summary

City of Durham is seeking a skilled Business Systems Administrator in the Finance Department. The role focuses on technical leadership, Oracle Fusion ERP administration, and data-driven support for finance operations.

You will troubleshoot issues, manage data quality, and guide end-user training. The position emphasizes collaboration across departments, with responsibilities ranging from system configuration to reporting and process improvements.

Qualifications

• Bachelor’s degree in computer science, information technology, or related field.
• Seven years of professional IT experience, including ERP systems, reporting, and project involvement.

Responsibilities

• Serve as subject matter expert and technical lead for Finance IT systems.
• Support post-Oracle Fusion ERP implementation, troubleshoot issues, and configure data.
• Develop reports using SQL, OTBI, and SmartView; train and document processes.
• Collaborate with manager, departments, and vendors; manage system improvements.
• Lead/tie with procurement, budget forecasting and data quality reviews.

Skills

Analytical thinking

Technical leadership

Data analysis

Training

Documentation

Education

Bachelor’s degree in computer science or related field

Tools

Oracle Fusion ERP

SQL

OTBI

SmartView

FDI

Job description

Work, Serve, Thrive. With the City of Durham
Advance in your career while making a real difference in the community you serve.

Business Systems Administrator – Finance Department

Hiring Range: $79,058.00 - $94,869.60 Annually

Hours: 8:00 AM - 5:00 PM

Join one of the highest fiscally rated entities in the country. The City of Durham’s Finance Department promotes sound management and stewardship of taxpayer dollars by helping the City Council, City Manager and City departments manage their financial resources and leading risk management administration and training. If sound fiscal management is what you’re about, join our team!

Devoted to providing technical support, administration and maintenance/management of a department's technology systems and equipment, including user/technical support, data/database management and data extraction/analysis. Supervise and/or serve as the primary and lead administrator of a department's information technology system(s) and/or oversee technology support for a department. May supervise a team of non-exempt support staff, supervise temporary staff, lead professional staff, or supervise two or more professional staff. Responsible for serving as a designated subject matter expert, performing complex analysis and providing technical leadership for a department's information system. Decision making includes providing management objectives, establishing work goals and objectives of a unit to carry out management direction, and selecting the method to address a problem or issue, subject to the constraints established by management objectives and direction.

Primary responsibilities will include serving as the subject matter expert and technical lead, collaborating with and under the direction of, the Business Systems Manager, in post-Oracle Fusion ERP implementation responsibilities, including troubleshooting issues, assisting end-users, providing recommendations for system configuration, data conversion and reconciliation, training, and documentation. Position will also be responsible for reviewing data for accuracy and quality; researching, analyzing, and updating data; assessing business needs; configuring systems; responding to user requests; troubleshooting systems or network issues; writing reports and queries; administering servers or networks; installing and configuring updates; backing up data; configuring access; and performing related duties, as assigned.

• Performs complex analysis and provides technical leadership for a department's information systems; coordinates technology support and the design, installation, and modification of hardware, network, and software solutions; plans, assigns, and evaluates work; trains staff; manages and assigns projects; and assesses business and technology requirements.
• Plans and implements process improvements; and ensures operational efficiency, system integrity, and compliance with contracts and applicable regulations, standards, policies, and procedures.
• Coordinates the preparation of, and prepares, maintains, reviews, and/or submits policy, operational, financial, and related reports, records, user guides manuals, contracts, agreements; designs and manages databases and systems; researches, analyzes, compiles, extracts, digitizes, and/or reviews data; reviews work and the work of others for accuracy, completeness and compliance with contracts and applicable regulations, policies, and procedures.
• Manages procurement processes; researches and evaluates products, services, and processes; reviews and approves expenditures; orders supplies; researches, analyzes, and reports on financial, vendor and operational information; prepares cost estimates and financial forecasts; prepares maintenance schedules; inspects and tests systems and equipment to determine purchase or replacement needs; and makes budget and procurement recommendations.
• Collaborates with Business Systems Manager, Department Management, City departments, and/or external agencies; convenes, facilitates and attends meetings and conferences; prepares and makes presentations; provides training; provides subject-matter expertise and consulting; resolves issues; and conducts negotiations, as assigned.
• As assigned, incumbents may serve as a lead worker, assigning work and monitoring work completion or supervise two or more non-exempt, temporary, or professional (exempt) staff including conducting performance evaluations, coordinating training, and implementing hiring, discipline, and termination procedures.
• Providing software and hardware support primarily for the newly implemented Oracle Fusion ERP, and other applications and equipment used by the Finance Department including banking-related software, as needed
• Gathering and analyzing data; troubleshooting issues with functionality; modifying setup of software to accommodate ongoing changes in operations
• Creating, developing, and editing reports which may include use of SQL, FDI, OTBI, SmartView or other Oracle-related reporting tools
• Facilitating task team(s) for ongoing development and maintenance of systems within Finance.
• Working directly with vendors to address complex system errors and/or issues.
• Developing and facilitating training and documentation on Oracle Fusion applications specific to Finance.

• Bachelor’s degree or equivalent in computer science, information technology, or directly related field
• Seven years of related professional information technology experience or equivalent combination of education and experience, which includes ERP systems, modules, and/or integrations, end-user support, report writing. and some project management experience.

• Oracle Fusion - Finance, Purchasing, General Billing & Payroll modules a plus
• Report writing experience using SQL or Oracle report building tools a plus