RxSense · 1 week ago
Senior Data Engineer
United States
Full-time
Remote
Senior Level, Lead/Staff
8+ years expRxSense is a healthcare technology company that provides platforms and solutions to improve the management and access of cost-effective pharmacy benefits. They are looking for a Senior Data Engineer to support their Data Platform Stack, ensuring optimal data delivery architecture and collaborating with cross-functional teams on data-driven initiatives.
Cloud ManagementHealth CareInformation ServicesInformation TechnologySoftware
Responsibilities
Analyze and interpret complex data Ability to identify data anomalies and resolve data issues
Understand specific business processes and domain concepts and relate them to data subject domains
Optimize SQL queries, scripts, and stored procedures in Snowflake and SQL Server to improve efficiency and reduce processing time
Integrate and manage data from various sources, ensuring data quality, reliability, and performance
Design, develop, and maintain scalable and high-performance ETL pipelines using Matillion ETL to ingest, transform, and load data into Snowflake
Monitor data pipeline and ETL performance, identifying bottlenecks and making necessary adjustments to ensure optimal system performance
Perform troubleshooting and root cause analysis to resolve data issues and prevent future occurrences
Develop and implement data models within Snowflake to support business intelligence and analytics requirements
Collaborate with Data Leads, Product Managers and QA Engineers to validate requirements, participate in user requirement sessions
Perform tests and validate data flows and prepare ETL processes according to business requirements
Perform ETL tuning and SQL tuning
Ability to document data flows representing business logic in ETL routines
Design and implement 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
Qualification
Required
Must be well versed with Data warehousing concepts including design patterns (Star schemas, Snowflake design schemas)
Must be aware of data modeling concepts including the data modeling Normal forms
Knowledge of AWS Infrastructure including S3, SNS, EC2, CloudWatch and RDS
8+ years working in ETL/Data transformation projects with one or more related products such as Informatica or Talend or Microsoft SSIS
Experience in business intelligence, data warehousing initiatives
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases like Oracle or MS SQL Server or Snowflake
Strong SQL and Python skills with experience in query optimization and performance
Strong analytical, problem-solving, and communication skill
Bachelor's in mathematics, Computer Science or related technical field
Preferred
Experience with additional ETL tools, data transformation methods, or cloud platforms
Healthcare and PBM: PBM-specific knowledge and experience with transforming various healthcare data
Experience with Matillion ELT tool and Snowflake Database
Experience in building AWS Data Pipelines using Python or Spark, SparkSQL in any of Cloud Environments (AWS / Azure / Google)
Company
RxSense
RxSense is a health technology company provides IT solutions for flexible, efficient, and transparent pharmacy benefits administration.
201-500 employees
H1B Sponsorship
RxSense has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (3)
2023 (4)
2022 (1)
2021 (5)
2020 (10)
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
Parthenon Capital Partners
2020-05-12Private Equity
Leadership Team
R
Rich Saleh
VP Pricing and Analytics
Recent News
2025-12-20
2025-12-17
2025-12-12
Company data provided by crunchbase