Business Intelligence Analyst

About the role

The Business Intelligence Analyst in the Office of University Assessment and Accreditation (UAA) works collaboratively with the campus community with two integrated functions: enterprise dashboard development and data modeling, including the design, construction, and maintenance of reporting solutions, in collaboration with UAA team members, data owners, ITS Data Analytics, data governance stakeholders, and other internal stakeholders. Applied artificial intelligence for institutional analytics, including natural language processing of qualitative student and stakeholder feedback, automation of AI-assisted reporting workflows, and evaluation of emerging AI tools for extending the university's data and analytical capacity.

Responsibilities

• Collaborate with UAA team members, data owners, data requestors, subject matter experts, and institutional decision-makers to define business questions, analytical requirements, methodologies, deliverable specifications, validation criteria, and intended uses of data products supporting institutional initiatives, program objectives, assessment, accreditation, compliance, and decision-making.
• Support UAA objectives and functions by independently collecting, integrating, cleaning, validating, analyzing, and interpreting quantitative and qualitative data and developing reports, dashboards, semantic models, visualizations, and automated reporting solutions according to defined business specifications and research goals.
• Develop and maintain enterprise business intelligence and analytics solutions using Microsoft Power BI, Microsoft Fabric, SQL Server, Python, and related technologies, including data models, DAX measures, Power Query transformations, Dataflows, automated workflows, and other reusable analytical components.
• Work closely with ITS Data Analytics to facilitate secure and reliable access to institutional data; support the ingestion and integration of official institutional data snapshots into the enterprise analytics environment; and manage the acquisition, validation, documentation, and integration of external benchmarking, market, and reference data of strategic value to the institution.
• Engage data owners, data stewards, and subject matter experts in the collaborative development and maintenance of business terms, data definitions, data dictionaries, metadata, source-to-target mappings, and other documentation that provides a consistent institutional reference for stakeholders.
• Develop and maintain comprehensive documentation of institutional data definitions, data sources, analytical methodologies, data models, validation procedures, automated workflows, version history, standard operating procedures, and reporting processes to promote accuracy, transparency, reproducibility, continuity, and appropriate change management.
• Evaluate institutional data flows, reporting processes, analytical models, and emerging analytics and AI technologies to identify areas for improvement and ensure alignment with institutional goals.
• Translate complex analytical, statistical, and AI-assisted findings into clear, concise, and decision-ready reports, visualizations, narratives, and recommendations for technical and non-technical academic and administrative audiences.

Requirements

• Minimum Qualifications: Bachelor's degree and five (5) years of related experience; or equivalent combination of education and experience.
• Knowledge, Skills And Abilities: Ability to analyze quantitative and qualitative data, identify patterns, trends, relationships, and anomalies, and derive accurate, actionable conclusions from complex datasets. Advanced proficiency in Microsoft Power BI, including DAX, Power Query, semantic model development, report design, and data modeling. Working knowledge of Microsoft Fabric, including Lakehouse architecture, Dataflows Gen2, and enterprise analytics solutions. Advanced proficiency in SQL Server and relational database technologies, including T-SQL, stored procedures, query optimization, and performance tuning for large datasets. Proficiency in Python for data extraction, transformation, automation, statistical analysis, and reporting, including experience with libraries such as pandas and other analytics, automation, or natural language processing libraries. Experience collecting, integrating, cleaning, validating, and mapping data from disparate internal and external data sources while maintaining data quality and integrity. Advanced proficiency in statistical analysis, predictive analytics, forecasting methodologies, or quantitative research techniques to support institutional decision making. Demonstrated experience developing and maintaining enterprise reporting and data integration solutions using Microsoft Power BI, Microsoft Fabric, or comparable analytics platforms. Ability to evaluate model and AI output quality, documenting validation methodology, and applying responsible AI, FERPA, and data privacy requirements to institutional data. Ability to design, document, maintain, and improve automated analytics and AI-assisted reporting workflows, including testing, version control, validation procedures, and change management practices for model-driven processes. Ability to assess emerging analytics and AI technologies for institutional applicability and communicate potential benefits, limitations, costs, risks, and implementation considerations to stakeholders. Ability to think strategically and apply an institution-wide perspective when conducting analyses, developing reporting solutions, and supporting planning, assessment, accreditation, and compliance activities. Ability to work effectively in a collaborative, team-oriented environment and serve as a technical resource by providing guidance, consultation, training, and documentation related to institutional data, reporting systems, analytics tools, and business intelligence solutions. Ability to perform work with a high degree of accuracy, attention to detail, sound judgment, and problem-solving capability with minimal supervision.

Qualifications

• Master's degree or higher in Data Analytics, Information Systems, Computer Science, Statistics, Higher Education Administration, Institutional Research, or a related field.
• Seven (7) or more years of progressively responsible experience in business intelligence, institutional research, data analytics, data management, or decision support within higher education.
• Seven (7) or more years of experience with SQL Server and relational database technologies, including T-SQL, stored procedures, query optimization, data integration, and performance tuning.
• Extensive experience working with higher education data environments, including student records, admissions, financial aid, curriculum, enrollment, graduation, and academic program data.
• Experience working with PeopleSoft Campus Solutions or similar higher education student information systems.
• Experience supporting institutional research, assessment, accreditation, strategic planning, compliance, or regulatory reporting functions.
• Demonstrated experience developing and maintaining enterprise reporting and data integration solutions using Microsoft Power BI, Microsoft Fabric, or comparable analytics platforms.
• Experience applying statistical analysis, predictive analytics, forecasting methodologies, or quantitative research techniques to support institutional decision making.
• Demonstrated experience applying advanced critical thinking and analytical reasoning to research data sources, evaluate data quality, resolve inconsistencies, and prepare accurate, validated datasets for reporting, analysis, and institutional decision support.