Business Intelligence Analyst

asu; Phoenix (AZ); On-site; USD 58,000 - 70,000; Full time

Job summary

Arizona State University seeks a Business and Data Analyst 2 to implement system requirements and perform routine data analyses to support data management objectives within the college. You will learn data warehouse concepts, build foundational reporting capabilities, and progressively take on complex analytics responsibilities.

The role emphasizes SQL fundamentals, data governance, and the development of BI reports and dashboards using Tableau and SSRS, with a growth path toward independent

Qualifications

• Bachelor's degree in a related field and 3 years of analytics experience.
• Experience with data warehouse concepts and SQL.
• Strong communication with stakeholders.

Responsibilities

• Develop and maintain BI solutions for data-driven decisions.
• Build and optimize SQL queries across systems.
• Create dashboards in Tableau and SSRS reports.
• Learn data warehouse schemas and security models.
• Collaborate with faculty and administration to design data solutions.

Skills

SQL

Tableau

Python

R

Data visualization

Education

Bachelor's degree

Tools

Tableau

SSRS

Alteryx

Redshift

Job description

Job Profile:

Business and Data Analyst 2

Job Family:

Business and Data Analytics

Time Type:

Full time

Minimum Qualifications:

Bachelor's degree and three (3) years of experience appropriate to the area of assignment/field; OR, Any equivalent combination of experience and/or training from which comparable knowledge, skills and abilities have been achieved.

Job Profile Summary:

Implements system requirements and performs routine data analysis to ensure data management objectives within a work unit are met.

Job Description:

Under supervision, supports the development and maintenance of business intelligence solutions to enable data-driven decision-making across the college. This is a growth-oriented position designed for a motivated analyst who will develop expertise in data warehouse environments, visualization tools, and college operations over time. The individual will begin by learning institutional data systems, building foundational reporting capabilities, and progressively take on more complex analytics responsibilities. This role requires strong SQL fundamentals and aptitude for learning new tools; the analyst should expect several months to learn data warehouse schemas and security models before becoming fully productive. While this role begins under direct supervision, it is designed as a structured path toward independent technical ownership as the analyst masters the college's data environment.

Position Salary Range:

$57,900 - $70,000 per year; DOE

Essential Duties:

• Data Repository Design, Development & Governance


• Learn and develop proficiency in Amazon Redshift or similar cloud data warehouse platforms to support college analytical needs.


• Write SQL queries to extract, integrate, and analyze data from student information systems, financial platforms, and compliance data sources; optimize queries over time as skills develop.


• With supervisor direction and support the implementation of data governance standards, documentation practices, and quality controls.


• Learn and progressively manage ELT workflows using Alteryx or similar data preparation tools, including cleaning, transforming, and structuring data.


• Develop expertise in data definitions, lineage, and metadata to become a resource for college analyticssystems over time.


• Advanced Analytics & Emerging Technology


• As proficiency develops, explore AI technologies, LLM-based tools, and emerging analytics platforms to enhance querying and analysis capabilities.


• Use analytical and problem-solving skills to connect disparate data elements and identify relationships relevant to academic and operational outcomes.


• Assist in the evaluation of emerging tools, machine learning applications and automation opportunities for potential adoption Over time, develop skills in statistical programming (Python, R) to support exploratory and predictive analysis.


• Business Analysis & Data Synthesis


• Develop understanding of the operational, academic, clinical, and financial structures of college programs through active engagement with stakeholders.


• Learn to translate raw data into meaningful, contextualized insights that support leadership decisions and college initiatives.


• Collaborate with faculty, administration, student services, academic operations, and financial teams to understand priorities and design data solutions.


• Contribute recommendations for process improvement, resource allocation, and strategic planning based on data findings.


• Business Intelligence Reporting & Visualization


• Build and maintain Tableau dashboards to communicate data with clarity; progressively take on more complex visualization projects.


• Learn Report Builder (SSRS) for operational reporting and routine data delivery to stakeholders.


• Support data visualizations and reporting for accreditation efforts, program review, workforce planning, and regulatory compliance.


• Refine BI tools in response to end-user feedback and emerging information needs.


• Predictive Modeling & Future-Focused Analytics (Future Growth)


• As the analyst develops expertise, they will progressively take ownership of predictive modeling initiatives including:
  
  
  
  • NCLEX pass-rate prediction and trend analysis.
  
  
  • Academic Status Report forecasting, progression modeling, and early-warning student success analytics.
  
  
  • Program and course-level demand forecasting.
  
  
  • Total cost to educate, faculty workload optimization, and revenue/cost modeling.
  
  
  • Enrollment, retention, and graduation forecasting.
  
  
  • Clinical placement capacity modeling and operational resource planning.
  
  
  
  


• Collaboration, Communication & Stakeholder Engagement


• Work with supervisor and stakeholders to ensure alignment between technical solutions and strategic goals; grow into primary analytics liaison role over time.


• Learn to navigate centralized data governance processes, including schema-level approvals through central security for student and financial data access.


• Communicate analytical res