Business Intelligence Analyst II

The Talent Acquisition department hires qualified candidates to fill positions which contribute to the overall strategic success of Howard University. Hiring staff "for fit" makes significant contributions to Howard University's overall mission.


At Howard University, we prioritize well-being and professional growth.


Here is what we offer:

• Health & Wellness: Comprehensive medical, dental, and vision insurance, plus mental health support
• Work-Life Balance: PTO, paid holidays, flexible work arrangements
• Financial Wellness: Competitive salary, 403(b) with company match
• Professional Development: Ongoing training, tuition reimbursement, and career advancement paths
• Additional Perks: Wellness programs, commuter benefits, and a vibrant company culture

Join Howard University and thrive with us!

BASIC FUNCTION:

The Business Intelligence (BI) Analyst II is responsible for supporting organizational decision-making through data analysis, report development, dashboard creation, and interpretation of business performance metrics. This role includes gathering requirements, designing and maintaining BI solutions, identifying trends, and providing actionable insights to stakeholders across clinical, operational, and administrative departments. The BI Analyst II plays a key role in enhancing data-driven strategies and performance improvement initiatives throughout the organization.

SUPERVISORY ACCOUNTABILITIES:

None

NATURE AND SCOPE:

Internal contacts include hospital administrators, clinical and research staff, faculty, and IT personnel. External contacts include technology vendors, auditors, and regulatory agencies.

PRINCIPAL ACCOUNTABILITIES:

• Collaborates with departments to gather, define, and document reporting and dashboard requirements aligned with business objectives.
• Designs, develops, and maintains interactive dashboards, reports, and visualizations using tools such as Power BI, Tableau, or similar platforms.
• Transforms complex datasets into clear, concise reports that support decision-making for leadership and operational teams.
• Writes SQL queries and performs data extraction, transformation, and loading (ETL) from various data sources.
• Performs data validation and ensures accuracy, consistency, and integrity of reporting outputs.
• Analyzes key performance indicators (KPIs) and trends to support continuous improvement in clinical and administrative workflows.
• Supports data governance and standardization by documenting data sources, definitions, and metadata.
• Partners with IT, finance, clinical departments, and external vendors to integrate data from multiple systems (e.g., EHR, ERP, HRIS).
• Provides end-user support and training for dashboard and reporting tools.
• Develops and maintains business process documentation and user manuals related to BI systems.
• Participates in strategic projects, including quality improvement, population health management, and operational efficiency initiatives.
• Ensures HIPAA and data privacy compliance when handling sensitive data.
• Assists with evaluating new BI tools or enhancements and makes recommendations based on business needs and technology trends.

• Stays current with industry best practices, BI methodologies, and emerging technologies.
• May represent the organization in BI user groups, training sessions, or vendor meetings.
• Performs additional duties as assigned that support the mission and goals of the department.

CORE COMPETENCIES:

• Strong attention to detail with the ability to learn new tools and processes quickly. Demonstrated ability to deliver projects in a timely and customer-focused manner.
• Demonstrated analytical and critical thinking skills to assess complex data, identify patterns, and recommend solutions.
• Ability to interpret and transform business needs into effective data models and actionable insights.
• Working knowledge of data visualization tools (e.g., Power BI, Tableau) and reporting environments. Proficiency in SQL and relational database systems (e.g., SQL Server, Oracle).
• Familiarity with data warehousing concepts, ETL processes, and BI architecture.
• Knowledge of data governance principles and metadata documentation practices.
• Ability to work tactfully and effectively with team members, the vendor, and the user community.
• Understanding of healthcare data models and familiarity with enterprise resource planning (ERP), electronic health records (EHR), hospital operations, and workflows is preferred.
• Professional demeanor and excellent interpersonal skills to collaborate effectively with cross-functional teams, stakeholders, and external vendors.
• Strong organizational skills with the ability to manage multiple priorities in a fast-paced environment.

MINIMUM REQUIREMENTS:

• Education:
  • Associate degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field required. Bachelor's degree preferred.
• Experience:
  • Minimum of 2-3 years of experience working in a data analysis, business intelligence, or reporting role. Experience with data tools such as SQL, Power BI, Tableau, or equivalent required. Healthcare or hospital-related data experience is strongly preferred. Experience supporting system implementation, data integration, and cross-functional collaboration is desirable.
• Certifications (one or more preferred):
  • None required. Certifications in Power BI, Tableau, SQL, or related BI tools are preferred.
• Other Requirements:
  • Must be available for occasional on-call or after-hours support as needed.

Compliance Salary Range Disclosure

Compensation Range: $110,000 - $120,000