What are the responsibilities and job description for the Sr. Manager Data Analysis position at Regal Medical Group?
Job Description
Position Summary :
The Senior Manager of Data Analysis provides direction and support both internally to the Finance Department and externally to other departments within the organization. Direction is provided via oversight of the HCC and Project Management Departments. Support ranges from data warehousing; application design; ad hoc report requests; core system design and work flow modification; hospital contract modeling and report automation.
Essential Duties and Responsibilities include the following :
- Support the CFO with ad hoc requests.
- Works as an integral member of the Finance Department.
- Support the HCC and Star Departments with ad hoc requests, data transfer, problem solving.
- Support the data warehouse which entails building and monitoring jobs, stored procedures, SQL scripts and data marts.
- Ongoing data mart maintenance, i.e. IBNR, PCP cap, specialty Cap, etc. Design and build applications for various departments to help improve work flow and reduce administrative costs; i.e. the Event Tracking database for Provider Relations and Network Management; and the ESRD database for Medical Management.
- Design and develop reporting applications; i.e. the PCP Profit and Loss Model; PMPM costs by Specialty; and PCP Referral and Costs by Specialty.
- Develop Reporting tools that mine data based on user input. For example, a user inputs select dates and can run admissions for a user defined time period.
- Ability to decipher work flows, document them using Visio, and identify non value added tasks.
- Run special projects including project assembly; task identification; notification to executive leader of progress and constraints.
- Review, build a schematic and make operational key system modules, i.e. Authorization protocols and P4P registries.
- Dashboard reporting to display key performance indicators (KPIs), i.e. Executive dashboard and Home Visit Dashboard.
- Maintain the department’s intranet site.
- Reporting Services report design; i.e. Claims productivity reporting and RBRVS equivalents.
- Hospital contract rate modeling.
- Basic cash flow reporting.
- Ad hoc reports as requested.
- All other duties as directed by management.
The pay range for this position at commencement of employment is expected to be between $110,000 - $115,000 annually; however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, licensure, skills, and experience.
The total compensation package for this position may also include other elements, including a sign-on bonus and discretionary awards in addition to a full range of medical, financial, and / or other benefits (including 401(k) eligibility and various paid time off benefits, such as vacation, sick time, and parental leave), dependent on the position offered.
Details of participation in these benefit plans will be provided if an employee receives an offer of employment.
If hired, employee will be in an “at-will position” and the Company reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, Company or individual department / team performance, and market factors.
As one of the fastest growing Independent Physician Associations in Southern California, Regal Medical Group, Lakeside Community Healthcare Affiliated Doctors of Orange County, offers a fast-paced, exciting, welcoming and supportive work environment. Opportunities abound, and enterprising, capable, focused people prosper with us. We promote teamwork, nurture learning, and encourage advancement for all of our employees. We want to see you excel, because we believe that your success is our success.
Full Time Position Benefits :
The success of any company depends on its employees. For us, employee satisfaction is crucial not only to the well-being of our organization, but also to the health and wellness of our members. As such, we are firmly dedicated to providing our employees the options and resources necessary for building security and maintaining a healthy balance between work and life.
Our dedication to our staff is evident in our comprehensive benefits package. We offer a very generous mixture of benefits, including many employer-paid options.
Health and Wellness :
Savings and Retirement :
Other Benefits :
Employer will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the LA City Fair Chance Initiative for Hiring Ordinance.
Requirements
Education and / or Experience :
Salary : $110,000 - $115,000
