What are the responsibilities and job description for the Programmer position at Regal Medical Group?
Job Description
Position Summary :
The Programmer / Data Analyst position is part of the Decision Support Team and supports the organization’s data driven management strategies. This position is responsible for pulling and analyzing health care data, including HCC and RAF scores. Data mining, manipulation of data using Excel and high level critical thinking are essential job functions. This position may also provide programming support in the form of SQL coding, Access database development and maintenance, Tableau dashboard creation and deployment of reports using SSRS.
Essential Duties and Responsibilities include the following :
- Extract and analyze data with SQL scripts
- Manipulate and interpret data using Excel and Access
- Analyze data on key health care metrics such an HCC, RAF scores, enrollment growth and utilization of services
- Decode end user report requests into SQL specifications
- Communicate effectively with all levels of the organization
- Be responsive to end-user requests for customization of existing reports
- Work collaboratively with fellow team members
- Create dashboards for presentation to the Executive Team
- Develop user friendly database solutions in Microsoft Access
- Develop and support Tableau Dashboards
- Develop reporting solutions using SSRS
- Support the library of Crystal Reports
- Take ownership of assigned projects and deadlines
- All other duties as directed by management
The pay range for this position at commencement of employment is expected to be up to $100k 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 : $100,000
