SQL Data Analyst (Onsite-Vincennes, Indiana)

Job Summary :

The Data Analyst partners with leaders, clinicians, and operational teams across the organization to translate business questions into reliable, decision-ready analytics. This role fields ad-hoc reporting requests, builds and maintains Power BI dashboards and enterprise reporting outputs, and supports recurring operational analytics such as compensation calculations and benchmarking. The analyst extracts and integrates data from multiple healthcare platforms (including Epic and Oracle), applies strong data validation and governance-minded practices to ensure accuracy, and communicates findings in clear, actionable terms.

Success in this position requires strong analytical judgment, attention to detail, and the ability to manage multiple priorities in a fast-paced environment. The analyst is expected to continually develop technical skills, stay current with software releases, proactively identify improvement opportunities, and deliver solutions through a consistent intake-to-delivery process. The role also contributes to organizational adoption by providing training and support for reporting tools, Excel, and data literacy programming.

Essential Job Duties :

Ad-hoc reporting & stakeholder partnership

Serve as an intake point for ad-hoc report requests; clarify requirements, scope, timelines, and acceptance criteria with requestors.

Partner with business process stakeholders to translate workflow and decision needs into analytic questions, measures, and deliverables (reports, extracts, dashboards, visuals).

Provide iterative prototypes and manage testing / UAT through final approval, document assumptions, logic, and definitions.

Power BI dashboard development & enterprise reporting

Design, build, and enhance Power BI dashboards that support trends, comparisons, benchmarking, and operational performance monitoring.

Develop and maintain semantic models / datasets (where applicable), measures, and standardized KPIs aligned to enterprise definitions.

Optimize dashboards for usability, performance, and executive-ready presentation; ensure refresh reliability and consistent formatting standards.

Data extraction, integration, and integrity

Extract and integrate data from Epic, Oracle, and other operational systems by applying complex rules, joins, and calculations to interface data from multiple sources; build and maintain repeatable logic.

Perform data quality checks, reconcile results to source-of-truth references, and validate outputs prior to release.

Ensure appropriate handling of confidential data and compliance with organizational policy and applicable regulations.

Compensation calculations & recurring analytics maintenance

Maintain and run recurring data workflows including compensation calculations and supporting datasets (as assigned).

Analytics & insights

Identify trends, correlations, and exceptions in complex datasets; summarize implications and recommend actions.

Proactively investigate historical performance and market / benchmark signals to identify improvement opportunities.

Prepare pro formas and forecasting support using historical, comparative, and modeled assumptions (as requested).

Data literacy, enablement, and customer support

Provide individual and group training on Microsoft Excel, Power BI consumption, and approved Epic reporting tools.

Contribute to data literacy programming (job aids, office hours, learning sessions, documentation, and adoption support).

Project and cross-functional support

Serve as the reporting / data subject-matter resource on cross-department implementations and enterprise initiatives (data governance, Epic data, BI standards).

Provide required data elements for audits and government-mandated reporting; support external vendor / conglomerate data requests when authorized.

Manage multiple projects and priorities, communicating status, risks, and dependencies clearly and consistently.

Technical Proficiencies :

Builds and Maintains proficiency in Microsoft Office Suite, particularly Microsoft Excel.

Builds and Maintains proficiency in Dax and SQL coding, data modeling concepts and data automation strategies

Builds and Maintains proficiency in EPIC Clarity, Caboodle, Cogito

Adopts additional technologies as required by team’s strategic plan.

Education Bachelor’s degree in Data, Statistics, Accounting, Business, Finance, Healthcare Management, Healthcare Informatics or related degree preferred.

Experience Minimum of two years in data-oriented roll and / or previous healthcare experience