Business Intelligence Data Analyst
Description
Salary Range\:
Salary commensurate with experience and qualifications
About SMU
SMU’s more than 12,000 diverse, high-achieving students come from all 50 states and over 80 countries to take advantage of the University’s small classes, meaningful research opportunities, leadership development, community service, international study and innovative programs.
SMU serves approximately 7,000 undergraduates and 5,000 graduate students through eight degree-granting schools\: Dedman College of Humanities and Sciences, Cox School of Business, Lyle School of Engineering, Meadows School of the Arts, Simmons School of Education and Human Development, Dedman School of Law, Perkins School of Theology and Moody School of Graduate and Advanced Studies.
SMU is data driven, and its powerful supercomputing ecosystem – paired with entrepreneurial drive – creates an unrivaled environment for the University to deliver research excellence.
Now in its second century of achievement, SMU is recognized for the ways it supports students, faculty and alumni as they become ethical, enterprising leaders in their professions and communities. SMU’s relationship with Dallas – the dynamic center of one of the nation’s fastest-growing regions – offers unique learning, research, social and career opportunities that provide a launch pad for global impact.
SMU is nonsectarian in its teaching and committed to academic freedom and open inquiry.
About the Department\:
The Office of Institutional Insights and Intelligence (OIII) serves as the University’s centralized Decision Support and Institutional Research function, integrating institutional research, enterprise data governance, data management, and advanced analytics, including predictive modeling and artificial intelligence. Working collaboratively with stakeholders across the University, OIII transforms trusted institutional data into actionable intelligence and forward-looking insights that support strategic planning, institutional priorities, and informed decision-making.
Through integrated data, standardized business definitions, and advanced analytical capabilities, OIII strengthens institutional effectiveness, supports student success, and advances the University’s accountability, accreditation, and external reporting responsibilities.
About the Position\:
This role is an on-campus, in-person position.
The BI Data Analyst transforms institutional data into trusted analyses, business intelligence products, and evidence-based insights supporting University planning, operations, accountability, and decision support.
Analysts work across academic and administrative domains, mining data from source systems, combining data analysis, visualization, data quality, documentation, and stakeholder collaboration.
Within assigned work, BI Data Analysts exercise initiative and technical judgment to select methods, identify risks, recommend approaches, and deliver results.
Job level and compensation will be determined based on the selected candidate’s experience and qualifications.
Essential Functions\:
- Institutional Analytics & Decision Support
- Mine for and Analyze institutional data to answer institutional planning, operational, strategic, and compliance questions.
- Synthesize information across sources to identify trends, relationships, anomalies, risks, and opportunities; develop evidence-based observations and recommendations for further inquiry.
- Business Intelligence, Visualization & Communication
- Design, maintain, and improve reports, dashboards, visualizations, KPI products, and executive or Board-ready analytical materials.
- Communicate analytical findings, assumptions, and limitations clearly through appropriate visual and narrative formats.
- Data Preparation & Reusable Analytics
- Mine, query, combine, transform, and document data from enterprise systems, warehouses, and other approved sources.
- Develop reusable queries, analytical datasets, and semantic or data models; coordinate with technical teams to support sustainable and traceable products.
- Perform analytics engineering to design, develop, and maintain governed, reusable datasets within the enterprise data warehouse, using medallion architecture, SQL, dbt, GitHub, and related tools to ensure data quality, consistency, traceability, and scalability.
- Data Quality, Governance & Documentation
- Apply approved definitions, business rules, data governance, privacy, security, and appropriate-use requirements.
- Validate and reconcile results, investigate discrepancies, document sources and methods, and raise recurring quality or process issues for resolution with appropriate owners.
- Stakeholder Partnership & Consultation
- As assigned, consult with academic and administrative stakeholders to understand business processes, clarify questions, and translate needs into analytical requirements.
- Collaborate with Data Stewards, OIT, institutional research colleagues, and other partners on approved cross-functional work.
- Continuous Improvement & Professional Practice
- Maintain relevant BI, institutional research, analytics, and governance knowledge; improve repeatability, usability, and sustainability of analytical products.
- Contribute to shared standards, documentation, knowledge transfer, and cross-training.
- Occasional evening and weekend work may be required during critical times.
Skills
Sign in to read and join the discussion.