Business Intelligence Analyst
About The Position
The BI Analyst is responsible for creation and maintenance of both BI and operational reports for the University community. This includes IBM Cognos and Microsoft Power BI development, as well as analyzing transactional source systems to develop, manage, and assist in build of the data warehouse environment. Additionally, this position will be responsible for generating SQL queries to pull data directly from multiple source systems, including the enterprise data warehouse. The Enterprise Data and Analytics (EDA) team provides a strong business intelligence environment that helps the University make informed and strategic decisions. This groups manages the Enterprise Data Warehouse and provides reporting data access, and training.
Requirements
- Bachelors (or higher) degree in Business Intelligence, Computer Science, Information Systems, Information Technology, Technology, Business Administration, Marketing Analytics, Economics, Mathematics, Statistics, or similar field.
- At least three (3) years full-time (or part-time equivalent) experience which includes all the following:
- Developing and supporting business intelligence or operational reporting solutions, preferably in IBM Cognos, Microsoft Power BI, or similar BI tool.
- Developing complex SQL queries.
- Utilizing multiple database types, including but not limited to a relational-style database such as Oracle or SQL.
- Interacting with end-users and key stakeholders on business intelligence, data warehousing, or operational reporting initiatives.
- Using and/or analyzing data structures in a transactional source system, such as an ERP.
- Using operational and analytical database concepts.
- Must be able to complete the following with or without a reasonable accommodation: Remain at a workstation for extended periods.
- Must be able to complete the following with or without a reasonable accommodation: Distinguish colors on a monitor.
- Must be able to complete the following with or without a reasonable accommodation: Effectively communicate on a daily basis.
- Applicants for this position must be authorized to work in the U.S. without ISU sponsorship.
- All work under this appointment is required to be performed from within the State of Illinois.
- If hired, out-of-state candidates must establish Illinois residency within 180 calendar days from the start date for this position.
Responsibilities
- Creation and maintenance of BI and operational reports for the University community.
- IBM Cognos and Microsoft Power BI development.
- Analyzing transactional source systems to develop, manage, and assist in the build of the data warehouse environment.
- Generating SQL queries to pull data directly from multiple source systems, including the enterprise data warehouse.
- Analyze data from systems across campus to ensure accuracy, completeness and reliability of the data to be used in reporting.
Benefits
- Insurance benefits , including health, dental, vision, and life
- Retirement and supplemental retirement planning options
- Tuition waiver benefits available to staff as well as their eligible dependents
- Paid holiday / administrative closures during Thanksgiving and Winter Breaks
- Paid benefit time
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
501-1,000 employees
