Data Modeler

Posted 2 Days Ago
Easy Apply
Be an Early Applicant
Cincinnati, OH
Senior level
AdTech • Digital Media • Healthtech • Marketing Tech • Sales • Analytics • Pharmaceutical
Empower Better Health
The Role
As a Data Modeler, you'll develop and enhance data models and the semantic layer to support reporting and analytics. You'll collaborate with Agile teams, build advanced SQL queries, and work on cloud-based solutions, particularly with AWS and Snowflake, to solve complex data-related challenges.
Summary Generated by Built In

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 Data Modeler, you will report to the Director of Data Engineering. Your role will involve developing, updating, and enhancing data models and the semantic layer to support reporting, data visualization, business intelligence, and data science. As a Data Architecture expert, you will be a key 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, continuously improving data models while using your technical expertise for data analysis to support recommendations and solve moderate to complex 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.
  • 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.

What We Need  

  • 8+ years of experience in data architecture, with at least 4 years focusing on cloud-based solutions.  
  • Experience in developing data models, data integration processes, and data flows on AWS cloud platform. 
  • 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.  
  • 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.
  • Experience with various patterns of data ingestion, processing, and curation.
  • Tableau experience preferred.
  • Experience implementing data quality initiatives, such as test harnesses, monitoring, and auditing features.
  • Familiarity with CI/CD workflows using GitHub.
  • Experience with Redshift, Treasure Data, or Microsoft Azure is helpful.
  • Expertise in building/designing data pipelines using Python, Snowflake, and Airflow preferred.
  • Knowledge of AWS data storage and management technologies like S3.
  • Familiarity with orchestration technologies such as Airflow or Astronomer

What You'll Need to Succeed  

  • A team player with a solid work ethic and the ability to collaborate productively with a distributed team.
  • Innovative and solution-oriented mindset with a positive attitude.
  • Strong business acumen and problem-solving competency.
  • Effective written and verbal communication skills at all levels of the organization.

#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

Top Skills

AWS
Snowflake
SQL

What the Team is Saying

Cindy
Gigi
Jacob
Erika
Steven
Falancia
Amanda
Alan
Kimberly
Hilliary
Jyothi
The Company
HQ: Cincinnati, OH
660 Employees
Hybrid Workplace
Year Founded: 1987

What We Do

At PatientPoint, we're transforming every doctor-patient interaction with cutting-edge, technology-driven solutions designed to improve health outcomes and quality of life. By delivering impactful, digital, in-office patient education at no cost to physicians across the country, we empower healthcare professionals to connect more meaningfully with their patients. Through partnerships with trusted healthcare brands like Pfizer, P&G, Sanofi, Merck, NatureMade, and Bristol Myers Squibb, we’re making a real difference. Our mission to empower better health guides everything we do, reaching over 750 million patient visits each year and driving healthier, longer lives for patients everywhere.

From the top down, we operate within a culture of collaboration and open-minded thinking. We are in it to win it as a team working together, not competing with each other. Your thoughts and ideas are equally valued by leadership and your colleagues. Our employees embody our company values: they’re trustworthy, driven, innovative and welcoming of diversity. You’ll enjoy being part of our group.

We’re always learning, and we encourage entrepreneurial thinking. We challenge the status quo and are open to new ideas from every corner of the organization. You can help make a difference in the healthcare industry by discovering groundbreaking solutions that provide value to patients, providers, and sponsors.

As a company that is still growing and always evolving, we provide plenty of career and learning potential. Here, you’ll work to advance the industry, develop your career goals and be rewarded for your efforts. It’s all within reach, because playing a key part in our success will enhance yours.

PatientPoint is the trusted and fully established leader in patient engagement platforms. Our employees are proud to include our name on their resumes. Joining us has definite advantages: stability, rewards and benefits, professional growth potential, plus the knowledge you are in the right place to do your best work.

Why Work With Us

We are 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.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

PatientPoint Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Our team members span across the United States. We have offices in multiple cities, stay connected virtually, and get together every so often. We encourage those near an office to visit on our anchor days - Monday, Tuesday, & Thursday.

Typical time on-site: 3 days a week
Company Office Image
HQCincinnati, OH
Company Office Image
Baltimore, MD
Company Office Image
Brentwood, TN
Company Office Image
Chicago, IL
Company Office Image
New York, NY
Tampa, FL
Learn more

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account