Contractor - SQL Developer

Ranked #1 for Safety, Quality and Patient Satisfaction, Jupiter Medical Center is the leading destination for world-class health care in Palm Beach County and the greater Treasure Coast.

Outstanding physicians, state-of-the-art facilities, innovative techniques and a commitment to serving the community enables Jupiter Medical Center to meet a broad range of patient needs. Jupiter Medical Center is the only hospital in Palm Beach, Martin, St. Lucie and Indian River counties to receive a 4-star quality and safety rating from the Centers for Medicare & Medicaid Services (CMS).

Education

• High school graduate, 2 years of College, or equivalent experience.

Experience / Qualifications

• Minimum of one year healthcare experience working in: Information Services, Finance, Decision Support, or some related department.
• Strong interpersonal communication and organization skills required.
• Prior financial, costing and productivity, revenue cycle experience a plus.
• Computer Science degree, two or four year, or a minimum of 5 years of experience in a related field.
• Advanced Microsoft Office skills, SQL skills required.
• Experience with McKesson revenue cycle and financial systems, MS SQL Server, systems interfaces is a plus.
• Cerner Discern Analytics 2.0 (DA2)
• Experience with additional systems including Allscripts (PHS, STAR, HCI, HEMM, HEFM, PCA, EC2000), 3M HIS, Medicity, eClinicalWorks, Cerner CommunityWorks, Cerner Scheduling
• Experience with additional applications and reporting formats including SQL Reporting (SSIS, SSRS, SSAS), Visual Studio (2008-2017), MS SQL Server (2008-2016), Crystal
• Experience with additional languages and data formats including T-SQL, PL-SQL, JSON, XML, C++, Python, JavaScript, HTML, PowerShell, FileMaker scripting, Mirth interface engine, Cloverleaf interface engine, HL7 interfaces, Oracle, DTS packages, API’s and Webhooks (Facebook, Instagram, Twitter, Mailchimp, Salesforce, Google Analytics, etc.), EnableSoft Foxtrot, STAR Forms and Menus

Position Summary Responsible for developing and maintaining the application databases and software at Jupiter Medical Center.

• Essential functions are to strategize for future growth to ensure scalability.
• Design and deploy data table structures, forms, reports, and queries.
• Develop automated database applications.
• Identify inefficiencies in current databases.
• Troubleshoot database access and performance issues.
• Assist with development of firm’s internal applications, including .NET apps, intranet, etc.
• Responsible for evaluating database components, including hardware, relational database management systems, metadata management tools, and database design solutions.
• Provides exceptional customer service, and maintains open lines of communication with user departments, system analysts, technical experts, and software vendors.
• Manage multiple application, production, cloud integration, and non-production reporting servers
• Develop web pages and applications using ASP and SQL
• Develop and maintain HL7 messages using Cloverleaf and Mirth, and transform into SQL databases
• Manage database and server security
• Review execution plans for t-sql optimization by modifying tables, views, indexes and stored procedures
• Install service packs and cumulative updates
• Monitor disk space and plan for disaster recovery and backup testing
• Develop executive-level dashboards using FileMaker
• Set up and maintain vendor Interfaces
• Set up and maintain sFTP connections and write scripts to automate file transfers
• Develop and maintain organization-wide financial and clinical reports using SQL, Cerner DA2, and Crystal reporting tools
• Performs other duties as assigned.

Team Member Competencies Establishing Relationships

Builds effective networks, working relationships, and alliances in order to collaborate effectively within department and organization. Can relate to all kinds of people regardless of background; find topics and common interests that can be used to build rapport with others.

Peer Support

Provides guidance and feedback to help others strengthen knowledge/skills needed to accomplish tasks, solve problems, and perform effectively within the team.

Inspiring and Motivating Others

Fosters commitment and cohesiveness by facilitating cooperation and working as a team within the organization toward goal accomplishments. Work well with others, build consensus, and ensure cooperation to complete tasks and positive workflow.

Demonstrating Emotional Intelligence

Exercises self-leadership, self-awareness, and self-regulation; manages emotions so that they are expressed appropriately; leads others by showcasing adaptability, empathy, and social skills.

Acting with Integrity

Interacts with others in a way that is seen as direct and truthful; ensures confidence in individual and organizational motives and representations. Acts in a way that is consistent with personal and organizational values by keeping confidence, promises, and commitments. Clearly states goals and beliefs; informs people of their true intentions, does what they say they will do; follows through on commitments.

Being a Champion for Change and Innovation

Supports people in their efforts to try new things. Things creatively, generates novel and valuable ideas and uses these ideas to develop new or improved processes. Accepts new ways of doing things and adapts to change.

Communicating Effectively

Speaks and writes clearly, conveys information in a concise, organized, and logical manner. Is adept at tailoring the message to fit the interests and needs of the audience. Listens attentively and exercises tact, discretion, and diplomacy when interacting with members of the department and organization.

Promoting Diversity and Inclusion

Treats all people with dignity and respect. Demonstrates an open-minded approach to understanding people regardless of their gender, age, race, national origin, religion, ethnicity, disability status, or other characteristics. Challenge’s bias and intolerance. Develops all-inclusive groups in the realms of social interaction and communication. Shows respect for the beliefs of others; encourages and promotes practices that support cultural diversity; discourages behaviors or practices that may be perceived as unfair, biased, or critical toward people with certain backgrounds.

Physical Requirements Requires sitting for long periods of time, use of computer and other telecommunication devices. Must be able to work in a stressful environment, work independently, and be capable of critical thinking, making sound decisions, detail oriented, alert and self-motivated.

Threshold Requirements

• These threshold requirements are required and completed yearly basis

• Annual Joint Commission mandatory education requirements, in-service and health requirements including attendance at new employee orientation

• TB/PPD Surveillance Program

• Maintenance of required professional licensing and/or certification(s).

This is not necessarily an extensive list of all responsibilities, skills, duties, requirements, or working conditions associates with the job. While this is intended to be an accurate reflection of the current job, management reserves the right to revise the job or require that other or different tasks be performed when circumstances change. I have reviewed these job requirements and verify that I can perform all essential functions of this position.