We are a healthcare technology company that provides platforms and solutions to improve the management and access of cost-effective pharmacy benefits. As a leader in SaaS technology for healthcare, we offer innovative solutions with integrated intelligence on a single enterprise platform that connects the pharmacy ecosystem.
Requirements
- Analyze and interpret complex data
- 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
Benefits
- Paid time off
- 401k matching
- Retirement plan
- Generous parental leave