LifePoint is currently seeking an ETL developer to join our data warehouse department!
In this role, you will use your knowledge of data warehousing and architecture to develop ETL solutions and help automate our data extraction, transformation and loading processes. You will collaborate with stakeholders to determine the data requirements to support our business processes and outline these requirements through data modeling.
Develop and implement ETL solutions, updating the architecture of our databases as necessary.
Develop or update SQL queries and scripts
Extract, transform, and load data from numerous source systems (SQL, flat files, web service) to SAP BW.
Troubleshoot and resolve reported issues with data in the data warehouse.
Work with business stakeholders to assist with data modeling, or outlining the data requirements to support our business processes
Strong organizational skills: ability to adapt and reprioritize workload as business priorities shift.
Ability to analyze large datasets
Demonstrates a basic level of working knowledge with IS methodologies and processes (i.e. Project Life Cycle, System Development Life Cycle and IS Change Management process).
Test databases and troubleshoot any issues
Regular and reliable attendance.
Perform other duties as assigned.
Position serves both Corporate and hospital-based employees and contractors.
Has access to and / or works with sensitive and / or confidential information.
Healthcare experience preferred.
Experience with SAP BW a plus.
Familiarity with Agile approaches to development a plus.
KNOWLEDGE, SKILLS & ABILITIES:
The requirements listed below are representative of the knowledge, skills and/or abilities required.
Business Mathematical Skills -- Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rates, ratios, and percentages and to draw and interpret graphs.
Technical Computer Skills -- Demonstrate use of intermediate computer operations (basic programming, relational databases, and operating systems) and intermediate software packages.
Complex Communication -- Frequently communicates complex information and interacts with management. Can present, resolve and address delicate situations. Can motivate and persuade others.
Job Specific Impact -- Decisions generally affect own job or assigned functional area.
Nature of Problems
Varied Business Problems -- Problems are varied and complex, requiring analysis or interpretation of the situation. Problems are solved using knowledge and skills, general precedents and practices.
Moderate Independent Judgement -- Results are defined; sets personal own goals and determines how to achieve results with few or no guidelines to follow; supervisor/manager provides broad guidance and overall direction.
Moderate -- Handle multiple tasks simultaneously with moderate complexity.
PHYSICAL AND MENTAL 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 job responsibilities.
While performing the duties of this job, the employee is occasionally required to stand; walk; sit for extended periods of time; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, bend, crouch or crawl; talk or hear; taste or smell. The employee must occasionally lift and/or move up to 20 pounds. Repetitive motion of upper body required for extended use of computer. Required specific vision abilities include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.
WORK ENVIRONMENT AND TRAVEL REQUIREMENTS:
Work environment characteristics described here are representative of those that an employee may encounter while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job responsibilities.
Works in well-lit, ventilated and climate controlled office environment with routine office equipment; some equipment has moving mechanical parts.
In hospital environment, may be exposed to hazards and unusual elements, which may include but are not limited to bloodborne pathogens and / or contagious illnesses, toxic chemicals, and biohazardous materials which may require extensive safety precautions and the use of protective equipment.
Noise level in the work environment is typical for an office and/or hospital environment.
Minimum overnight travel (up to 10%) by land and/or air.
Bachelor's Degree in computer science related field.