Business Intelligence Analyst

Job Profile:

Business and Data Analyst 2

Job Family:

Business and Data Analytics

Time Type:

Full time

Apply before 11:59 PM Arizona time the day before the posted End Date.

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:

Builds and maintains the college's business intelligence foundation: a central data repository and the dashboards and reports that draw from it. The analyst takes raw data from student, financial, clinical, and compliance systems, writes clean and accurate SQL to integrate it, and turns it into reliable reporting that leadership uses to make decisions. We are looking for a hands-on data specialist who learns new systems quickly, writes code that is correct and well documented, and takes ownership of getting the numbers right.

Position

Salary

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

Essential Duties:

Data Repository & Data Quality

• Build and maintain the college's data repository in Amazon Redshift or a similar cloud data warehouse, integrating data from student information, financial, clinical, and compliance systems.
• Write, test, and optimize SQL to extract, join, and transform raw data into accurate, report-ready datasets.
• Build and manage repeatable data preparation (ETL/ELT) workflows using Alteryx or similar tools.
• Document data definitions, sources, and business logic; apply quality checks so reports are consistent and verifiable.
• Work within ASU's data governance and security processes, including schema-level access approvals and secure AWS workspaces for sensitive data.

Dashboards & Reporting

• Design, build, and maintain Tableau dashboards that present data clearly to leadership and end users.
• Produce operational and recurring reports using Report Builder (SSRS).
• Deliver reporting for accreditation, program review, workforce planning, and regulatory compliance.
• Refine dashboards and reports based on user feedback and changing information needs.

Stakeholder Partnership

• Work with faculty, administrators, student services, and finance teams to understand reporting needs and translate them into data solutions.
• Communicate findings, trends, and data limitations clearly to leadership and non-technical audiences.
• Train users to interpret dashboards and apply results to decisions.
• Collaborate with university analytics teams on shared data standards and best practices.

Other duties

• Shift priorities quickly and manage competing requests.
• Work independently and as part of a team, using judgment within established practices and policies.
• Deliver presentations to a variety of audiences.
• Perform other duties as assigned.

Desired Qualifications:

• Strong SQL skills, with demonstrated ability to write accurate, efficient queries against large or complex datasets.
• Experience building dashboards in Tableau or a similar platform (Power BI, Looker).
• Experience with a cloud data warehouse (Amazon Redshift, Snowflake, or similar) and ETL/ELT tools such as Alteryx.
• Proven ability to learn new systems, data structures, and tools quickly and become productive with minimal ramp-up.
• Strong attention to detail, with a habit of validating, testing, and documenting work.
• Experience with Python for data cleaning, automation, or analysis.
• Ability to explain technical work clearly to non-technical audiences.
• Experience in higher education or healthcare education, especially enrollment, student success, institutional research, or accreditation.
• Ability to handle sensitive data in accordance with FERPA and institutional policy.

Working Environment:

• Activities are performed in an environmentally controlled office setting subject to extended periods of sitting, keyboarding and manipulating a computer mouse.
• Required to stand for varying lengths of time and walk (moderate) distances to perform work
• Frequent physical demands may include stooping, bending, crawling under/around objects, reaching, lifting and pushing objects of varying weights up to 25 pounds (light).
• Hybrid work schedule.
• Position may involve shared offices/space.

Department Statement:

The Edson College of Nursing and Health Innovation is distinguished as a model for excellence and inspiration in nursing and interprofessional practice, education and research to advance knowledge and innovative practice models, and new solutions to optimize the health and well-being of our local, national and global communities.

Driving Requirement:

Driving is not required for this position.

Location

Campus: Downtown Phoenix

Funding:

No Federal Funding

Graduate Assistant, Intern and part-time positions are counted as half time for experience equivalency, meaning one year equals six months of experience.

Only electronic applications will be accepted for this position. By submitting an application, you confirm that the information provided is accurate and complete.

ASU Statement:

Arizona State University is a new model for American higher education, an unprecedented combination of academic excellence, entrepreneurial energy and broad access. This New American University is a single, unified institution comprising four differentiated campuses positively impacting the economic, social, cultu