Business Analyst II

Requisition: 202100041S

Occupational Category (Staff Positions Only): Professional

Hiring Salary: Monthly-Staff

Department: Controller

General Requirements:

Bachelor's degree with a major in Computer Science Management Information Systems (MIS), Computer Information Systems (CIS), business, finance, or related field from an accredited institution preferred. Two years relevant experience in technical report writing, the production of reports – including financial reports, data modeling, data analysis, or other applicable experience required. Working knowledge of SQL is required. Experience in Cognos report writing preferred. Experience in financial reporting, Ellucian Banner, or Oracle database experience is desirable. Experience with business processes and operations is preferred. A combination of education, experience, certifications, and training that would produce the required knowledge and abilities could be considered.

Nature & Purpose of Position/Usual Duties:

Designs and builds Business Intelligence front end reporting and dashboards utilizing all possible information delivery channels. This includes researching data availability and format, designing reports, and publishing the reports.

Advances financial data integrity and works with end users to follow through with associated action items.

Responsible for framework modeling, report writing (relational and multidimensional), and creating dashboard components using current Business Intelligence tools. Currently, SHSU utilizes the Cognos suite of products.

Works closely with business users to verify data requirements and access needs.

Develops report templates and implements BI standards.

Any other duties as may be assigned or required.

Primary Responsibilities (Staff Positions Only):

This position's main focus is writing technical reports using SQL and the current BI tool to access multiple databases. In addition, this position analyzes financial data and answers business questions by writing reports, dashboards, scorecards, and Structured Query Language (SQL) against relational and dimensional sources. Performs complex analysis of client issues to support solution engineering. Designs complex solutions. Addresses issues using agile methodology. Assists with complex requirements gathering from external staff. Assists with facilitation of meetings. Communicates effectively with internal and external constituents. Implements and develops test plans. Develops training materials. Facilitates design sessions to capture or solicit user needs and requirements. Sets action items and communicates progress to participants and stakeholders. Develops reporting solutions or objects to help answer business needs of the university and communicates progress with clients and stakeholders. Maintains Data Dictionary, reports specifications, and updates metadata. Generates package documentation for professional and business authors. Performs other related duties as assigned.