Senior Business Intelligence Developer

Responsibilities Implement a comprehensive program to extract data using a computer programming language or collect data, then analyze it and effectively report information from this data to a variety of customers in a user-friendly and actionable way. Generate reports, develop tools and provide consultative support as needed. Our customers include physicians, physician groups, physician leaders, hospital leaders, the Board of Trustees, system leadership, transformation consulting, clinical/non-clinical services, Markets, Community, Service Lines, Revenue Cycle, Finance, external oversight/regulatory bodies, or any other user needing information. Create reports, metrics, tools, data models, data-marts, cubes, dashboards, document process flows, fulfill data needs for the Service Lines on a priority basis and work on one-time requests from other areas of the system. Value-Based Care IT and Analytics interface with Population Health leaders to understand how data solutions can make a positive impact and provide consulting, design reports, build solutions as needed, and act as a liaison between Analytics and Business leaders. Gather detailed requirements, document them in our central intake process, then identify existing solutions in the Analytics space or, if a new solution is needed, create a detailed product delivery plan, navigate tools, pull preliminary data from internal systems plus external systems such as MiHIN, Payor Interfaces, Azara and any others as required. Per-Member-Per-Month, Case Management, Ambulatory, and Utilization Management related work as directed by the leadership. Revenue Cycle Analytics: work with charge, payments, adjustments, billing and claims data. Create reports aligned with the yearly Playbook initiatives. Develop customer-requested automated tools, reports, dashboards, data models, data-marts, data analyses for Coding, Billing, Bad Debt, Payments, Revenue, Customer Service data and others as needed. Requirements Bachelor's Degree with a Healthcare, Computer Science, Engineering, Mathematics/Statistics, Business, or an Applied Science major 3-4 years of experience in a Healthcare or Business setting Expert in the use of advanced Excel, SQL, report building, tool development, requirements gathering and technical documentation Experience in the use and design of Relational Databases, Data Models, Data Visualizations, curated datasets, data cubes or experience in Electronic Medical Record (EMR) report development, functionality of any EMR (Epic, Cerner, McKesson or other widely used EMRs). Maintain code repositories on an SCM system, familiar with merging, pushing, pulling, branching, staging and code commenting or MS TFS Good understanding of fundamental Computer Programming concepts or Electronic Medical Record systems Basic understanding of Statistical and Machine Learning concepts Basic understanding of dimensional models and Data Warehouse or Electronic Medical Record system Experience in any Business Intelligence tools such as Tableau, Cognos, Looker, Toad, Minitab, Power BI, Qlik, SSRS or any other Develop multidimensional semantic layer and analytics query objects for end-users Proven customer service experience with strong active listening skills Able to present complex information to diverse audiences Excellent written and verbal communication skills Preferred Requirements Strong knowledge of EPIC Data Structures Work Environment Hybrid position – on site one day a week in Troy, MI #J-18808-Ljbffr TRG