Business Intelligence Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Create, develop, maintain, and enhance Salesforce reports, dashboards, datasets, queries, and related reporting solutions.

• Collect and clarify stakeholder needs, translating business inquiries into precise reports and data products.

• Define and document reporting logic, calculations, assumptions, data definitions, and source-to-report relationships.

• Maintain a standardized library of reports, including naming conventions, ownership, documentation, access controls, and retirement practices.

• Create reusable data models, reporting components, and standardized datasets.

• Address ad hoc and specialty reporting requests while identifying opportunities for standardized or self-service solutions.

• Design, configure, test, and oversee AI-assisted and automated reporting processes.

• Develop prompts, instructions, templates, business rules, structured outputs, evaluation criteria, and human-review checkpoints.

• Assess emerging AI, analytics, and automation capabilities.

• Monitor AI-assisted outputs for accuracy, consistency, security, bias, and compliance.

• Document the capabilities, limitations, dependencies, risks, and support requirements of AI-assisted processes.

• Train and assist staff in the responsible use of reporting, automation, and AI tools.

• Design, maintain, and troubleshoot data pipelines, integrations, APIs, scheduled processes, and data loads.

• Utilize SQL and ETL tools to extract, transform, reconcile, and validate data.

• Implement automated quality checks, exception reports, monitoring, and alerts.

• Investigate and resolve reporting, integration, data-access, connectivity, and performance issues.

• Collaborate with system administrators, data owners, vendors, and institutional technology teams.

• Support data governance, metadata management, privacy, security, retention, documentation, and change-control practices.

• Consult with end users and recommend reporting, analytical, or automated solutions.

• Perform additional duties as assigned.

⛳️ Requirements

• Bachelor’s degree in computer science, information systems, data analytics, or a related field, along with two (2) years of experience in data analysis, database management, reporting development, or business intelligence; or a High School diploma/GED with six (6) years of relevant experience.

• Practical experience in at least two or more of the following: SQL, Data Warehousing, Semantic Data Models, and/or Epic Clarity.

• Minimum of one year of experience in a client-facing role providing technical solutions.

• 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.

• Ability to convert business needs into technical solutions.

• Candidates must have proof of legal authorization to work in the United States by their first day of employment.

• Successful completion of a Criminal Background Check.

• Preferred: knowledge of automation, AI-assisted tools, prompt design, and process improvement methodologies.

• Preferred: certifications in Salesforce, SQL, or data analytics.

• Preferred: familiarity with vector databases or graph databases.

🏝️ Benefits

• Medical, Dental, and Vision plans available for eligible staff and their families.

• Holiday, Vacation, and Sick Leave.

• Educational discounts for staff and dependents (undergraduate only).

• Up to 10% matched contribution from UAMS.

• Basic Life Insurance coverage up to $50,000.

• Career Training and Educational Opportunities.

• Merchant Discounts.

• Concierge prescription delivery at the main campus when using UAMS pharmacy.