POSITION SUMMARY:
The Warehouse Analyst supports all phases of data modeling and gathering to support reporting requirements throughout LifePoint.
ESSENTIAL FUNCTIONS:
Access to and / or works with sensitive and / or confidential information.
SUPERVISORY RESPONSIBILITIES: n/a
Qualifications
KNOWLEDGE, SKILLS & ABILITIES: The requirements listed below are representative of the knowledge, skills and/or abilities required.
Education: Bachelor's Degree - Computer Information System, Computer Science or relevant degree
Experience: Minimum 3 years
Licenses: N/A
Skills and Abilities: Azure Synapse, Azure Data Factory, Azure Key Vault, Microsoft SQL Server, intermediate query writing skills, Microsoft Excel, Visual Studio, Git, Azure DevOps, Azure Portal, ETL, ELT, Stored Procedures, Views, Functions
Additional Skills and Abilities (not required but beneficial):
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:
The Warehouse Analyst supports all phases of data modeling and gathering to support reporting requirements throughout LifePoint.
ESSENTIAL FUNCTIONS:
- To perform this job, an individual must perform each essential function satisfactorily with or without a reasonable accommodation.
- Identify, scope, document, and code solutions to support LifePoint reporting
- Manage the development lifecycle including Requirements, Design, Development, Testing and Support
- Communicate results to appropriate departments, supporting business decisions
- Troubleshoot and analyze data discrepancies between sources and targets
- Regular and reliable attendance
- Perform other duties as assigned
Access to and / or works with sensitive and / or confidential information.
SUPERVISORY RESPONSIBILITIES: n/a
Qualifications
KNOWLEDGE, SKILLS & ABILITIES: The requirements listed below are representative of the knowledge, skills and/or abilities required.
Education: Bachelor's Degree - Computer Information System, Computer Science or relevant degree
Experience: Minimum 3 years
Licenses: N/A
Skills and Abilities: Azure Synapse, Azure Data Factory, Azure Key Vault, Microsoft SQL Server, intermediate query writing skills, Microsoft Excel, Visual Studio, Git, Azure DevOps, Azure Portal, ETL, ELT, Stored Procedures, Views, Functions
Additional Skills and Abilities (not required but beneficial):
- Healthcare data, insurance data, provider data, Pyspark, Pysql, Epic, Cerner, Meditech, Medhost, DB2, As400, C#, Python
- 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 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.
- 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.
- Job Specific Impact -- Decisions generally affect own job or assigned functional area but can affect the reporting of the entire organization.
- Moderate Independent Judgement -- Results are defined; sets personal goals and determines how to achieve results with few or no guidelines to follow; supervisor/manager provides broad guidance and overall direction.
- Moderate Planning / Organization -- Handle multiple tasks simultaneously with moderate complexity.
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.