All openings

ETL Developer

San Francisco, CA

Do you love data and supporting an organization that is dedicated to making it easier and more rewarding for people to manage 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 Business Intelligence ETL Developer would be responsible for the design, development, implementation, and support of mission-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.

Skills and Experience

  • Ability to write complex SQL queries (Hive)
  • Experience working with Python, PySpark, and Hive for ETL and data manipulations
  • Hands on experience working with Hadoop, Hive, Mongodb, and Postgres
  • Experience working with Pentaho, Airflow, Oozie, or similar ETL platforms
  • Strong familiarity with Kimball, OLAP, and EDW methodologies
  • Knowledge of Scala is a bonus
  • Familiar with Data Visualization best practices

Soft Skills  

  • Ability to succeed in a fast-paced, Agile environment
  • Strong prioritization and time-management skills
  • Commitment to team goals that include support of live 24/7 production systems
  • A consummate collaborator, able to establish strong relationships with technical, product, and business experts
  • A champion of quality, able to QA and vouch for the integrity of the report output
  • Maintaining business stakeholder 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 deliverables 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, created from potentially multiple data sources

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.

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