Enterprise Data Architect

| Chicago

Why VillageMD?

VillageMD is changing the trajectory of healthcare by empowering primary care physicians to make informed decisions and engage patients in meaningful ways. We work with thousands of clinicians and healthcare disruptors across the country to build and contribute to our platform to improve patient health while driving down the cost to deliver it.

We are a mission-oriented organization and are thrilled about the work that we do every day. We’re transparent, collaborative, and relentless in pursuit of our mission, all while doing so with humility and a low ego. We believe that diverse backgrounds and experiences create the best opportunity for innovation and the community that we are creating is greater than any individual.

We’ve built our technology using the best of cloud and open-source technologies to create an open, data-first platform that is enriched with analytical models and modernly connected to internal and external apps. These apps drive clinical decision support, patient engagement, and other facilitators of innovative, information-enriched health experiences.

Enterprise Data Architects at VillageMD design relational, schemaless, and graph based data models to enhance our organizational capability to make great products. We're in a unique position to impact everyone in primary care from independent, family owned practices to world class health systems. We aggregate, process, and make accessible rich datasets to improve the effectiveness of primary care for our doctors and patients. 

What are examples of work that Enterprise Data Architects have done at VillageMD?

  • Researched and synthesized multiple data models to create a universal view of clinical information across many EMRs
  • Analyzed stored procedures, stats and queries to figure out data access patterns
  • Collaborated with analytics and operations to create data views that enable predictive analytics training sets

What will make you successful here?

  • A desire to be accountable for owning problems from design to implementation that solve healthcare interoperability
  • An ability to evangelize data models to developers and analysts
  • Flexibility to adapt to multiple standards based on the use case and technology
  • A bias for action and pragmatic solutions
  • A low ego and humility; an ability to gain trust through communication and doing what you say you will do

What you might do in your first year:

  • Contribute to the OHDSI ecosystem with a new data model
  • Transform an existing schemaless model into a relational OLTP model
  • Lead an implementation of an enterprise wide data ontology initiative
  • Implement a graph based model to enhance patient matching
  • Refactor a set of queries and views to increase performance and make data access logically approachable

The following experience is relevant to us:

  • 5+ years of full-time experience
  • Expert level development skills in SQL and at least one other database language (Cassandra, Columnar, OLAP) is required
  • Experience in Healthcare industry is required
  • Experience managing multi tenant data models
  • Experience using schema migration technologies (Alembic, Rails Migrations, etc.)
  • Strong knowledge of relational databases and data modelling (MSSQL and Postgres)
  • Familiarity with alternative data storage technologies (S3, MongoDb, Redis, Neo4j)
  • Experience various data modelling approaches (eg stars schema, Type 2, snapshots, schemaless)
  • Experience with the warts of clinical and financial healthcare data will help (a lot)
  • BS/MS/PhD in Computer Science or a related field (ideal)

At VillageMD, we see diversity and inclusion as a source of strength in transforming healthcare. We believe building trust and innovation are best achieved through diverse perspectives. To us, acceptance and respect are rooted in an understanding that people do not experience things in the same way, including our healthcare system. Individuals seeking employment at VillageMD are considered without regard to race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Read Full Job Description

Technology we use

  • Engineering
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • ReactLibraries
    • FlaskFrameworks
    • Node.jsFrameworks
    • Microsoft SQL ServerDatabases
    • Neo4jDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • TeradataDatabases

Location

We are in the heart of downtown Chicago - accessible to all trains and plenty of food/drink options nearby!

An Insider's view of VillageMD

What's the biggest problem your team is solving?

Aggregating disparate into one consumable interface is difficult. We constantly think about how to solve it faster and better while keeping it flexible and scalable.

Mario

Principal Software Engineer

What makes someone successful on your team?

It’s an individual’s willingness to get into the details, fully understand the current delivery , and think critically about the problems that face primary providers today, that will make them successful at VillageMD.

Dave

Director, Product Development

What’s the vibe like in the office?

The office vibe is centered on holding our work to high standards while maintaining an environment focused on fun and . My coworkers and I will often be working on completely unrelated projects, but when we hit a roadblock we step back and ask each other for feedback and help. That’s usually when we find the best solution to .

Emily

Healthcare Informatics Analyst

What are VillageMD Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Happy Hours
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
More Jobs at VillageMD16 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Operations
Product
Project Mgmt
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago