Employment at ArtCenter

Information Technology

Senior Business Intelligence Engineer

The Senior Business Intelligence Engineer is responsible for providing application and data analysis support to the College’s ERP and Business Intelligence applications. This position is responsible for application support, problem resolution, data extraction, query programs, and BI application development with a strong emphasis on data modeling, data transformation rules, and Cognos BI administration. This position will work closely with many different client organizations and groups such as executive management, departmental directors, administrative, and technical staff in an effort to build and launch new BI initiatives.

Reports to: Director, Application Services

FLSA status: Exempt

Salary grade: 10


Job posted 2/3/20. Applications will be accepted until the position is filled. Qualified applicants should send application materials including employment application to HR@artcenter.edu and and reference “Business Intelligence Engineer” in the subject line. Applications must include:
  1. Cover letter that addresses your interest in and how you meet the minimum requirements of the position.
  2. Current resume that includes educational and professional experience.
  3. Employment application.

Download ArtCenter Application

Qualifications

  • Bachelor’s degree in Computer Science, Business Administration, Information Systems, or equivalent discipline
  • 5 years of experience providing application and Business Intelligence analysis, design, development, deployment, and support
  • Strong interpersonal and communication skills
  • Comprehensive knowledge of Finance, Accounting, Payroll, HR, and Student Administration
  • Knowledge and understanding of statistical modeling, forecasting, trending, and prediction
  • Knowledge of project management and methodology
  • Knowledge of Ellucian Data Orchestrator, Ellucian Analytics and Informer for Ellucian
  • Working knowledge of the following DBMS: multi-value databases (Universe, Unidata, Informix), Oracle 10/11g, and Structured Query Language (SQL)
  • Knowledge of Envision programming, Unibasic and structured programming techniques is a plus
  • Knowledge of Shell programming (C, Korn, Bourn, etc.) and Unix systems (Sun Solaris, Red Hat Enterprise Linux)
  • Ability to handle all information with tact and discretion and recognizes the confidential nature of ArtCenter business
  • Demonstrated experience in and a commitment to diversity, and the ability to establish and maintain effective working relationships within Art Center’s diverse communities
  •  

Preferred Qualifications

  • Experience supporting Ellucian Colleague or other higher education systems such as Banner and PeopleSoft
  • Knowledge of Microsoft IIS and ASP is a plus
  • Experience in Higher Education


Essential Functions

Application and Data Analysis Support — 95%

  • Develop, design, and create custom Cognos BI reports for multiple business areas across campus by discussing and understanding business objective and goals, gathering requirements, and analyzing business needs and procedures, utilizing various types of database technologies and systems for pulling, sourcing, and querying information (i.e. Data Warehouse, Operational Data Store, Stage, etc.)
  • Evolve the BI environment with new forms of BI tools (i.e. dashboards, drill-down, self-service, etc.), and engineering methods to improve information dissection and dissemination, as well as report delivery systems, in order to help the College make strategic decisions and implement business improvements
  • Maintain and support the BI environment by working with the Technology staff to manage the BI server and development environment, including software maintenance and system security for the BI environment
  • Perform institutional data analysis and report generation in support of the requirements by the agencies of higher education industry, such as WASC, HEADS, NASAD, IPEDS, and AICAD
  • Work with client organizations to ensure accurate analysis of data and timely creation of BI reports — client organizations include, but are not limited to, Enrollment Services, Admissions, Finance, Accounting, HR, and Department Chairs Office

Non-Essential Duties — 5%

  • Keep abreast of latest technology trends and methodology
  • Serve on college-wide committees
  • Other duties as assigned

Mandatory Duty to Report

All employees who know or have reason to know of allegations or acts that violate ArtCenter’s Title IX Policy prohibiting discrimination, harassment, retaliation, sexual harassment, sexual misconduct, sexual violence, dating violence, and stalking shall promptly inform the DHR Administrator and Title IX Coordinator, or designee or the Assistant Dean of Students or designee. Faculty with a mandatory duty to report are required to disclose all information including the names of the parties, even where the person has requested their name remain confidential.

Pursuant to the California Child Abuse and Neglect Reporting Act (CANRA), all employees who know of or have reason to suspect child abuse or neglect involving alleged victims under age 18 shall promptly inform local law enforcement or the county welfare department.


Physical Demands and Working Environment

The conditions herein 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 job functions.

Environment: Work is performed primarily in a standard office setting with frequent interruptions and distractions; extended periods of time viewing computer monitor; interactions with other individuals. Due to the nature of the work environment, there is regular exposure to fumes, chemicals, dust and noise.

Physical: The position is generally performed in an office setting. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight (up to 50 pounds); to operate modern office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information. Regular and consistent attendance are required for most positions. This position may require some evening and weekend hours.

Vision: Must be able to have the visual capacity to perform activities such as preparing and reading reports, viewing a computer terminal and other normal office work with or without correction.

Hearing: Must be able to communicate effectively in the course of normal office communication or exchange ideas with or without correction.


ArtCenter College of Design is committed to excellence through the establishment of a diverse faculty and staff that best represents our student body and its surrounding communities. The College considers qualified applicants for employment without regard to race, color, religion, national origin, age, gender, gender identity/expression, sexual orientation, genetic information, medical condition, marital status, veteran status, or disability. Applicants who wish to request an accommodation for a disability may contact the Human Resources Department at (626) 396-2270.