
Very good written and verbal communication skills. Excellent analytical and problem-solving abilities. Experience with relational data models. Experience working with transactional data. At least one year working experience with SQL. Computer Science, Computer Engineering or similar field Provide input on best practices and procedures. Provide significant improvements to the product(s) being supported. Acts as a member of a product team supporting teammates and collaborating with a “do what it takes attitude” to ensure product and team success. Designing, developing and implementing custom software and database application capabilities for a variety of legacy and modernized systems with limited oversight. Use project management platforms like Asana to capture progress and roadblocks. Document findings clearly and concisely.
Ensuring product quality and timeliness of work, providing advice and guidance, resolving problems to meet objectives, and providing periodic performance reports. Collaborate with business users to communicate roadblocks and set appropriate expectations. Interface with third party data vendors in support of reconciliation. Generate audit reports and review results with cross-functional team.
Cross-reference database findings with contract terms for specific clients.Identify and correct inefficient queries and/or processes.Develops stored procedures and/or triggers using PL/SQL.Performs database analysis, design and development, security support, and performance tuning.Use TOAD as an Oracle querying tool to reconcile expected versus observed outcomes.The successful candidate is a team player who is organized, detailed oriented and pro-active.
The audit team clarifies methodologies and conducts deeper dives into client data to uncover potential root causes of anomalies. You will work with a cross functional team throughout the audit process, identify gaps in contractual service and generate reports for reconciliation. As a SQL Developer at Remedy you will use data analytics to take a detailed look at complex pharmaceutical transactions and evaluate PBM performance to contract in our audit division.