Programmer

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: Employer-paid comprehensive medical, pharmacy, and dental for employees Vision insurance Zero co-payments for employed physician office visits Flexible Spending Account (FSA) Employer-Paid Life Insurance Employee Assistance Program (EAP) Behavioral Health Services Savings and Retirement: 401k Retirement Savings Plan Income Protection Insurance Other Benefits: Vacation Time Company celebrations Employee Assistance Program Employee Referral Bonus Tuition Reimbursement License Renewal CEU Cost Reimbursement Program Business-casual working environment Sick days Paid holidays Mileage 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: 3 years of SQL programming experience 3 years of experience in a healthcare organization 3 years of experience producing and analyzing reports Advanced skills with Microsoft Excel SSRS and/or Tableau experience preferred Knowledge of relationship database theory preferred Access database development (VBA) experience preferred Ability to prioritize work and manage competing deadlines Ability to provide a high level of customer service to end users Excellent attention to detail Excellent communication skills Ability to learn new material quickly Ability to follow instructions accurately A strong personal work ethic Excellent critical thinking skills Bachelor’s degree from a four-year college is preferred