Senior Data Engineer

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