Business Intelligence Analyst - SOM Business Intelligence Office Passthrough

UNC Health•Chapel Hill, NC

3d•Hybrid

About The Position

The Business Intelligence Analyst supports the development, implementation, and continuous improvement of the School of Medicine’s internal controls program across Finance, Human Resources, Research Administration, and Clinical Trials. The role evaluates business processes, documents workflows and control points, performs control testing, and develops data-driven monitoring solutions to promote accuracy, consistency, and operational efficiency. Working with the Senior Business Intelligence Analyst – Controls, Business Intelligence team members, business process owners, and administrative stakeholders, the analyst evaluates processes, identifies risks and inefficiencies, and recommends improvements. The role uses SQL, data analytics, process modeling, and reporting tools to validate data, investigate discrepancies, document findings, and monitor corrective actions. It also contributes to automation and AI initiatives where appropriate and helps advance transparency, accountability, and trusted data across the School of Medicine.

Requirements

Bachelor’s degree in an appropriate discipline, or an alternative education-and-experience combination specified in the posting.
Professional experience requirements: three years with a bachelor’s degree in a general field; one year with a bachelor’s degree in a STEM field; one year with a master’s degree; nine years with an associate’s degree; or eleven years with a high school degree.
Basic proficiency in SQL and data visualization software, with the expectation of reaching limited proficiency within six months.
Limited proficiency in optimizing reusable data sources for visualization and analytics.
Ability to use SQL and analytical tools to extract, analyze, and validate data; perform data quality checks; investigate discrepancies; and document results.
Ability to document and model business processes and workflows, perform control testing, and maintain clear supporting documentation.
Ability to manage multiple priorities, coordinate assigned projects, and communicate progress, risks, and delays.
Data Governance Stewardship role commitments are expected.
Fulfillment of MySupport reporting and analytics single-intake requests is expected.
Ability to lead stakeholder groups and analytics teams.

Nice To Haves

Stakeholder requirements-gathering and presentation skills are preferred.
Knowledge of financial, administrative, and operational processes across finance, research administration, HR, and clinical trial functions.

Responsibilities

Support development, implementation, and maintenance of the school-wide Internal Controls Program.
Assist in documenting control frameworks, policies, procedures, ownership structures, and monitoring activities across finance, research administration, HR, and clinical trial operations.
Gather information from business partners, assess existing processes, identify potential control gaps, and support improvements.
Contribute to automation and AI efforts where appropriate to improve control monitoring and operational efficiency.
Document and model business processes, workflows, and control points; identify inefficiencies, redundant activities, gaps, bottlenecks, and opportunities for standardization or automation.
Collaborate with process owners and the Senior BIA – Controls to recommend, document, and implement process improvements, and evaluate their effectiveness.
Collaborate with Business Intelligence colleagues, SOM administrative managers, business process owners, IT, and campus partners to support consistent internal control practices.
Communicate findings, test results, and issues through documentation, reports, presentations, and stakeholder discussions.
Develop and maintain dashboards, reports, and monitoring tools to evaluate control performance, identify anomalies, track remediation, and show trends and potential risks.
Use SQL and other analytical tools to extract, analyze, and validate data across enterprise systems and reporting platforms.
Perform data reconciliation and completeness, accuracy, and consistency checks; document procedures, investigate exceptions, and work with system owners and IT to resolve data quality issues.
Support assessments of data flows, access controls, and system changes to strengthen data integrity and reliability.
Analyze financial, administrative, and operational data to identify unusual activity, inconsistencies, trends, potential control deficiencies, and opportunities to improve efficiency and reduce risk.
Translate analytical findings into actionable insights and recommendations for the Senior BIA – Controls and relevant business partners.
Execute control testing and monitoring procedures; document methodologies, evidence, results, exceptions, and recommended corrective actions.
Investigate discrepancies, evaluate supporting documentation, monitor remediation, and apply quality assurance practices to ensure accurate and reliable results.
Coordinate assigned projects and control-related initiatives; maintain work plans, documentation, timelines, and status updates; communicate progress, risks, and delays proactively.
Identify opportunities to standardize procedures, automate repetitive activities, improve data quality, and reduce administrative burden.
Work independently on established assignments and collaborate with the Senior BIA – Controls on complex issues and program objectives.
Fulfill Data Governance Stewardship commitments and MySupport reporting and analytics single-intake requests; lead stakeholder groups and analytics teams.