Business Intelligence/SQL Analyst chez Wilmington Health

About Wilmington Health

Since 1971, Wilmington Health has been committed to the care and health of our community in Wilmington as well as all of Southeastern North Carolina. Wilmington Health is structured as a multi-specialty medical practice with primary care providers integrated into the system. In this way, Wilmington Health is able to provide a comprehensive and coordinated approach to the care of all our patients. Wilmington Health is committed to using collaborative, evidence-based medicine in providing the highest quality of care to the patients we serve.

Purpose: 

Wilmington Health is seeking a Business Intelligence/SQL Analyst to support data-driven decision making across the organization. This position requires proficiency in SQL and business intelligence tools to extract, transform, and analyze healthcare data. The Analyst is responsible for developing reports and dashboards, identifying trends, and providing actionable insights to support strategic initiatives and operational improvements.

Essential Duties/Responsibilities:

1. Incorporate large amounts of healthcare data using SQL and BI tools to discover patterns, trends, and relationships, producing actionable insights to inform strategy, improve quality, and identify cost reduction opportunities.
2. Design, develop, and optimize SQL queries and stored procedures for data extraction, transformation, and reporting, and use SSIS to support data loading and processing.
3. Develop, maintain, and enhance business intelligence reports and dashboards, preferably using Power BI, to visualize trends, KPIs, and operational metrics.
4. Analyze large healthcare datasets to identify data quality issues, discover trends, and generate insights that support population health management and strategic goals.
5. Create and maintain documentation of BI solutions, data models, and operational practices.
6. Present thoughtful analytical summaries and findings to internal and external stakeholders, and assist with meetings, presentations, and communications regarding BI projects.
7. Collaborate with clinical, operational, and IT stakeholders to gather requirements, translate business needs into technical solutions.
8. Conduct or facilitate ad hoc and drill down analyses of population healthcare data.
9. Maintain strict confidentiality and adhere to all data governance and compliance standards. 

Other Duties:

• Appears for work on time and attends meetings as required
• Maintains strict confidentiality
• Communicates courteously and appropriately with patients, physicians, and coworkers
• Perform other duties specified by manager 

KNOWLEDGE, SKILLS, AND ABILITIES: 

• Proficient in SQL coding, including the creation of stored procedures.
• Experience with SSIS for data loading and processing.
• Experience developing business intelligence reports; Power BI preferred.
• Strong analytical and problem-solving skills.
• Detail-oriented with the ability to handle multiple priorities.
• Effective written and verbal communication skills.
• Proficient with MS Office applications.
• Familiarity with healthcare or health insurance data preferred.

QUALIFICATIONS

Required:

Preferred:

Wilmington Health is an Equal Opportunity Employer committed to providing equal opportunities to all applicants and employees. We are committed to treating everyone equally and with respect regardless of race, age, sex, religion, national origin, citizenship, marital status, veteran’s status, sexual preference, disability, genetic information, or any other class protected under state or federal law. 

ADA Physical Demands:

Rarely (Less than .5 hrs/day) Occasionally (0.6 – 2.5 hrs/day) Frequently (2.6 – 5.5 hrs/day) Continuously (5.6 – 8.0 hrs/day)

Developer Competencies

General

1. Analytical Skills
2. Goal Oriented
3. Independence
4. Data Analysis, Entry, and Reporting
5. Communication/Interpersonal Relationships
6. Organizational Skills/Time Management
7. Professionalism/Integrity/Responsibility
8. Teamwork/Collaboration
9. Process Focus
10. Dependability/Punctuality
11. Judgment/Decision Making/Problem Solving
12. Quality/Quantity
13. Initiative/Efficiency