Posted 2d ago

Business System Analyst

@ Cape Fear Public Utility Authority
Wilmington, North Carolina, United States
$84k-$124k/yrOnsiteFull Time
Responsibilities:supporting systems, developing reports, writing SQL
Requirements Summary:Bachelor's in IT/IS/Business required, 2 years supporting business applications, experience with ERP/CMMS preferred, Python preferred, strong SQL and reporting skills, system administration and user support experience.
Technical Tools Mentioned:ERP, CMMS, Python, SQL, ETL
Save
Mark Applied
Hide Job
Report & Hide
Job Description

About the Department

The Business System serves as a functional and technical expert for critical enterprise applications that support CFPUA's core business processes including customer billing, finance, human resources, meter data management, work order management, and asset maintenance systems.
The incumbent supports system administration and lifecycle management, develops and maintains reporting and analytics, and partners with business units on continuous improvement initiatives that leverage technology to improve efficiency, effectiveness, and service delivery.  This position is assigned to pay grade R35.

Position Duties

  • Serves as a primary functional and technical resource for assigned enterprise applications.
  • Provide ongoing operational support for business systems through the maintenance of a helpdesk queue including intake, triage, and prioritization of issues and requests; investigation and resolution of application related problems; and coordination with IT staff and vendors as needed.
  • Maintain and configure application settings to support approved business processes and regulatory requirements.
  • Coordinate and support system upgrades, patches, and vendor releases including release planning and impact analysis; user acceptance testing (UAT) and post-release validation; and documentation of changes and outcomes.
  • Collaborate with software vendors to resolve application defects and implement enhancements based on business requirements.
  • Support system integrations by assisting with requirements definition, testing, and validation.
  • Assist with application security administration including role design, access reviews, and segregations of duties.
  • Develop and maintain system documentation and provide training or guidance to end users.
  • Serve as the primary resource for translating business reporting and information requirements into reliable, repeatable system outputs.
  • Work with business process owners and the Strategy and Performance Team to understand what data is needed, how it should be structured, and how it will be used, without serving as the primary interpreter of results.
  • Design, build, and maintain standard operation and management reports; data extracts and datasets; and automated or semi-automated extract, transform and load (ETL) processes.
  • Develop and maintain SQL queries, views, and data models that support reporting, dashboards, and downstream analysis performed by business units and the Strategy and Performance Team.
  • Maintain documentation describing data sources, transformations, assumptions, and dependencies to enable self-service analysis by managers and analysts.
  • Serve as a functional and technical advisor on how enterprise applications support end-to-end business processes.
  • Partner with business process owners to understand current workflows, system usage, and operational pain points.
  • Collaborate closely with the Strategy and Performance Team to support continuous improvement initiatives ensuring Business process changes are supported by appropriate system configuration; reporting and data structures align with defined performance measures; and system impacts of proposed changes are clearly understood.
  • Provide system and process insight during improvement initiatives led by business units or the Strategy and Performance Team including process redesign efforts; performance management initiatives, and technology enabled efficiency improvements.
  • Recommend configuration changes, workflow enhancements, or reporting updates that enable improved process performance and better decision making.
  • Support change management efforts by helping translate process changes into system changes; assisting with user readiness, documentation, and training needs; and coordinating testing and validation activities.
  • Perform other related job duties as assigned.
In the event of an emergency, all employees are considered essential personnel and may be required to perform alternate duties

Minimum Qualifications

  • Bachelor's degree in Information Technology, Information Systems, Business Administration, or a related field.
  • Two (2) years of experience supporting business applications, business systems analysis, or graduate degree in Information Technology, Information Systems, Business Administration, or a related field 
  • Experience with enterprise grade systems such as ERP, CMMS, billing, financial, or asset management systems preferred.
  • Experience with Python for automation or data analysis is preferred.
  • Demonstrated experience working with relational databases and writing SQL queries.

Other Qualifications

Other Essential Job Specifications

YESNO
Use interpersonal skills such as seeing, hearing, and speaking to develop positive interactions with customers.
X
Comprehends and uses technical or professional language, either written or spoken, to communicate complex ideas.
X
Performs numerical operations using basic counting, adding, subtracting, multiplying, or dividing.
X
Performs complex quantitative calculations or reasoning using algebra, geometry, statistics, or abstract symbols.
X
Requires travel between CFPUA sites.
X
Use or repair of small/light equipment (power tools).
X
Use or repair medium equipment and machinery (vehicles, commercial mowers).
X
Use or repair heavy or complex machinery (HVAC systems, construction equipment, water plants).
X

Physical Requirements
None: 0 hours or 0% of scheduled shift
Some: Up to 2 hours or 20% of scheduled shift
Frequent - 2 to 5 hours or 20% to 60% of scheduled shift
Very Frequent - More than 5 hours or 60% to 100% of scheduled shift
NONESOMEFREQUENTVERY FREQUENT
Minimal physical exertion. Very light physical work at desk or counter level with intermittent periods of sitting, standing, and walking. May involve data entry, telephone work, or use of various office equipment.
X
Same as above with the addition of standing/sitting/walking for lengthy periods of time. May involve light physical exertion due to pushing, pulling, carrying, and lifting weights up to 20 pounds.
X
Physical exertion involving pushing, pulling, and lifting up to 20 pounds. May require prolonged standing and/or walking during which time objects are transported. May require occasional bending, squatting, and reaching.
X
Sustained physical activity throughout the work period. Performs work tasks involving pushing, pulling, carrying, and lifting up to 50 pounds. May require bending, squatting, stooping, reaching, climbing, or walking in addition to other physical demands.
X
Sustained physical activity throughout the work period. Performs work tasks involving pushing, pulling, carrying, and lifting up to 50 pounds. May require bending, squatting, stooping, reaching, climbing, or walking in addition to other physical demands.
X


Benefits



We offer a complete benefits package to full-time employees including health care, dental, vision, retirement, deferred compensation plans, flexible spending accounts, life insurance, long-term disability, holidays, vacation, and sick leave. Part-time employees who work an average of 30 hours per week over the course of a year, receive benefits on a pro-rated basis. To learn more details, visit our Benefits Page.


Agency Information

Employer
Cape Fear Public Utility Authority
Address

235 Government Center Drive








Wilmington, North Carolina, 28403
Phone
910-332-6570
Website

http://www.cfpua.org