SQL Developer

Community Health Centers of the Central Coast, Inc.; Santa Maria (CA); On-site; USD 71,000 - 131,000; Full time

Job summary

Community Health Centers of the Central Coast, Inc. is seeking an SQL Developer in the Information Technology department to build and optimize Microsoft SQL queries, stored procedures, and other database objects to improve system performance and meet business needs.

Under the Director of Informatics, you will design relational databases, generate reports, and collaborate with the Informatics team while adhering to HIPAA and clinical workflow requirements, including NextGen and athenaOne

Qualifications

• Bachelor's degree in Computer Science, Information Systems or related field, or 5 years of professional SQL Server experience.
• Experience with NextGen or athenaOne EHR systems is a plus.
• Strong analytical and problem solving skills.

Responsibilities

• Develops, tests, and maintains complex MS SQL queries, stored procedures, triggers, and other database objects.
• Creates and updates documentation for new and existing SQL scripts.
• Helps design relational databases to store and process business data.
• Collaborates with the Informatics team to identify improvements.
• Maintains expertise in athenaOne and NextGen database architectures.
• Generates routine and ad hoc reports for internal and external customers.
• Monitors and troubleshoots CHC Helpdesk tickets related to software systems.
• Demonstrates professionalism and quality customer service.
• Dealing with high volume of patients and changes while adhering to policies.

Skills

SQL

Stored procedures

Reporting

Data modeling

Education

Bachelor's degree

5 years experience

Tools

SQL Server

NextGen

athenaOne

Job description

Job Title: SQL Developer

Department: Information Technology

Reports To: Director of Informatics

FLSA Status: Exempt

Wage range that the company expects to pay: $4,557.60 - $5,024.75 bi-weekly

Summary

Under the general supervision of the Director of Informatics, the SQL Developer is responsible for building and optimizing Microsoft SQL queries, stored procedures, and other database objects to improve system performance and meet business needs. It is the primary purpose of CHCCC to provide the highest quality of total care possible to the patient population it serves. Such a level of quality depends ultimately on the staff's desire and ability to work together, individually, and as a team. The employee is expected to be professional, punctual, maintain regular attendance, cooperative, motivated, and organized at all times.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Develops, tests, and maintains complex Microsoft SQL queries, stored procedures, triggers, and other database objects for reporting and analytics.
• Creates and updates documentation for new and existing processes and Microsoft SQL scripts.
• Helps design relational databases to store and process business data
• Collaborates with the Informatics team to identify areas for improvement and implement solutions
• Maintains expertise in athenaOne and NextGen database architecture, clinical workflows, and modules.
• Generates routine and ad hoc reports for internal and external customers.
• Monitors and troubleshoots CHC Helpdesk tickets as applicable to the use of software systems and issues.
• Demonstrates professionalism when calling patients and provides quality customer service using AIDET Standards.
• Ability to work with high volume of patients, internal/external customers, and deal with frequent changes, delays or unexpected events.
• Demonstrates adherence to and observes all safety policies and procedures, including infection control rules and regulations
• Demonstrates the knowledge of domestic violence, child and dependent abuse protocols.
• Demonstrates cultural sensitivity and competence.
• Maintains and adheres to HIPAA, employee confidentiality, and privileged communications (patient, employee, and corporation).

Supervisory Responsibilities

This job has no supervisory responsibilities.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION And/or EXPERIENCE

Bachelor's degree in Computer Science, Information Systems or related field or 5 years of professional experience in Microsoft SQL Server database design and programming. Prior experience working in IT at a Federally Qualified Health Center is preferred. Prior experience with data warehouses and importing and cleansing data from different sources is preferred. Prior experience working with NextGen or athenaOne EHR systems is a plus. Some understanding of medical terminology and ICD-10 and CPT4 coding is a plus. Must demonstrate strong analytical and problem solving skills.

Language Skills

Ability to read, analyze, and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization. Ability to speak confidently and articulate thoughts clearly and logically when training. Ability to respond effectively to the most sensitive inquires or complaints.

Mathematical Skills

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.

REASONING ABILITY

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

Computer Skills

Experience with word processing, spreadsheets, email, and keyboarding is required. Microsoft Office and Google Suite skills are required.

CERTIFICATES, LICENSES, REGISTRATIONS

None

Other Requirements

Required to pass a criminal history background check and drug screen upon hire. Annual health examination; annual Tuberculosis skin test clearance or chest x-ray; proof of immunity to MMR, Varicella, and Hepatitis B; proof of Tdap vaccine; during current flu season, must provide proof of influenza vaccine or a signed declination form. If declined, a flu mask is mandatory during flu season. Health screening requirements are subject to change based on CDC recommendations and federal, state, and/or local public health ordinances.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee occasionally is required to sit. The employee is frequently required to stand and walk for extended periods of time. The employee must regularly lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is frequently exposed to moving mechanical parts. The employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is moderate. Must be willing to work in a clinical environment to provide onsite support to employees as needed.

Must be willing to have a flexible work schedule that may include evenings/weekends.