Business Intelligence Analyst - SOM Business Intelligence Office Passthrough

Job Description
Description
Your passion belongs at UNC Health. Join more than 56,000 teammates working together to improve the health and well-being of the communities we serve across North Carolina.

Job Summary: The Business Intelligence Analyst (BIA) supports the development, implementation, and continuous improvement of the School of Medicine's (SOM) internal controls program to strengthen governance, accountability, and data integrity across key functional areas, including Finance, Human Resources, Research Administration, and Clinical Trials.

This role applies analytical, technical, and process improvement skills to evaluate business processes, document workflows and control points, perform control testing, and develop data-driven monitoring solutions that promote accuracy, consistency, and operational efficiency.

The Business Intelligence Analyst partners closely with the Senior Business Intelligence Analyst - Controls, Business Intelligence team members, business process owners, and administrative stakeholders to analyze existing processes, identify risks and inefficiencies, and recommend improvements that strengthen internal controls and streamline operations. The position leverages SQL, data analytics, process modeling, and reporting tools to validate data, investigate discrepancies, document findings, and monitor corrective actions.

Through collaboration and continuous improvement, this role helps advance a culture of transparency, accountability, and trusted data across the School of Medicine.

Internal Controls Program Support: Support the development, implementation, and ongoing maintenance of the school-wide Internal Controls Program. Assist with documenting control frameworks, policies, procedures, ownership structures, and monitoring activities across finance, research administration, HR, and clinical trial operations. Coordinate with business partners to gather information, assess existing processes, identify potential control gaps, and support the implementation of improvements. Contribute to the use of automation and AI, where appropriate, to improve control monitoring and operational efficiency.

Process Modeling & Improvement: Document and model business processes, workflows, and control points across finance, research administration, HR, and clinical trial operations to improve process visibility, consistency, and accountability. Analyze existing processes to identify inefficiencies, redundant activities, control gaps, bottlenecks, and opportunities for standardization or automation. Collaborate with business process owners and the Senior BIA - Controls to develop recommendations, document future-state processes, and support implementation of process improvements. Evaluate the effectiveness of implemented changes to ensure they strengthen internal controls, improve data integrity, and reduce administrative burden.

Communication & Relationships: Collaborate with the Senior Business Intelligence Analyst - Controls, Business Intelligence team members, SOM administrative managers, business process owners, IT, and campus partners to support consistent application of internal control practices. Communicate findings, test results, and identify issues clearly through documentation, reports, presentations, and stakeholder discussions. Build productive working relationships that promote accountability, transparency, and continuous improvement.

Dashboard & Scorecard Development: Develop and maintain dashboards, reports, and monitoring tools to evaluate control performance, identify anomalies, and track remediation activities. Use available reporting and analytics platforms to monitor key control indicators, highlight trends, and provide visibility into potential risks. Partner with the Senior BIA - Controls and other analytics team members to ensure reporting is accurate, reliable, and aligned with program objectives.

SQL & Database Proficiency with Data Integrity Focus: Use SQL and other analytical tools to extract, analyze, and validate data across enterprise systems and reporting platforms. Develop and execute data reconciliation, completeness, accuracy, and consistency checks to identify discrepancies between source systems and published reports. Document validation procedures, investigate exceptions, and collaborate 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.

Financial & Healthcare Analytics: Apply knowledge of financial, administrative, and operational processes to support control assessments and identify opportunities to improve efficiency and reduce risk. Analyze data across finance, research administration, HR, and clinical trial functions to identify unusual activity, inconsistencies, emerging trends, and potential control deficiencies. Translate analytical findings into actionable insights and recommendations for the Senior BIA - Controls and relevant business partners.

Controls Testing, Documentation & Accuracy: Execute assigned control testing and monitoring procedures to assess compliance with established policies, procedures, and control requirements. Maintain clear documentation of testing methodologies, evidence, results, exceptions, and recommended corrective actions. Assist with investigating discrepancies, evaluating supporting documentation, and monitoring remediation efforts to ensure issues are addressed appropriately and timely. Apply consistent quality assurance practices to promote accurate, complete, and reliable results.

Project Management & Initiative: Coordinate and execute assigned projects and control-related initiatives, maintain organized work plans, documentation, timelines, and status updates. Manage multiple priorities while communicating progress, risks, and potential delays proactively. Identify opportunities to standardize procedures, automate repetitive activities, improve data quality, and reduce administrative burden. Work independently on established assignments while collaborating with the Senior BIA - Controls to resolve complex issues and advance program objectives.

Other Information
Education Requirements:
Bachelor's degree in an appropriate discipline.

Licensure/Certification Requirements

No licensure or certification required.

Professional Experience Requirements

If Bachelor's degree in general field, requires three (3) years of experience
If Bachelor's Degree in a STEM field (i.e.

Engineering, Math, Computer Science, Analytics, etc.), requires one (1) year of experience
If Master's degree, requires one (1) year of experience
If Associate's degree, requires nine (9) years of experience
If High School degree, requires eleven (11) years of experience
Knowledge/Skills/and Abilities Requirements:
[NOVICE- Limited Proficiency: You have the level of experience gained in a classroom and/or experimental scenarios or as a trainee on-the-job.

You are expected to need help when performing this skill.] -SQL and Data Viz software fundamentals (basic proficiency), leading to limited proficiency within 6 months - Limited proficiency of optimizing reusable data sources for visualization and analytics - Stakeholder requirements gathering and presentation skills preferred

• Data Governance Stewardship role commitments expected - Fulfillment expectations of MySupport reporting & analytics single intake requests - Lead stakeholder groups and analytics teams

Job Details
Legal Employer: STATE
Entity: UNC Faculty Physicians
Organization Unit: SOM Business Intelligence Office Passthrough
Work Type: Full Time
Standard Hours Per Week: 40.00
Salary Range: $38.55 - $55.43 per hour (Hiring Range)
Pay offers are determined by experience and internal equity
Work Assignment Type: Hybrid
Work Schedule: Day Job
Location of Job: US:NC:Chapel Hill
Exempt From Overtime: Exempt: Yes
This is a State position employed by UNC Health Care System with UNC Health benefits. If, however, you are presently an employee of another North Carolina agency and currently participate in TSERS or the ORP, you will be eligible to continue participating in those plans at UNC Health.
Qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, status as a protected veteran or political affiliation.
UNC Health makes reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as applicants and employees with disabilities. All interested applicants are invited to apply for career opportunities. Please email [email protected] if you need a reasonable accommodation to search and/or to apply for a career opportunity.