Must Haves:
- Bachelor's Degree in Business, Computer Science, Healthcare Management, or related field
- 3-5 years of experience working in a business intelligence (BI) related position. Healthcare revenue cycle experience preferred, but not required.
- Strong experience developing business-friendly decision models that source multiple data sources, formula-based measure creation, and ties aggregations to detailed data.
- 1-2 years of experience of reading and writing T-SQL queries in SQL Server Management Studio (SSMS).
- Proficient with MS Excel, specifically including creation and dynamic use of Pivot Tables and VLOOKUP's, Joining tables, querying data, MIN/MAX/SUM, etc.
- Able to work with data visualization tools and dashboards – PowerBI.
Plusses:
- Healthcare industry experience
- Microsoft visual studio
Day to Day:
The Data Analyst will support business-case and technical requirements of the Revenue Strategy & Analytics department by capturing business requirements, developing ad-hoc queries/procedures, and constructing data models to build reports and dashboards. This position will compile data relating to revenue cycle, accounting and finance operations, weekly operational dashboards, cash flow, strategic pricing, and profitability. This position will be capable of translating end-user requirements into a structured, logical data sourcing plan and developing business-friendly reports, analyses, and impact models. This position will work directly with source database queries, schemas, and routine stored procedures across multiple platforms, including patient accounting systems, clinical systems, and data warehouses while utilizing SSMS, T-SQL, MS Excel, Power BI, and MS PowerPoint. Finally, this position will perform all duties and responsibilities in a manner consistent with GMR's mission, values, and professional standards.
50% writing queries and elevating data
25% working with internal customer on reports (BPI dashboards)
25% Data integrity work