All openings

Data Architect

Chicago, IL, United States, Minneapolis, MN, United States, San Francisco, CA, United States

Data Architect (Data Insights)

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 dedication to helping people live healthier lives. To do this, we are committed to innovating continuously at every level. We know that some of the things we 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 supports people over their lifetime. As Rally Health founder and CEO Grant Verstandig says, “We get to do amazing work every day that directly impacts the lives of millions of people for the better."

Do you love data and supporting an organization that is dedicated to making it easier and more rewarding for people to handle their health and wellness? Rally's mission is to help people to become healthier every day by putting health and wellness tools and crucial information in their own hands. We are looking for a Principal Data Warehouse Architect to join our data team, which also includes other engineers and scientists, to drive our analytics, reporting, and business intelligence.

About the team:

Rally Data Team assists internal and external stakeholders with their data needs, ranging from building insightful custom BI dashboards, internal and external reporting and delivering partner and client extracts. This team Extracts, Transforms, and Loads data into our Enterprise Data Warehouse, utilizing various technologies, such as Spark, Python, Hive, etc.  In addition, Data Team operates in HDFS environment and works with platforms such as Databricks, Airflow, and Redshift. 

Day to day:

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.  


  • 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


Minimum Qualifications:

  • BS in Computer Science, Engineering or related technical or equivalent experience
  • 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

Preferred Qualifications:

  • Knowledge of high-scale performance and optimization tools and techniques
  • Experience with AWS (configuring, deploying, managing, monitoring) services and distributed applications

Why join Rally? On top of an innovative work atmosphere and a chance to help people change their lives, we offer competitive pay, daily catered lunches, and an extensive benefits package for all full-time employees (including medical, dental, vision and 401(k)). In addition, offer the ability to grow, while truly making an impact in the healthcare system.

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, childbirth 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 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.

Ready to Rally?

Ready to join Rally?