New

Sr Data Modeler

Cincinnati, Ohio, United States

Join PatientPoint to be part of a dynamic team committed to empower better health. As a leading digital health company, we innovate to positively impact patient behaviors. Our purpose-driven approach offers an inspirational career opportunity where you can contribute to improving health outcomes for millions of patients nationwide.

Location: Cincinnati 

Hybrid Schedule: 3 days in office / 2 days at home weekly 

Job Summary  
As a Sr. Data Modeler on the team, you will report to the Director of Data Engineering. The Data Modeler is responsible for developing, updating, and enhancing data models and semantic layer to support reporting, data visualization, business intelligence, and data science. As a Data Architecture expert, the Data Modeler will be an integral member of the Data Engineering organization collaborating with multiple Agile squads to build and deploy advanced SQL queries following best practices from Inmon and Kimball.

You will work in a highly collaborative lean Agile environment to build and continuously improve our data models in addition to using your technical experience and expertise for data analysis to support recommendations along with judgment to make decisions or solve moderate to complex tasks or problems.   

What You’ll Do  

  • Design and build within a modern data architecture using Snowflake and Atlan along with other tools to add product features for each ART. Your data models and robust semantic layer will support visualizations, business intelligence, and data science.  
  • Clearly communicate solutions to both technical and non-technical team members. 
  • Responsible for enforcing the Data Modeling and Data Architecture standards across the Data and Analytics organization. 
  • Advanced SQL query development experience required.  
  • Responsible for Metadata Management using Atlan and Snowflake to define, govern, and manage metadata for our data product. Must have expertise with metadata repositories, this role will build and maintain the integrity of our data product semantics and glossary.   
  • You will manage and update the enterprise data architecture artifacts, Data glossaries, data architecture, data flows, and processes.  
  • Communicate daily with team members regarding product features, development progress and barriers.  
  • Translate business problems into data solutions and connect to business impact.  
  • Apply defined best practices to the development and support of our Data Warehouse, relational structures, dimensional data modeling and structured query language (SQL) skills.  
  • Evaluate and recommend new data management technologies and tools.  
  • Optimize data architecture for performance, cost, and efficiency.  
  • You will be challenged to be innovative in your approach to integrate, secure and scale data from multiple internal and external data sources while reducing technical debt.  

What We Need  

  • 4+ years of experience in data modeling. 
  • 4+ years focusing on cloud-based solutions.  
  • Experience in developing data models, data integration processes, and data flows on cloud platforms. 
  • Understanding of Kimball Data Warehousing design principles, Unified Star Schema (USS) or Data Vault. 
  • Firsthand experience in building large scale data warehousing solutions on Snowflake.  
  • Experience developing dimensional data models and semantic data layer.  
  • Hands-on experience in relational and multi-dimensional data modeling, including multiple source systems from databases and flat file. 
  • Proven experience implementing complex stored procedures along with an understanding of standard DWH and ELT concepts.  
  • Effective Communication Skills both written and verbal within all levels of the organization.  
  • Familiarity with machine learning and Data Science technologies their unique data requirements  
  • Ability and willingness to work within a lean Agile team to translate needs of our business partners into product features which enhance our self-service data platform.   
  • Proven experience delivering within a distributed team.  

Desired Qualifications  

  • Bachelor’s degree in computer science or a related field  
  • You have experience with various patterns of data ingestion, processing, and curation.  
  • Experience with Looker preferred.  
  • Experience implementing data quality initiatives such as test harnesses, monitoring, and auditing features on data.  
  • Experience with CI/CD workflows using GitHub preferred.  
  • Experience with Redshift, Treasure Data or Microsoft Azure is helpful  
  • Build/Design data pipeline using Python/Snowflake/Airflow preferred.  
  • Experience with AWS data storage and management technologies such as S3  
  • Familiarity with orchestration technologies (e.g., Airflow, Astronomer)  
  • First-hand experience with Airflow.  

What You'll Need to Succeed  

  • A team player with a solid work ethic with the ability to collaborate productively with a distributed team.  
  • Innovative and Solution-oriented mindset along with a positive attitude  
  • Strong business acumen and problem-solving competency  

#LI-ED1 #LI-Hybrid 

About PatientPoint: 
PatientPoint is a leading digital health company that connects patients, healthcare providers and life sciences companies with the right information in the moments care decisions are made. Our solutions are proven to influence patient behavior and improve health outcomes, driving value for all stakeholders. Across the nation’s largest network of connected digital devices in 35,000 physician offices, PatientPoint solutions empower better health for more than 750 million patient visits each year.

Latest News & Innovations: 

  1. Named one of MM+M’s 2024 Best Places to Work! Read More
  2. Partnership announcement with MyHealthTeam.Read More
  3. Featured on Built In’s "Insights from Top Sales Leaders." Read More

What We Offer: 
We know you bring your whole self to work every day, and we are committed to supporting our full-time teammates with a comprehensive range of modernized benefits and cultural perks. We offer competitive compensation, flexible time off to recharge, hybrid work options, mental and emotional wellness resources, a 401K plan, and more. While these benefits are available to full-time team members, we strive to create a positive and supportive environment for all teammates.

PatientPoint recognizes that privacy is important to you. Please read the PatientPoint privacy policy, we want you to be familiar with how we may collect, use, and disclose your information. Employer is EOE/M/F/D/V

Create a Job Alert

Interested in building your career at PatientPoint? Get future opportunities sent straight to your email.

Create alert

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in PatientPoint’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.