ETL Developer/Data Engineer

Description

Company
RxSense is a Pharmacy Benefits Management company headquartered in Boston, MA, with offices in New York, New Jersey, and Florida.
Pharmacy Benefit Managers (PBMs) reduce prescription drug costs and improve convenience and safety for consumers, employers, unions, and government programs. As such, PBMs are primarily responsible for developing and maintaining the formulary, contracting with pharmacies, negotiating discounts and rebates with drug manufacturers, and processing and paying prescription drug claims.
Responsibilities
RxSense is looking for a data engineer for the RxSense Data Services and Analytics organization. Responsibilities include 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.
Qualifications
Deep expertise in data extraction, data wrangling and data preparation
Experience with ETL/Data Transformation and one or more related products such as Informatica and SSIS.
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Knowledge of databases, data warehousing, and data modelling.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
BS in Mathematics, Computer Science, Information Management or Statistics