Business Intelligence Analyst

University of Arkansas; United States; Remote; USD 70,000 - 100,000; Full time

Job summary

The University of Arkansas is seeking a Business Intelligence Analyst/Developer to design and maintain custom reporting solutions for their CRM system. This position requires proficiency in SQL and ETL tools, focusing on enhancing data accuracy and supporting business operations. Ideal candidates will possess strong analytical skills and the ability to collaborate across teams to deliver insights that drive decision-making.

Benefits

Health: Medical, Dental and Vision plans available

Holiday, Vacation and Sick Leave

Education discount for staff and dependents

Up to 10% matched contribution for retirement

Career Training and Educational Opportunities

Concierge prescription delivery

Qualifications

• Bachelor’s degree required with at least two years in data analysis or BI.
• Proficiency in SQL and ETL tools essential.
• Experience in client-facing roles preferred.

Responsibilities

• Develop and optimize Salesforce CRM reports and dashboards.
• Maintain data integrity and troubleshoot data issues.
• Assist in data loads and ensure seamless data flow across platforms.

Skills

SQL

ETL

Data Analysis

Problem Solving

Business Intelligence

Effective Communication

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

Salesforce CRM

Microsoft SQL Server

Job description

Current University of Arkansas System employees, including student employees and graduate assistants, need to log in to Workday via MyApps.Microsoft.com , then access Find Jobs from the Workday search bar to view and apply for open positions. Students at University of Arkansas System two-year institutions will also view open positions and apply within Workday by searching for “Find Jobs for Students”.

All Job Postings will close at 12:01 a.m. CT on the specified Closing Date (if designated).
If you close the browser or exit your application prior to submitting, the application process will be saved as a draft. You will be able to access and complete the application through “My Draft Applications” located on your Candidate Home page.

Closing Date:

06/08/2025
Type of Position: Professional Staff - Project/Program Administration
Job Type: Regular
Work Shift:

Sponsorship Available:

No
Institution Name: University of Arkansas for Medical Sciences

The University of Arkansas for Medical Sciences (UAMS) has a unique combination of education, research, and clinical programs that encourages and supports teamwork and diversity. We champion being a collaborative health care organization, focused on improving patient care and the lives of Arkansans.

UAMS offers amazing benefits and perks (available for benefits eligible positions only):

• Health: Medical, Dental and Vision plans available for qualifying staff and family
• Holiday, Vacation and Sick Leave
• Education discount for staff and dependents (undergraduate only)
• Retirement: Up to 10% matched contribution from UAMS
• Basic Life Insurance up to $50,000
• Career Training and Educational Opportunities
• Merchant Discounts
• Concierge prescription delivery on the main campus when using UAMS pharmacy

Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening. To apply for the position, please click the Apply link/button.

The University of Arkansas is an equal opportunity institution. The University does not discriminate in its education programs or activities (including in admission and employment) on the basis of any category or status protected by law, including age, race, color, national origin, disability, religion, protected veteran status, military service, genetic information, sex, sexual orientation, or pregnancy. Questions or concerns about the application of Title IX, which prohibits discrimination on the basis of sex, may be sent to the University’s Title IX Coordinator and to the U.S. Department of Education Office for Civil Rights.

Persons must have proof of legal authority to work in the United States on the first day of employment.

All application information is subject to public disclosure under the Arkansas Freedom of Information Act.

For general application assistance or if you have questions about a job posting, please contact Human Resources at [e-mail] .

Department: IA | Advancement Services

Department's Website:

giving.uams.edu
Summary of Job Duties: The Business Intelligence Analyst / Developer is responsible for designing, developing, and maintaining custom reporting solutions and applications that support the IA CRM system. This role requires expertise in SQL, ETL tools, and business intelligence (BI) datasets to ensure data accuracy and accessibility. The individual will collaborate with end users to gather requirements, create tailored reporting solutions, and deliver insights that support business operations.

As the organization explores AI-driven solutions, this role offers opportunities to contribute to emerging data initiatives, including automation and predictive analytics. While not required, familiarity with machine learning concepts or next-generation data architectures could be beneficial.

In addition to reporting and data management, this position plays a key role in maintaining data integrity, troubleshooting connectivity issues, and supporting integrations between systems. The ideal candidate has strong problem-solving skills, a solid understanding of database structures, and experience in quality assurance processes to enhance reporting accuracy and efficiency.
Qualifications:

Minimum Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field plus least two years of experience in data analysis, database management, or business intelligence to include at least one year of experience in a client-facing role providing technical solutions.

Special knowledge, abilities and skills:

• Proficiency in SQL and ETL tools.

• Experience with Salesforce CRM reporting and dashboard development.

• Working knowledge of data warehousing concepts and database structures.

• Familiarity with data integration processes and troubleshooting connectivity issues.

• Strong analytical and problem-solving skills with attention to detail.

• Ability to translate business needs into technical solutions.

• Effective communication and collaboration skills to work with cross-functional teams.

Preferred Qualifications

• Salesforce administrator experience.

• Experience working with Microsoft SQL Server or similar database platforms.

• Familiarity with data governance best practices and quality assurance testing.

• Experience with API-based integrations or middleware platforms.

• Exposure to machine learning concepts, AI-driven data solutions, or automation techniques is a plus.

Certifications in Salesforce, SQL, or data analytics are a plus.

Knowledge of vector databases or graph databases is a bonus but not required.

Additional Information:

KEY RESPONSIBILITIES:

Reporting (40%)

• Develop, maintain, and optimize Salesforce CRM reports and dashboards to support business operations.

• Organize and maintain a standardized report library to ensure efficient access to key data.

• Respond to ad hoc and specialty reporting requests, providing insights to stakeholders as needed.

• Design, develop, and maintain data sources used for reporting, including Microsoft SQL Server data warehouse and other relevant systems.

Data Maintenance and Integrity (30%)

• Perform ongoing data maintenance and implement projects to ensure donor database accuracy and consistency.

• Manage and update account records, contact details, campaign appeals, activities, and other key data points.

• Assist in reviewing and refining data entry policies, ensuring adherence to best practices for data integrity.

• Support the implementation of data governance policies to enhance data quality and compliance.

Integration (20%)

• Assist with data loads, ensuring accuracy and efficiency in data ingestion processes.

• Develop, maintain, and troubleshoot integrations between reporting systems, ensuring seamless data flow across platforms.

• Collaborate with technical teams to enhance automation and data pipeline efficiency as part of ongoing system improvements.

Other duties as assigned (10 %)

Salary Information:

Commensurate with education and experience

Required Documents to Apply:

Resume

Optional Documents:

Proof of Veteran Status
Special Instructions to Applicants:

Recruitment Contact Information:

Please contact [e-mail] for any recruiting relatedquestions.

All application materials must be uploaded to the University of Arkansas System Career Sitehttps://uasys.wd5.myworkdayjobs.com/UASYS

Please do not send to listed recruitment contact.

Pre-employment Screening Requirements: Criminal Background Check

This position is subject to pre-employment screening (criminal background, drug testing, and/or education verification). A criminal conviction or arrest pending adjudication alone shall not disqualify an applicant except as provided by law. Any criminal history will be evaluated in relationship to job responsibilities and business necessity. The information obtained in these reports will be used in a confidential, non-discriminatory manner consistent with state and federal law.

Constant Physical Activity: Manipulate items with fingers, including keyboarding
Frequent Physical Activity: Hearing, Talking
Occasional Physical Activity: Crawling, Crouching, Driving, Kneeling, Reaching, Standing, Stooping, Walking
Benefits Eligible: Yes