Business Intelligence and Reporting Analyst
Who are we looking for? We are looking for a skilled data professional with a passion for problem-solving, analytics, and technical insight!
What will you work on? The Business Intelligence & Reporting (BIR) Analyst will provide analysis for administrative processes and workflows, quantitative and qualitative data from internal and external data sources, and related activities. This data will be used to create reports, tools, and frameworks to support the university in making effective, data-driven business decisions.
Additionally, the BIR Analyst will support assigned projects such as creating/modifying existing ASP.net applications and retrieving data from API interfaces.
Who will you work with? The BIR Analyst collaborates closely with colleagues from assigned departments across campus to achieve shared objectives. The BIR Analyst reports to the Director of Business Intelligence and Reporting and is a member of the Campus Technology Services (CTS) division.
- Communicate frequently with users to define required inputs and desired outputs for reporting needs and to analyze business processes to improve efficiencies
- Participate in the development and improvement of methods that measure and analyze data sets and processes
- Support and maintain existing web applications and related projects
- Develop documentation of business processes and created reports
- Oversee the management and maintenance of various existing applications and adjusts those applications as need arises
Why work for us?
We offer a lively campus work environment and are proud to offer a comprehensive benefits package including:
- Retirement – up to 5 percent of base pay with employee contribution of 5 percent
- Health, dental and vision insurance
- University pays 70 percent of employee premium and 52 percent of total family coverage
- Flex spending medical debit card offered
- Up to 14.5 paid holidays per year
- Paid sick leave
- Paid vacation leave
- University-paid life and disability insurance
- Shared leave for extended catastrophic illnesses
- Discounted meals
- Strong support for continuing education
- Tuition remission - 100% undergraduate
- Flex schedule allowing class attendance during the workday
- Opportunities for dependents of employees to attend OCU or 660 other private universities tuition-free
- Summer hours (Monday through Thursday, 8am – 5.30pm) from May to September.
Additional Programs and Benefits
- Employee Assistance Program (EAP) – Confidential resource available to employees and family members to assist with a wide range of work/life balance issues
- Voluntary Benefits – The university offers several payroll-deducted voluntary plans including reduced gym membership at Gold’s Gym, accidental injury and critical illness policies, auto insurance through Liberty Mutual, and other offers that vary by plan year
- Fitness Center Access – Employees may use the on-campus fitness center at no cost. Currently, the center is closed to faculty and staff due to the pandemic but will reopen when conditions improve.
- Free and/or Discounted Event Admission – Employees may attend athletic events at no cost when competition resumes. Other event tickets may be discounted.
- Wellness Time – Staff get 60 minutes of wellness time to use in on-campus activities each week.
- Tuition Exchange Programs – We participate in two tuition exchange programs that offer opportunities for scholarship awards to qualifying dependents seeking undergraduate degrees at participating institutions
- Discounted Meals – Employees pay a reduced rate for meals in the cafeteria. Currently, the Cafe does not offer a dine-in option for employees, however, the discounted rate applies for to-go meals. It is expected that the Cafe will reopen to employees when pandemic conditions improve.
Salary will be commensurate with experience and qualifications with an anticipated range of $60,000 to $73,000 (annual equivalent).
- Constantly operates a computer and other office machinery.
- Constantly visually identifies, observes, and assesses.
- Frequently communicates with university constituents.
- Frequently remains in a stationary position (standing and/or sitting). Occasionally moves to accomplish tasks and/or to get from one worksite to another.
- Occasionally moves common office materials.
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 (in accordance with ADA requirements) may be made, upon request, to enable individuals with disabilities to perform essential functions.
- Work is primarily indoors, but requires the incumbent to be in an outdoor environment when traveling between campus buildings or off campus.
- Standard office hours are 8:00 a.m. to 5:00 p.m., however, incumbent must be flexible to insure the accomplishment of job functions.
- Off-campus, state and regional travel may be required.
- May be exposed to frequent noise caused by telephone, computers, and office equipment.
*It is possible that this position may be permitted to work remotely.
**Posting format updated 6/16/2021.
- Proficiency in SQL
- Knowledge of C# and ASP.Net Web Applications
- Knowledge of Tableau reporting and dashboard design
- Skill in quality control as well as the ability to develop and maintain detailed documentation of work performed
- Strong understanding of relational database structures, theories, principles, and practices
- Knowledge of STAR schema and Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) design principles
- Ability to research, learn, and apply new programming concepts/technologies at an acceptable pace
- Strong abilities in analyzing and improving efficiencies of business processes
- Ability to consult with end-users on business needs, translate business needs into analytics/reporting requirements, and work with the end-user to ensure needs have been successfully met
- Proficiency in Microsoft SQL Server Report Builder
- Knowledge of consuming data from REST/SOAP API sources
- Strong knowledge of Oracle SQL/T-SQL
- Knowledge of Object-Oriented Programming and SOLID Programming Design Principles
- Knowledge of Ellucian’s Banner or similar higher ed/municipal ERP system
- Strong abilities with SQL Server Integration Services (SSIS) to build ETL/ELT pipelines
- Knowledge of Data Warehouse design and maintenance principles
A bachelor's degree in data analytics, information systems, computer sciences, or a related field is required.
At least one year of related experience collecting and analyzing data from internal and external data sources using business intelligence platforms and languages such as Tableau, SQL, PowerBI, RStudio or a similar reporting tools is required. Three or more years of related experience is preferred.
A suitable combination of education and experience may be substituted to meet minimum qualifications.