General Statement of Job

The Report Writer Analyst supports the campus by working closely with individuals to develop reports and dashboards to provide support for data driven decision-making.

Specific Duties and Responsibilities

Essential Duties:

• Analyzes and writes detailed descriptions of the organizational reporting needs, program functions, and steps required to develop or modify current reports or dashboard components.

• Develops complex reports based on the campus ERP databases and ODS data tables and views.

• Develops reporting dashboards.

• Prepares time and cost estimates for completing projects.

• Performs other related duties as required.

Education, Experience, and Licenses

Prefer two plus years progressive related experience and/or training required; or an equivalent combination of education and experience.

Knowledge, Skills, and Abilities

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Requires the ability to use the computer programming languages of PL/SQL, SQL.

• Use GIT version control to maintain source code.

• Knowledge and experience with Banner Database and ODS reporting views.

• Knowledge and experience with SharePoint, PowerPivot and PowerView, Microsoft SQL Server, Microsoft Report Developer, and Power BI.

• Knowledge of the Higher Education computing environment.

• Requires strong analytical, problem-solving and collaborative skills.

• Requires proficiency in writing program narratives and understanding coding techniques, testing strategies, and application implementation.

• Ability to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community.

• Ability to effectively present information to administrators, faculty and staff.

• Ability to define problems, collect data, establish facts, and draw valid conclusions.

• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

• Ability to work in a positive team-oriented manner with a variety of people (students, faculty, administrators, staff, vendors and members of the public).

• Requires the ability to use small office equipment, including copy machines or multi-line telephone systems.

• Requires the ability to use computers for data entry.

Physical Demands/Work Environment

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to sit; use hands to finger, handle, or feel (including the use of a computer keyboard); and talk or hear (including the use of a telephone). The employee is occasionally required to stand; walk; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The employee must frequently lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

While performing the duties of this job, the employee is occasionally exposed to moving mechanical parts; high, precarious places; fumes or airborne particles; extreme heat; risk of electrical shock; and vibration. The noise level in the work environment is usually moderate.

NOTICE: The above job profile does not include all essential and nonessential duties of this job. All employees with disabilities are encouraged to contact Human Resources to review and discuss the essential and nonessential functions of the job. An employee with a disability can evaluate the job in greater detail to determine if she/he can safely perform the essential function of this job with or without reasonable accommodation.