JOB SUMMARY: Under minimal supervision, responsible for developing applications and integrations using Microsoft Structured Query Language (SQL) Server platform. This includes reports, data warehousing, cubes, and other data related tasks.
ESSENTIAL DUTIES & RESPONSIBILITIES: The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment.
70% SQL-Transact, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
10% Data analysis using Excel or similar
10% Maintain current programs
4% Extract Transform Load (ETL)
4% Troubleshoot and identify bugs and solutions.
Duties listed below are integrated into all job functions:
- All staff members are to promote a positive and productive work environment by acting maturely and responsibly, satisfactorily performing his or her job responsibilities and conducting themselves in a professional, courteous and respectful manner toward fellow employees, physicians and patients.
- Must relate to other people beyond giving and receiving instructions: (a) get along with co-workers or peers without exhibiting behavioral extreme; (b) perform work activities requiring negotiating, instructing, supervising, persuading or speaking with others; and (c) respond openly and appropriately to feedback regarding performance from a supervisor.
- Performs all duties in a manner which promotes and supports the Core Values and Compact of The Everett Clinic.
- Integrates Lean principles, practices and tools to improve operational efficiency, reduce costs and increase customer satisfaction.
- Frequently must follow written and oral instructions as well as complete routine tasks independently.
- Completes annual compliance training on HIPAA/Privacy/Confidentiality/Non-Discrimination/Harassment/Integrity Statement and signs Agreements.
- Ensures confidentiality of patient information following HIPAA guidelines and TEC policies.
- Attends training to meet requirements of the job position and as needed or mandated by TEC policies, Div. of Occupational Safety & Health (DOSH), OSHA, L&I and other state/federal regulations.
- Has regular and predictable attendance.
.
NON-ESSENTIAL DUTIES AND RESPONSIBILITIES:
2% Perform other duties as assigned.
PREFERRED QUALIFICATIONS:
Knowledge, Skills & Abilities: Note that these requirements are representative, but not all-inclusive, of the knowledge, skill, and ability required to perform this job.
Knowledge:
- Transact-SQL, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and required
- Working knowledge of MS Excel including development of charts and pivot tables required
- Working knowledge of Team Foundation Server and Visual Studio desired
- SQL Server Integration Services (SSIS) and ETL experience desired
- Knowledge of Epic/Clarity data schema desired
- Previous overall knowledge and experience working with healthcare-related systems is helpful
- Working knowledge of workstation and network fundamentals and components.
Skills:
- Strong SQL Programming skills including complex Stored Procedures, complex SQL queries, and user defined functions, Common Table Expressions and transaction management using best practices.
- Strong analytical skills and the demonstrated ability to perform design and analysis of a project based on a given specification.
Abilities:
- Ability to work independently and establish priorities.
- Ability to work well with other team members, networking personnel, computer operators and clinical personnel.
- Ability to think logically and communicate clearly both in writing and verbally.
- Must be able to handle multiple tasks at one time.
- Ability to function and contribute as a team player.
Education: Bachelor’s degree in Computer Science or equivalent work experience.
Experience: Minimum of five to ten years’ experience in program development in a time-critical environment using mainstream programming tools and methodologies.
Certificate/License: None
PHYSICAL AND MENTAL DEMANDS: The physical and mental demands described here are representative of those that must be met by employees to successfully perform the essential functions of this job.
PHYSICAL DEMANDS:
While performing the duties of this job, employees are regularly required to sit, walk and stand; talk or hear, both in person and by telephone; use hands repetitively to finger, handle, feel or operate standard office equipment; reach with hands and arms; and lift up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision and the ability to adjust focus.
MENTAL DEMANDS:
While performing the duties of this job, employees are regularly required to use written and oral communication skills; read and interpret data, information and documents; analyze and solve non-routine and complex office administrative problems; may use math and mathematical reasoning; observe and interpret situations; learn and apply new information or skills; perform highly detailed work on multiple, concurrent tasks; work under intensive deadlines; and interact with managers, staff, customers, patients, the public and others encountered in the course of work, some of whom may be dissatisfied or abusive individuals.
TYPICAL WORKING CONDITIONS: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
Typical office conditions and noise level is usually quiet. Interaction with others is moderate and occasionally interruptive. Work may be demanding at times and may require ability to work irregular hours. Participate in On-call rotation.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
CONTACT: Physicians, employees, and possibly vendors.
Job descriptions represent a general outline of job duties, functions and qualifications. They are not intended to be comprehensive in nature. In addition, jobs evolve over time and therefore their description may not reflect the precise nature of the position at a given point in time.
