Job description


RxSense is a privately held health technology company whose mission is to make prescription drugs more affordable for everyone. We build technology platforms and data solutions that enable our customers to manage pharmacy benefits on behalf of their members, employees or clients (e.g. health plans, employers, health systems, etc.).

RxSense also provides prescription benefit solutions directly to millions of people through its consumer brand, SingleCare. We have saved our customers over $4B on prescription medications since 2015. We are working together to solve big problems and create value in an industry that is personal for everyone - healthcare.

Position Summary:

The Data Engineer will support our developers, database architects, data analysts on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.
  • Analyze and interpret complex data and provide resolutions to data issues.
  • Coordinate with data analyst to validate requirements, perform interviews with users and developers.
  • Perform tests and validate data flows and prepare ETL processes according to business requirements.
  • Perform ETL tuning and SQL tuning.
  • Perform data modeling and schema design, including dimensional and big data modeling.
  • Designing and implement a data conversion strategy from legacy to new platforms.
  • Perform design validation, reconciliation and error handling in data load processes.
  • Design and prepare technical specifications and guidelines including ER diagrams and related documents.

  • Possesses a thorough understanding of RxSense products and services
  • Deep expertise in data extraction, data wrangling and data preparation
  • Experience with ETL/Data Transformation
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • Experience in building AWS Data Pipelines using Python/Scala, Apache Spark, SparkSQL, S3 Data Lake, Snowflake
  • Good to have - Experience with any of the NoSQL datastores such as ElasticSearch, MongoDB, DynamoDB, Cassandra
  • Bachelor’s in mathematics, Computer Science or related technical field. Post graduate degree preferred. Minimum 5 years of relevant experience.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.