Business Intelligence Analyst II
Salary:
$51,452.
00 - $59,170.
00 AnnuallyLocation :
Tulsa, OKJob Type:
Full-timeJob Number:
4706F-07-23Department:
Institutional Research and AssessmentOpening Date:
07/24/2023Work Schedule:
Monday through Friday, 8 a.
m.
- 5 p.
m.
Campus:
MetroAbout TCC:
Tulsa Community College is committed to creating equitable and inclusive work environments to 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 increasingly diverse student populations.
We encourage candidates to apply who have demonstrated capacity to create inclusive work environments, to work effectively on increasingly diverse teams, and to serve the increasingly diverse college community.
We are committed to hiring and retaining a racially diverse, culturally competent staff at all levels of the organization who not only reflect the demographics of our students, but also 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.
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 Administration, Information Systems, Statistics, or a related field.
Experience with business intelligence software, such as relational databases and data manipulation and analysis using SQL, Excel, and statistical software (e.
g.
, R, Python, SPSS).
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.
Require demonstrated 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 Master's degree in Business Administration, Information Systems, Statistics, or a related field.
Degree requirement may be substituted with equivalent work experience.
Two years of proven experience in data analysis, business intelligence, or institutional research.
Familiarity with student information systems and higher education data (e.
g.
, IPEDS, OSRHE).
Mastery of R/Python/SPSS, 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 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 Recommended Skills Analytical Attention To Detail Automation Business Administration Business Intelligence Communication Estimated Salary: $20 to $28 per hour based on qualifications.
$51,452.
00 - $59,170.
00 AnnuallyLocation :
Tulsa, OKJob Type:
Full-timeJob Number:
4706F-07-23Department:
Institutional Research and AssessmentOpening Date:
07/24/2023Work Schedule:
Monday through Friday, 8 a.
m.
- 5 p.
m.
Campus:
MetroAbout TCC:
Tulsa Community College is committed to creating equitable and inclusive work environments to 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 increasingly diverse student populations.
We encourage candidates to apply who have demonstrated capacity to create inclusive work environments, to work effectively on increasingly diverse teams, and to serve the increasingly diverse college community.
We are committed to hiring and retaining a racially diverse, culturally competent staff at all levels of the organization who not only reflect the demographics of our students, but also 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.
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 Administration, Information Systems, Statistics, or a related field.
Experience with business intelligence software, such as relational databases and data manipulation and analysis using SQL, Excel, and statistical software (e.
g.
, R, Python, SPSS).
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.
Require demonstrated 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 Master's degree in Business Administration, Information Systems, Statistics, or a related field.
Degree requirement may be substituted with equivalent work experience.
Two years of proven experience in data analysis, business intelligence, or institutional research.
Familiarity with student information systems and higher education data (e.
g.
, IPEDS, OSRHE).
Mastery of R/Python/SPSS, 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 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 Recommended Skills Analytical Attention To Detail Automation Business Administration Business Intelligence Communication Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
