Data Engineer

VitaCare, a wholly owned subsidiary of GoodRx, helps consumers and providers navigate the steps they need to purchase affordable and convenient prescriptions. Over 500 million brand prescriptions are written each year, yet only half are ever filled. VitaCare manages the complexity of coverage and access for patients with the end goal of assisting healthcare professionals, brand manufacturers and consumers with finding a solution that works for the patient.Acquired in April 2022, vitaCare enables GoodRx to help more patients receive their prescriptions in an efficient, affordable, and transparent manner, and stay on their prescribed therapies as long as appropriate. As a part of GoodRx’s rapidly growing Pharma Manufacturer Solutions organization, vitaCare is a core part of GoodRx’s offerings spanning medication awareness, access, and adherence with unique capabilities. We’re committed to growing and empowering a more inclusive community within our company and industry. That’s why we hire and cultivate diverse teams of the best and brightest from all backgrounds, experiences, and perspectives. We believe that true innovation happens when everyone has a seat at the table and the tools, resources, and opportunities to excel.
With that said, research shows that women and other underrepresented groups apply only if they meet 100% of the criteria. GoodRx is committed to leveling the playing field, and we encourage women, people of color, those in the LGBTQ+ communities, and Veterans to apply for positions even if they don’t necessarily check every box outlined in the job description. Please still get in touch - we’d love to connect and see if you could be good for the role!
The vitaCare Prescription Services team is looking for an intelligent and curious Data Engineer to join our growing team as a critical member focused on advancing the data practice and providing remote customer support. This person will work on both new and existing initiatives within an amazing culture that boasts a shorter feedback cycle, self accountability, and values your mental health.
In this role, you will perform troubleshooting, administration, monitoring, tuning, and operations functions on SQL and DynamoDB databases for mission-critical applications for our online pharmacy. You must be able to understand advanced database technology concepts at a detailed level, be able to ask solutions driven questions, and work well with vendors, SME's, engineers, management and customers . Excellent communication skills are important including an ability to explain complex database concepts to all levels of system users and management. 

Responsibilities

• Implement redundant solutions, policies, and procedures for disaster recovery and data archiving to ensure the protection and integrity of data assets.
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.,
• Build, documents and manage new and existing data pipelines and processes
• Understand advanced database architecture, distributed infrastructure, and various network technologies to implement robust and scalable solutions for the company
• Monitor and maintain production and non-production database environments Perform database transaction and security audits.
• Establish appropriate end-user database access control levels.
• Respond to and resolve database access and performance issues.
• Conduct code reviews for best practices
• Provide database backup and recovery services Contribute to standards, procedures, and guidelines for the effective and secure use of the databases and database features Monitor, optimize, and allocate physical data storage for database systems.
• Perform general database troubleshooting, debugging and testing for problem resolution
• Provide migration services to oversee changes to the production environments 
• When provided access to personal, proprietary and/or otherwise confidential data, maintains such data in the strictest confidence and follows procedures to ensure the privacy, security, and proper use of data
• Perform and/or automate patching on existing databases

Required Qualifications

• 5+ years Relational Database experience3+ years NoSQL Database experience
• Experience in mission critical, high availability, high-reliability environments 
• Demonstrable experience with programming languages (SQL, PowerShell, Python)Strong customer Service orientation Strong analytical and problem-solving skills 
• Ability to work well under pressure 
• Proven ability to work in a team environment 
• Ability to develop and maintain documentation

Preferred Qualifications

• Familiarity with AWS cloud hosting, including EKS and RDS Microsoft SQL Server experience Familiarity with SSRS/SSIS 
• Working knowledge of data privacy practices and laws.
• Excellent verbal, written, and interpersonal communication skills
• Ability to read and understand software specifications
• Experience with data processing flowcharting techniques
• Proficient with Atlassian Jira or other issue/change management platforms and tools
• Proficient with Atlassian Confluence or other collaboration tools

VitaCare, a wholly owned subsidiary of GoodRx, is a technology and services platform that helps patients navigate key access and adherence barriers for brand medications. Specifically, vitaCare helps patients understand coverage and identify available savings opportunities, and facilitates communications between providers and payors. The platform also offers a seamless path for filling a prescription, primarily through its network of third-party pharmacies. For more information, visit vitacarerx.com.