Full-Time

Sr Data Modeler

Confirmed live in the last 24 hours

PatientPoint

PatientPoint

501-1,000 employees

Delivers targeted health information solutions

Biotechnology
Healthcare

Mid, Senior

Cincinnati, OH, USA

Hybrid schedule: 3 days in office / 2 days at home weekly.

Category
Data Management
Data Engineering
Data & Analytics
Required Skills
Agile
Data Science
SQL
Machine Learning
Snowflake

You match the following PatientPoint's candidate preferences

Employers are more likely to interview you if you match these preferences:

Degree
Experience
Requirements
  • 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.
Responsibilities
  • Design and build within a modern data architecture using Snowflake and Atlan along with other tools to add product features for each ART.
  • 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.
  • Responsible for Metadata Management using Atlan and Snowflake to define, govern, and manage metadata for our data product.
  • 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.
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.

PatientPoint enhances patient engagement and education in healthcare by providing an engagement platform that delivers targeted health information at critical points in the care journey, such as waiting and exam rooms. The platform ensures patients receive relevant information when needed, positively influencing their health behaviors. Unlike competitors, PatientPoint connects healthcare providers with pharmaceutical companies through point-of-care marketing, delivering tailored messages that promote better health practices. The company's goal is to improve health outcomes by ensuring access to the right information at the right time, enhancing the overall patient experience.

Company Stage

Late Stage VC

Total Funding

$136.3M

Headquarters

Cincinnati, Ohio

Founded

1987

Simplify Jobs

Simplify's Take

What believers are saying

  • Rising demand for personalized healthcare boosts PatientPoint's engagement platform.
  • Telehealth expansion allows PatientPoint to reach patients beyond traditional settings.
  • AI in healthcare enhances PatientPoint's targeted health information delivery.

What critics are saying

  • Partnership with MyHealthTeam may raise data privacy concerns.
  • C-Suite changes could disrupt company operations during transition.
  • Impact Calculator adoption may face resistance from healthcare systems.

What makes PatientPoint unique

  • PatientPoint customizes health content for unique patient needs in care settings.
  • Recognized for 12 years by National Health Information Awards for consumer health information.
  • Integrates health education in sports through partnerships like with New Orleans Saints.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Unlimited Paid Time Off

Hybrid Work Options

Mental Health Support

401(k) Retirement Plan