About

Careers at RxSense

Our culture is more than a set of values, principles and promises. It’s the dynamic embodiment of who we are, where we’ve been and where we’re headed tomorrow.

SSIS Developer

Job Title
SSIS Developer
Job ID
27622852
Location
Boston,  MA
Other Location
New Jersey
Description
SSIS Developer

About Us

RxSense is a Boston-based health technology company offering powerful technology solutions built to make prescription drugs more affordable for all.  We operate two business units – Enterprise Platform Solutions (EPS), which provides turnkey technology services to employers, health plans, and others who wish to administer pharmacy benefits, and Direct to Consumer (DTC), which offers cash pay prescription benefits to people under the consumer brand SingleCare.

Incorporated in 2014, RxSense is one of the fastest-growing companies in New England.  We are privately held and proud to have been recognized by Fast Company as one of 2020’s Most Innovative Companies, and by Forbes as a 2020 Best Startup Employer.  Our CEO and Founder, Rick Bates, was named the EY New England Entrepreneur of the Year award winner in 2018.

Responsibilities
  • Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution, and data distribution.
  • Implementing Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.
  • Coordinate with Business Analyst to validate requirements, perform interviews with users and developers.
  • Implementing solutions to integrate external data with in-house data.
  • Perform tests and validate data flows and prepare ETL processes according to business requirements.
  • Designing and implement a data conversion strategy from legacy to new platforms.
  • Perform design validation, reconciliation, and error handling in data load processes.
  • Ability to write complex SQL queries
  • Optimize SSIS Package execution and SQL execution to optimize data load performance.

Qualifications
  • 4+ Years hands-on experience in using T-Sql / PL-Sql, SSIS tool set.
  • 5+ Years of experience in ETL / ELT implementations.
  • Extensive knowledge of BI concepts (ETL, Dimensional Modeling, Data warehouse Design)
  • Understand DB indexes, Partitions and Explain Plans etc.
  • Experience in Migrations, Deployments, Bit-Bucket integrations.
  • 3+ Years of experience in Production Support and Maintenance.
  • 3+ Years of experience in Scription (PowerShell or any other)
  • Experience in building monitoring & alerting mechanisms for data pipelines
  • Working Knowledge in developing Integrations using APIs, such as REST, SOAP, JDBC/ODBC connections.
  • Strong Analytical and Problem-solving skills, Excellent Written and Verbal Communication skills.

Option 1: Create a New Profile