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 experienced Business Intelligence professionals to join our data team, which also includes engineers and scientists, to drive our analytics, reporting, and business intelligence.

Rally's data team is dedicated to analyzing data from consumers interactions with their healthcare insurers and providers, monitor trends, and develop strategies and opportunities to improve their health and lower their costs. We partner with employers and healthcare insurers, providing a great UI for covered members and their families to manage both their health and healthcare options. We develop actionable insights for population health management and positive recommendations for ways individuals can improve their health and manage their costs.

As an integral member of our team, the Manager, Data & Analytics would be responsible for leading the design, development, implementation, and support of critical enterprise E2E Business Intelligence ETL solutions in Hadoop, sourcing data from HDFS, Amazon Redshift, MongoDB or Postgres environments and utilizing Python, Spark, and Hive.

You will handle the product's or project’s conception, design initial product specifications and lead scheduling, estimating and securing of resources, as well as provide technical guidance to other internal and external teams; help to train new employees and stay ahead of industry trends and issues.

Required Skills and Experience

• Advanced working knowledge and ability to write complex SQL and HQL queries in an HDFS environment

• Extensive hands-on experience working with Python and PySpark for the purposes of data transformations and ETL

• Strong familiarity with Kimball, OLAP, and EDW data design methodologies

• 8+ years experience in ETL, Data Engineering, or BI fields with concentration on data transformations

Useful Skills and Experience

• Understanding of various data extraction and transformation techniques with data sourced in HDFS, MongoDB, and Postgres

• Working familiarity with Pentaho, Airflow, or Oozie

• Knowledge of Scala is a bonus

• Familiar with Data Visualization standard methodologies

Soft Skills

• Ability to succeed in a dynamic, Agile environment

• Strong prioritization and time-management skills

• Dedication to team goals that include support of live 24/7 production systems

• A consummate collaborator, able to establish good relationships with technical, product, and business owners

• A champion of quality, able to QA and vouch for the integrity of the report output

• Maintaining business partner engagement and setting expectations

• Assessing current processes and recommending changes as needed

• Documenting and communicating technical specifications to ensure that proper and optimized techniques, queries, data standards, and final outputs are understood and incorporated into data and analytics processes

• Participate in business analysis activities to gather required reporting and dashboard requirements

• Translate business requirements into specifications that will be used to implement the required user-friendly environments, reports and dashboards, built from potentially multiple data sources

 About Rally Health:

Our benefits package is highly competitive with others in tech, offering great options that attend to your physical, emotional, financial and career health. We have low deductible, modest employee contribution health care options through UnitedHealth, and an option for a higher deductible plan accompanied by an HSA that Rally pays for. We have vision and dental care, disability income protection, FSA, and life insurance benefits that extend to you and your dependents. We serve catered lunch each day and stock the kitchen with snacks for those of us who need to be reminded to eat. And, of course, we grant to our employees access to the Rally Engage app that offers challenges and incentives to keep us well. On the emotional well-being side of things, we know that people who work as hard as Rallyers need to catch their breath. So, we offer PTO-with-trust; meaning, you take it when you need it and we don't add up how much you've used. For those that need a little extra care, we are partnering with Ginger.io to make employee support accessible via text. Financially, we offer competitive cash compensation and equity, 401k matching, and surprise bonuses to those who surprise us with their contributions. And, perhaps most importantly, we offer a company with a purpose, jobs that demand your very best work, and opportunities to learn, grow, and build your career.

 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 an accommodation related to the application and/or review process should notify our recruiting team (recruiting@rallyhealth.com).

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