Business Analyst

Business Analyst

Summary of Job Duties and Responsibilities provides, implements, maintains, and optimizes applications; ensures integrity and proper functionality of applications; coordinates user needs with application design and system architecture; assists users in use of applications and application interfaces; obtains and maintains expertise in CAW data sources; maintains file, database, and application servers; compiles and maintains computer files and records; enters, queries, retrieves, and plots system data; consults, coordinates and communicates with other departments and I.S. Staff; performs other essential duties as assigned.

Knowledge, Skills, and Abilities:

- Knowledge of relational database software

- Knowledge of relational database programming with Structured Query Language (SQL)

- Knowledge of Microsoft Windows OS

- Knowledge of Microsoft Windows Server OS

- Knowledge of Microsoft (MS) Access

- Knowledge of MS SQL Server OR similar RDBMS

- Knowledge of use of data processing systems and equipment

- Knowledge of system software concepts, design and systems analysis, including business process and entity relationship analysis methods

- Knowledge of limitations and use of data processing systems and equipment

- Knowledge of structured query language (SQL) tools

- Knowledge of system design principles, methodologies and tools, including those applicable to both client server and cloud environments

- Knowledge of database techniques.

- Knowledge of basic project management methods, tools, and techniques

- Knowledge of cloud services platform like Microsoft Azure or other cloud service

- Knowledge of Business Intelligence (BI) tools and products

- Knowledge of fundamental front end languages such as HTML, CSS, and JavaScript.

- Knowledge of scripting languages such as Python.

- Knowledge or web services or API’s

- Knowledge of creation and consumption of REST and SOAP services

- Ability to design relational database structures

- Ability to analyze data structure requirements and recommend solutions

- Ability to think through a logical sequence of necessary events in terms of computer language to produce desired end product

- Ability to communicate effectively, both orally and in writing

- Ability to use interpersonal skills to establish effective working relationships with users

- Ability to study technical reference material independently and apply the principles learned to keep job skills updated

- Ability to interpret and translate non-technical user needs into proper network and system specifications

- Ability to adapt to continuous rapid change in technology and job requirements

- Ability to understand and take advantage of the complex relationships between hardware, operating software, application programs and network environment

- Ability to work with minimal supervision

- Ability to train and assist users in use of systems

- Ability to create standards for and maintain documentation

- Ability to produce diagnostic reports using SQL tools

- Ability to develop, deploy, and maintain BI interfaces which include query tools, dashboards, ad hoc reporting, and data modeling tools.

- Ability to maintain confidentiality of information

- Ability to interview business users to develop software solution requirements

- Ability to develop applications and reports that support identified requirements

- Skilled in problem solving and multitasking techniques

- Skilled in database (SQL) management applications

Minimum Qualifications

- Bachelor’s degree in computer science or equivalent degree

- Five (5) years of experience in computer systems including five (5) years of experience using SQL tools, five (5) years of experience with enterprise Business Intelligence (BI) tools and five (5) years’ experience in maintaining MS Access databases.

Preferred Qualifications

Knowledge of XML, HTML, CSS, Visual Basic for Applications, VB .NET, Java, JavaScript, Python, SSRS, Cloud Services; Cognos and BI360

Special Qualifications

- Must pass a criminal background check

- Must maintain a personal telephone due to subject to call out

- Must be a high-performing, innovative, values-driven, informed, and passionate individual

How to apply

Visit the website: www.carkw.com/careers/.

Work Conditions

Works in a heated and cooled typical office environment.

The above describes the general content and requirements for this job. It is not intended to be an all-inclusive list of duties, responsibilities, or requirements.

Central Arkansas Water is an equal opportunity employer that doesnt discriminate in its employment practices.

Job Type: Full-time

Pay: From $85,072.00 per year

Benefits:

- 401(k)

- 401(k) matching

- Dental insurance

- Flexible spending account

- Health insurance

- Health savings account

- Life insurance

- Paid time off

- Professional development assistance

- Retirement plan

- Tuition reimbursement

- Vision insurance

Ability to Commute:

- Little Rock, AR 72202 (Required)

Ability to Relocate:

- Little Rock, AR 72202: Relocate before starting work (Required)

Work Location: In person