All openings

Data Warehouse Architect

San Francisco, CA, Chicago IL


Rally Health is all about putting health in the hands of the individual. It’s our mission, and it drives everything we do, which is to empower people with easy-to-use online and mobile tools that help them take charge of their health and health care, from improving their diet and fitness to selecting health benefits, and choosing the right doctor at the right price for their needs.  Our culture is built on a deep and sincere commitment to helping people live healthier lives. To do this, we are committed to innovating at every level. As our president and COO David Ko says, “We are a company that continuously innovates. It cannot end. It has to be in everything we do, which means that some of the things we’re going to do are not going to work – and that’s okay. We’re not trying to build something that is churn and burn. We’re building something that follows consumers over their lifetime.”

About this position

We are looking for a Data Warehouse Architect who will lead the evolution of our next-gen Data Warehouse and will be  responsible for enabling the massive amount of Data to be used for various production scenarios and insights.  Responsibilities include but not limited to:

  • Architect and lead technology of large scale and high traffic data warehouse platform
  • Conceive, design, develop and deploy the data architecture and data models from scratch
  • Collaborate across business units (BI, Product, Reporting) to develop data warehouse platform vision, strategy, and roadmap
  • Train and mentor the team in data modeling and data quality related processes and standards


  • Bachelor’s degree in Computer Science or related fields
  • 5+ years of prior experience in Data Warehousing
  • Strong conceptual, relational and dimensional data modeling skills
  • Data modeling expertise and a thorough understanding of logical modeling concepts
  • Strong SQL abilities and experience with massive relational database systems.
  • Experience building ETL and familiarity with design principles
  • Experience with distributed systems and application design in a SOA environment
  • Being analytical with strong problem solving skills and attention to detail
  • Being a self-starter and results-oriented with a strong sense of ownership
  • And for bonus points:
    • Knowledge of high-scale performance and optimization tools and techniques
    • Experience with AWS (configuring, deploying, managing, monitoring) services and distributed applications

 About Rally Engineering

Rally is full of flexible minds as we believe in “strong opinions, weakly held”.  We work in small teams which are mission driven and are independent to make their decisions.  We are obsessed with “customer first” mindset. We work hard and celebrate big. We are a proud set of engineers, really motivated to fix Healthcare.

Our tech stack is modern, in public cloud (AWS), microservices based large distributed system and is quality driven.  We believe in continuously evaluating our tech stack, have an easy process of suggesting and adopting new technologies.  Our engineers enjoy being empowered and accountable. Set of technologies consist of:

  • Scala, Play, Akka,
  • MongoDB, PostgreSQL, ElasticSearch
  • AWS, Docker, Mesos, Marathon, Jenkins
  • Kafka, Spark, HDFS, Avro, Airflow and Redshift

Rally Health is committed to ensuring that its workforce reflects America’s diverse population. Rally Health knows that such diversity will enrich us with the talent, energy, perspective and inspiration it needs to achieve its mission. Rally Health believes in a policy of equal employment and opportunity for all people based on merit and commitment to the principles of diversity. It is our policy to recruit, hire, train, and promote individuals in all job titles, and administer all programs, without regard to race, color, religion, national origin or ancestry, citizenship, sex, age, marital status, pregnancy, child birth or related medical conditions, personal appearance, sexual orientation, gender identity or expression, family responsibilities, genetic information, disability, matriculation, political affiliation, veteran status, union affiliation, or any other category protected by applicable federal, state or local laws.

Individuals with disabilities and veterans are encouraged to apply. Applicants who require an accommodation related to the application and/or review process should notify Talent Acquisition (

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.