SQL Developer

Company: Community Health Center Network
Location: San Leandro
Posted on: February 19, 2021

Job Description:

Organizational DescriptionThe Community Health Center Network (CHCN) is a partnership between eight health service organizations in Alameda County, whose mission is to provide a comprehensive range of professional health care services in a manner respectful of the community values and traditions.--CHCN is a nonprofit corporation, serving as an agent for its member health service organizations.--CHCN provides administrative support to the Alameda Health Consortium (AHC).Position Title: SQL DeveloperDepartment: ITReports To: Applications Development ManagerClassification: Exempt Status: Full-Time RegularLocation: Candidate must be willing to have primary residence in California.--This position is currently temporarily remote.--The candidate must be able to come in to our offices in San Leandro, CA, at any point, as needed, and be able to work in the office in person when offices re-open.--For licensing and tax purposes, we are unable to hire candidates residing outside the state of California starting on the date of hire. POSITION SUMMARYResponsible for designing, programming, and monitoring electronic data import/export functions (ETLs), generating ad-hoc reports, identifying issues, fixing bugs, and developing new solutions that require SQL and SSIS (SQL Server Integration Service) skills.ESSENTIAL POSITION RESULTSThe essential functions listed are typical examples of work performed by positions in this job classification. They are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks and responsibilities. Employees may perform other duties as assigned.Duties:-- Monitor existing database jobs, debug issues for the failed ones, and report to the team-- Handle daily requests on ticketing system submitted by CHCN's various departments-- Develop automated processes for ETLsHIPAA Designated Access"For the purposes of the job duties of this position, the person in this position requires access only to the following HIPAA protected information data sets" 1. MSO Membership-2. MSO Claims-3. MSO Referral/Auth.-4. MSO Capitation-5. Data Warehouse-6. Chart Audit/QI-7. Disease RegistrySUPERVISORY RESPONSIBILITIESNone MINIMUM QUALIFICATIONS- 2 year experience as a T-SQL programmer on Microsoft SQL Server 2012 - 2019- 2 year experience with SSIS (SQL Server Integration Service) and VB.NET (or C#.NET)- Experience in design, development, and troubleshooting of ETL/CRUD transactions- Experience in implementing automation using scripts- Experience in troubleshooting and resolving database problems- Good communication and documentation skillsEducation- Bachelor's degree in computer related fieldOther:- Strong skills in SSIS (SQL Server Integration Service)- Database Administration and SSRS (SQL Server Reporting Service) skills are plus- Familiar with Github version control system is a plus- Familiar with health care standard data sets (e.g., HIPAA Ansi x12, ADT, CCD) is a plus- Examples of candidate's code in T-SQL and VB.NET-CERTIFICATES AND/OR LICENSES- Certification is a plus; MCTS, MCITP, MVPPHYSICAL 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 sit and use hands to finger, handle, or feel. The employee is frequently required to talk or hear. The employee is frequently required to stand; walk; reach with hands and arms and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 15pounds.--Specific vision abilities required by this job include close vision and ability to adjust focus.WORKING CONDITIONS AND ENVIRONMENTThe 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 regularly exposed to an inside environment.

Keywords: Community Health Center Network, San Leandro , SQL Developer, IT / Software / Systems , San Leandro, California