Log In
Sign Up
Full Job Description
Position/Job Title: Database Developer
Reports to: Health Information SystemsManager
Posting Date: 06/13/2023
Job Code: 230
Pay Class/Status: Technical/Operations – Exempt
Summary:
Reporting to the Health Information Systems (HIS) Manager, the Database Developer, in partnership with the HIS team, develops and implements highly effective information technology strategies and platforms related to acquiring, collecting, aggregating, analyzing, and disseminating health information vital to supporting member practices in providing quality patient care, as well as supporting community-wide efforts for health outcomes improvement. In addition, he/she provides leadership and/or direct oversight for network, architecture, and database systems, as well as the development of data integrity processes at all points of data transfer.
Essential Functions:
1. Identifies database requirements by interviewing customers and analyzes department applications, programming, and operations. Evaluates existing systems and designs proposed systems.
2. Recommends solutions by defining database physical structure and functionality capabilities, database security, data back-up, and recovery specifications.
3. Assists in writing complex queries and stored procedures and optimizes execution efficiency in MS SQL Server environment.
4. Provides SQL report writing support to HIS team.
5. Imports data from a variety of external sources, utilizing Microsoft SQL Server Integration Services.
6. Coordinates development, implementation, and maintenance of interfaces with various electronic medical record vendors, hospitals, pharmacy benefit managers, health plans, employers, health information exchange (HIE), and other sources and recipients of data.
7. Monitors and modifies database applications in an ever-changing health informatics environment.
8. Provides system reports and queries to ensure health information systems are running at peak performance.
9. Supports database users by conducting training, providing information, and resolving problems.
10. Takes ownership and uses proper technical knowledge to provide information to HIS team, management, and executive leadership to reach best outcomes for problem solving and decision-making purposes.
11. Collaborates and communicates with HIS and cross-functional team members daily.
12. Delivers quality customer service by establishing and demonstrating organization standards.
Additional Responsibilities/Duties:
(The following examples are intended to be descriptive but not restrictive.)
1. Maintains knowledge of health plan incentive programs (BCBSM, BCN, Priority Health, Aetna, HAP, McLaren, Meridian, and UnitedHealthcare) related to the work performed in HIS.
2. Collaborates with HIS team members and staff members at Integrated Health Partners (IHP) to support implementation of IHP’s strategic goals and outcomes.
3. Develops positive and productive relationships with current and potential IHP clients and vendors.
4. Maintains a high-level understanding of HIPAA and the impact on IHP’s responsibilities for Protected Health Information access, use, and disclosure.
5. Represents IHP on state, regional, and community groups, if applicable.
6. Participates in culture development and building a strong team for delivering IHP’s mission.
7. Demonstrates commitment to providing outstanding customer service in a manner that is reflective of IHP’s mission, vision, values, organizational context, code of conduct, and customer service standards.
8. Identifies opportunities for continuous improvement, develops related plans of action, and implements process and documentation improvements.
9. Committed to continuing professional development.
10. Maintains a working knowledge of applicable Federal, State and local laws and regulations, IHP’s Compliance Program & Code of Conduct as well as other policies and procedures, in order to ensure adherence in a manner that reflects honest, ethical and professional behavior.
11. Performs related duties as assigned.
Education/Experience:
Required Education and Experience:
1. Bachelor’s degree in computer science, informtion systems, or related field or in another field with requisite experience required.
2. Five years of related professional experience, including strong work experience in relevant information systems, including but not limited to, SQL Server, Microsoft Access, VBA/SQL Coding, etc.
3. Experience and/or ability to work with diverse populations.
Preferred Education and Experience:
1. Experience in information systems, data connectivity, data warehouse management, database management, data integrity, Tableau, and/or report writing.
2. Experience with writing and editing queries in Transact-SQL (T-SQL), and importing data with Microsoft SQL Integration Services.
3. Microsoft Certified in Database Fundamentals or similar certification.
4. Health care experience.
Professional Competencies, Licensure/Certification, Etc.:
Knowledge:
1. Thorough understanding of needs related to comprehensive health information documentation standards with additional knowledge of electronic health record applications.
2. Working knowledge of project management functions and techniques; utilize project management skills and identify task dependencies and critical paths.
3. Understanding of system architecture, infrastructure, integration, and databases.
4. Experience with utilities and software and hardware setup and installation practices.
5. Ability to comprehend workflow and integration of electronic applications into the current hybrid environment.
6. Strong understanding of business logic and processes.
7. Possesses a high-level knowledge on nonstructural data store concepts and data strategies.
Other Information Systems Skills:
1. Proficient in Microsoft Office Products
2. Strong troubleshooting and communication skills implementation and support of HIS applications
Competencies:
Communication
Analytical skills
Interpersonal skills
Clerical skills
Customer relations skills
Grammar and spelling skills
Problem solving skills
Computer skills
Organizational skills
Microsoft Excel, Word, Access
Intermediate math skills
Time management skills
Demonstrate and maintain high level of accuracy
Conflict resolution skills
Licensure/Certification: Microsoft Certified in Database Fundamentals or similar certification desired.
Other Requirements:
For the health and safety of our workforce and our community, all employees of Integrated Health Partners are required to be fully immunized for COVID-19.
Work Environment:
This job operates in a hybrid schedule between professional office environment and options for working from home. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.
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.
This is largely a desk-bound role; however, frequent movement throughout the office is required. Frequent sitting, standing, and walking are daily activities. Some bending and filing may be required. This would require the ability to lift files, open filing cabinets and bend or stand as necessary.
Position Type/Expected Hours of Work:
This is a full-time position. Days and hours of work are Monday through Friday. Hours of operation are typically 8:00 a.m. to 5:00 p.m. with some scheduled evening events. Work hours may vary by position with some positions requiring extended workdays depending on business needs. A typical work week for an exempt position averages 45 hours worked per week.
Travel:
This position requires up to 5 percent travel. Majority of travel will be in Southwest Michigan; however, additional travel may be required as needed. This job may have additional requirements for working on-site or embedded within a member practice or business partner and will be considered an alternate work site. Additional requirements may vary based on facility or regulatory requirements for the alternate work site.
The above statements are intended to describe the general nature and levels of the work performed and are not exhaustive lists of all duties, responsibilities, knowledge, skills, and abilities and working conditions associated with the job. As changes occur IHP reserves the right to modify the above description.
Job Type: Full-time
Benefits:
- 401(k)
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Tuition reimbursement
- Vision insurance
Schedule:
- Day shift
- Monday to Friday
COVID-19 considerations:
For the health and safety of our workforce and our community, all employees of Integrated Health Partners are required to be fully immunized for COVID-19.
Application Question(s):
- Have you been fully vaccinated with the COVID-19 vaccine?
- This is a hybrid position and will require in office work. Are you able to commute to Battle Creek, MI each week?
Education:
- Bachelor’s (Required)
Experience:
- related professional, including information systems,: 5 years (Preferred)
- data connectivity/warehouse management: 2 years (Preferred)
Work Location: In person
