Business Intelligence Analyst II

Howard University•Washington, DC

46d•$110,000 - $120,000

About The Position

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.

Requirements

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.
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.
Associate degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field required.
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.
Must be available for occasional on-call or after-hours support as needed.

Nice To Haves

Understanding of healthcare data models and familiarity with enterprise resource planning (ERP), electronic health records (EHR), hospital operations, and workflows is preferred.
Bachelor’s degree preferred.
Healthcare or hospital-related data experience is strongly preferred.
Experience supporting system implementation, data integration, and cross-functional collaboration is desirable.
Certifications in Power BI, Tableau, SQL, or related BI tools are preferred.

Responsibilities

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.