All openings

Sr. BI Analyst (MySQL) Real Appeal

Los Angeles, San Francisco, Denver, Minn, Chicago, Washington DC, remote

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 Senior Business Intelligence Analyst would be responsible for the design, development, implementation, and support of critical ETL solutions in MYSQL, sourcing data from Oracle.

You will initiate weekly ETL updates, support a rigorous validation process, provide technical guidance to other team members, act as the primary subject matter expert on database construct, technical design, and data transformation. You will work closely with our data analytics team to support their efforts in providing quality, accurate, and timely information to our customers.

Required Skills and Experience

  • Advanced working knowledge and ability to write complex and efficient SQL in MYSQL and Oracle environments for the purposes of data transformations and ETL.
  • Strong familiarity with Oracle and MYSQL database architecture.
  • Extensive experience working with health-related data.
  • 7+ years working in or directly supporting reporting/informatics areas.

Useful Skills and Experience

  • Experience in database design and developing solutions in Tableau
  • Project management
  • Familiar with Data Visualization standard methodologies

Soft Skills

  • Ability to adapt to a rapidly changing environment and creating appropriate and timely solutions.
  • Strong prioritization and time-management skills
  • Dedication to team goals that include delivery and support of data to a variety of stakeholders.
  • A champion of quality, able to QA and vouch for the integrity of the data
  • Assess current processes and recommend changes as needed
  • Document and communicate 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