SQL Developer

communityhealthcenters; Santa Maria (CA); On-site; USD 118,000 - 131,000; Full time

Job summary

Community Health Centers is seeking an SQL Developer to build and optimize Microsoft SQL queries, stored procedures, and database objects to improve system performance. The role reports to the Director of Informatics and works with the Informatics team to design relational databases and generate reports for internal and external customers.

The ideal candidate has a strong SQL Server background, experience with data warehouses, and familiarity with athenaOne/NextGen EHR systems.

Qualifications

• Bachelor's degree in Computer Science, Information Systems or related field or 5 years of professional experience in Microsoft SQL Server.
• Prior experience with data warehouses and importing and cleansing data from different sources is preferred.
• Some understanding of medical terminology and ICD-10 and CPT4 coding is a plus.

Responsibilities

• Develops and maintains complex Microsoft SQL queries, stored procedures, triggers, and database objects for reporting.
• 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.
• Maintains expertise in athenaOne and NextGen database architecture and workflows.
• Generates routine and ad hoc reports for internal and external customers.
• Monitors and troubleshoots CHC Helpdesk tickets related to software systems.
• Provide quality customer service using AIDET Standards when calling patients.
• Able to work with high volume of patients and adapt to changes.
• Adheres to safety policies and infection control.
• Demonstrates knowledge of domestic violence, child and dependent abuse protocols.
• Demonstrates cultural sensitivity and HIPAA confidentiality.

Skills

Microsoft SQL Server

SQL queries

Stored procedures

Database design

Education

Bachelor's degree in Computer Science, Information Systems or related field

Tools

athenaOne

NextGen

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.