Business Intelligence Analyst - SOM Business Intelligence Office Passthrough

UNC Health; Chapel Hill (NC); Hybrid; USD 53,000 - 76,000; Full time

Job summary

UNC Health in Chapel Hill is seeking a Business Intelligence Analyst to enhance the internal controls program across School of Medicine functions including Finance, HR, Research Administration, and Clinical Trials. You will model processes, perform control testing, and develop data-driven monitoring solutions to improve accuracy, governance, and operational efficiency.

The role collaborates with the Senior BI Analyst - Controls and business partners to analyze processes, identify risks, and

Qualifications

• Bachelor's degree in an appropriate discipline.

Responsibilities

• Support development and maintenance of the internal controls program across finance, research administration, HR, and clinical trial operations.
• Document processes, model workflows, identify inefficiencies, and standardize controls.
• Collaborate with stakeholders to communicate findings and support remediation.
• Develop dashboards and reports to monitor control performance.
• Validate data integrity using SQL and data analytics.
• Support control assessments and opportunities to improve efficiency.
• Coordinate projects, timelines, and status updates.

Skills

SQL basics

Data viz

Stakeholder engagement

Education

Bachelor's degree

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.