Business Intelligence Analyst II

Salary: $67,150.00 - $73,025.50 Annually Location : Tulsa, OK Job Type: Full-time Job Number: 4490F-07-24 Department: Institutional Research and Assessment Opening Date: 10/11/2024 Work Schedule: 8 a.m. - 5 p.m., Monday - Friday Campus: Metro About TCC: Tulsa Community College is committed to creating positive work environments that support the success of the full range of our employees. We believe that employees who feel valued and respected will create policies, programs, practices, and services to effectively meet the needs and exceed the expectations of our students and employees. We are committed to hiring and retaining culturally competent faculty and staff at all levels of the organization who continue to deepen their skills and competencies to serve the full range of our community. Job Summary Responsible for data retrieval and analysis to support strategic decision-making, planning, and operational effectiveness across various college departments and collaborate with stakeholders, utilize data visualization tools, and employ statistical techniques to provide actionable insights. All persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. Please know TCC will only hire individuals who already possess a work visa that does not require sponsorship, or individuals on F-1 visas with work authorization. Essential Duties Query, clean, and analyze complex data sets from various sources, including student information systems (Banner, ODS, Cognos) and external data providers (NSC). Conduct comprehensive data analyses to identify trends, patterns, and correlations that support evidence-based decision-making. Design and generate interactive dashboards, reports, and visualizations to effectively communicate complex data insights to stakeholders. Create standardized reporting templates and automate data refresh processes to ensure timely and accurate reporting. Collaborate with end-users to understand reporting needs and provide recommendations for enhancements to reporting capabilities. Conduct ad-hoc analyses and data-driven research to support data-informed decision-making at all levels of the institution. Work with stakeholders to identify data needs and serve as a representative of the IRRA department in meetings or on committees. Assumes other responsibilities assigned by the Director of Institutional Research, Reporting and Analytics. Minimum Qualifications Bachelor's degree in Business Analytics, Information Systems, Statistics, or a related field. Degree requirement may be substituted with relevant and equivalent work experience. Experience interacting with administrative computing systems and large-scale databases requiring evidence of mastery in research and quantitative analysis. Experience with data visualization tools (e.g., Tableau, Power BI) and dashboard development. Strong analytical and problem-solving skills, with the ability to translate complex data into meaningful insights. Knowledge of descriptive and statistical analysis techniques, survey research, and research methodologies. Excellent written and verbal communication skills, with the ability to present complex information to non-technical audiences. Strong attention to detail, organizational skills, and ability to manage multiple projects simultaneously. Ability to work independently and collaboratively in a team-oriented environment. Preferred Qualifications Certifications in Tableau or Power BI, Business Analysis/Analyst, Python, and SQL. Master's degree in Business Analytics, Information Systems, Statistics, or a related field. Degree requirement may be substituted with relevant and equivalent work experience. 3 years proven experience in data analysis, business intelligence, or institutional research. Expertise and experience from a Higher Education Institutional Research Office or similar work environment may be substituted for education or other requirements. Familiarity with student information systems and higher education data (e.g., Ellucian, Banner, IPEDS, OSRHE). Mastery of R/Python/SPSS, SQL, Excel and Tableau/Power BI. Experience with IPEDS, HLC, Qualtrics, data warehouses and Cognos. TCC values our employees by providing a benefit package as a significant component of your compensation package. Our benefits have been designed to provide important protection for you and your family in the case of illness, injury, or even death. 01 How comfortable are you with working directly with relational databases and writing SQL queries versus using GUI-based tools for data analysis? Please share your preferred approach and provide reasons for your preference based on your past experiences. 02 You've been assigned to create a comprehensive report by combining data from three databases: student information, academic performance, and financial aid. How would you approach this task using SQL and data manipulation techniques to ensure data accuracy and integration? Please outline your steps and mention how you would handle any anticipated challenges. Required Question