Data Warehouse Engineer

The WellBe care model is a Physician Led Advanced Practice clinician driven geriatric care (care of older adults) team focused on the care of the frail, poly-chronic, elderly Medicare Advantage patients.  This population is typically underserved and very challenged with access to care.   To address these problems, we have elected to bring the care to the patient, instead of trying to bring the patient to the care. Care is provided throughout the entire continuum of care – from chronic care and urgent care in the home, to hospital, to skilled nursing facility, to assisted living, to palliative care, to end of life care.  WellBe's physician/advanced practicing clinician led geriatric care teams’ partner with the patient’s primary care physician to provide concierge level geriatric medical care and social support in the home as well as delivering and coordinating across the entire care continuum.

GENERAL SUMMARY

At WellBe Senior Medical our Data Scientist applies advanced data analysis tools and methodologies to deliver insights and actionable recommendations for the business, as well as individual units. Utilizes complex statistical modeling to forecast future outcomes and in various business scenarios. Simplifies results and communicates findings to business leaders.

SKILLS & COMPETENCIES

• Design and develop ELT pipelines and transformations for publication of data marts to be used for higher level analytics.
• Establish and maintain quality control processes to ensure data is up to date and accurate to maintain the integrity of the Data Warehouse
• Manage and maintain database roles and permissions to ensure correct availability of data to end users.
• Work alongside data consumers and producers to resolve inquiries and drive changes on upstream dependencies
• Monitor usage and performance of warehouse resources and implement creative solutions for improving performance and reducing costs of said resources
• Ensure proper configuration management and change controls are implemented for your sphere of influence
• Provide technical assistance and cross training to other team members.
• Provide training and assistance to stakeholders
• Design and implement technology best practices, guidelines and repeatable processes.
• Must be able to perform duties with moderate to low supervision
• Other tasks needed to accomplish team’s objectives/goals

QUALIFICATIONS

Educational/ Experience Requirements:

• Bachelor’s degree, or higher, and relevant technical discipline such as Statistics, Business Analytics, Computer Science, Mathematics, or related field
• 7+ years of hands-on experience in with data analysis and predictive analytics machine learning/statistical modeling techniques
• 5+ years of experience with programming languages or packages such as Python, R, SQL, etc, including data extraction techniques across multiple database technologies
• Exploratory data analysis skills including understanding, cleaning, transforming, and reducing datasets prior to analysis
• Experience synthesizing and connecting large amounts of data identifying trends and opportunities
• Experience applying statistical methods and math to structured and unstructured data

Required Skills and Abilities:

• Strong SQL database development, modeling, and querying skills
• Experience with ELT data integration paradigm and tools like DBT, Fivetran, Rivery, Matillion or similar technologies
• Experience working on data warehousing technologies like Snowflake or BigQuery
• Understanding and experience with dimensional data modeling best practices
• Exposure to healthcare data models.
• Exposure to Cloud infrastructure tools (GCP, AWS, Azure)
• Statistics and analytics experience
• Knowledge of project and information management.
• Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams.
• Requires strong analytical, conceptual, and problem-solving abilities.
• Ability to manage multiple priorities, and assess and adjust quickly to changing priorities

Supervisory Responsibility: This position will not have supervisory responsibility.

Travel requirements: Travel may be required up to 20% locally or nationally

Work Conditions:

• Ability to lift up to 20lbs.  Moving lifting or transferring of patients may involve lifting of up to 50lbs as well as assist with weights of more than 50bs. 
• Ability to stand for extended periods
• Ability to drive to patient locations (ie. home, hospital, SNF, etc)
• Fine motor skills
• Visual acuity

The preceding functions may not be comprehensive in scope regarding work performed by an employee assigned to this position classification.  Management reserves the right to add, modify, change or rescind the work assignments of this position.  Management also reserves the right to make reasonable accommodations so that a qualified employee(s) can perform the essential functions of this role