Business Intelligence Analyst II

Business Intelligence Analyst II

Howard University

• 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

For more details, visit: (Use the "Apply for this Job" box below).-wellness

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.

None

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

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

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