JOB SUMMARY The Data & Reporting Manager is responsible for managing and enhancing the technical infrastructure, reporting functionality, and data integrity of enterprise-wide compliance programs. This role involves overseeing database systems, generating executive-level reports and dashboards, supporting compliance billing departments, and contributing to data-driven projects. The position requires expertise in database management, programming, and technical training, as well as the ability to lead complex data initiatives in the absence of established standard operating procedures. Additionally, the manager will be the primary resource for reporting, analysis, and support to the Compliance Billing Teams and will develop a comprehensive understanding of the revenue cycle and related systems within BSWH. ESSENTIAL FUNCTIONS OF THE ROLE
Oversee Technical Infrastructure & Reporting Functionality: o Manage the database and reporting infrastructure for the enterprise-wide Conflicts of Interest Program while functioning as the technical liaison with the website host vendor. oPerform ETL (Extract, Transform, Load) processes using tools such as Microsoft Access and Excel. oEnsure effective database operations and develop SOPs for all areas of work.
Provide Executive-Level Reports & Dashboards: oCreate and deliver reports and dashboards for compliance activities using Power BI and Excel. oCollaborate with departments like Medical Staff Services, HR, AP, and Strategic Sourcing to ensure data accuracy and relevance.
Support Compliance Billing Teams: oAssist billing teams by querying patient encounters, diagnoses, procedures, and Medicare claims within the EPIC EHR system. oWrite and execute SQL queries in SQL Server Studio while adhering to access limitations. oApply strong analytical skills to analyze, interpret, and summarize complex data. oUtilize advanced mathematical and statistical methods to identify healthcare trends and optimize data analysis.
Contribute to Data-Based Projects: oSupport data migration, mapping, cleansing, and user acceptance testing for case management and other system transitions. oAssist in implementing and consolidating new data systems and processes.
Develop & Deliver Technical Training: o Design and deliver technical training sessions focused on knowledge transfer and skill development for colleagues at various levels. KEY SUCCESS FACTORS
- Database Management: MS Access, SQL Server
- Programming Languages: VBA, Office Scripts, DAX, SQL, R, SAS, Scala, Matlab, Python, Spark, Hadoop, Tableau
- Applications: MS Excel, Power BI, SQL Server Studio, EPIC EHR, Power Automate
- Data Modeling, Analytic Techniques, Technical Writing, Instructional Design & Delivery
- Familiarity with Crystal Reports, EPIC, and Clarity reporting data warehouse
- Effective communication skills, both verbal and written
BENEFITS Our competitive benefits package includes the following
- Immediate eligibility for health and welfare benefits
- 401(k) savings plan with dollar-for-dollar match up to 5%
- Tuition Reimbursement
- PTO accrual beginning Day 1
Note: Benefits may vary based upon position type and/or level
QUALIFICATIONS - EDUCATION - Bachelor's or 4 years of work experience above the minimum qualification
- EXPERIENCE - 5 Years of Experience (database management, reporting, and data analysis)
- Preferred Certifications:
oCertified Health Data Analyst oEPIC Revenue Data Model Certification oDatabase Administration (DBA) Certification oDatabase Management (DBM) Certification oDatabase Programmer Certification -
- Oracle or Microsoft SQL Certification
- Preferred Experience: oProficiency in Microsoft Office automation tools, Power BI, and VBA. o Experience with statistical software and familiarity with healthcare terminology and data processing. oAbility to work independently and as part of a team.