Data and Reporting Analyst
Job no: 505138
Work type: Full Time Administrative
Location: Systems Office - Lawrence, IN
Categories: Administrative/Professional, Information Technology
|General Description of Position:
||The Data and Reporting Analyst is a key member of the data warehouse team and responsible for the creation, documentation, and support of college wide core/standardized reports from the colleges reporting database(s). This position may also provide end-user training on report writing software and support users in ad-hoc report creation.
Works closely with end-users to gather report requirements and ensure proper testing/validation.
Creates core/standardized reports from reporting database(s) using front end tools and SQL.
Adheres to standard coding conventions and best practices, including documentation and source control.
Trains end users in reporting database(s) and ad-hoc report creation.
Provides end user support on core/standardized reports and ad-hoc report creation.
Works with Data Warehouse Team to create/modify Extract, Transform, and Load (ETL) processes to aid in the creation of reports.
Monitors data warehouse environment to ensure proper execution and performance of reports.
Works with and provides guidance to information systems personnel or user agencies, for maximum utilization of college data.
Other duties logically associated with the position may be assigned.
SUPERVISION RECEIVED: Chief Technology Officer
SUPERVISION GIVEN: None
Bachelor’s degree or equivalent work experience required.
Must have at least 2 years of SQL development and report generation experience in a relational database environment.
Proven ability to deliver training/demonstrations to end-users, experience writing technical and end user training documentation.
Must have the ability to communicate effectively with a diverse group of end users; possess excellent interpersonal, oral and written communication skills, problem solving, and organizational skills, be customer service and team oriented.
Familiarity with a report writing tool such as Pentaho Business Analytics, Tableau, Looker, or Power BI required.
Must demonstrate ability to promote an inclusive environment that reflects the broad diversity and backgrounds represented by our students and employees and which every individual feels respected and valued.
Ellucian’s Banner ERP system.
Post-secondary education work experience in a functional area such as Human Resources, Finance, Financial Aid, Student Affairs, and Institutional Research or in Information Technology.
Familiarity with Python, shell scripting and UNIX.
Cloud-based technologies, such as Amazon Web Services.
“Big Data” analytic technologies.
|Team Ivy Referral:
|Special Instructions to Applicants:
Advertised: US Eastern Standard Time
Back to search results Apply now Refer a friend