• Use SQL in Teradata to structure risk models for competitive analysis reports.• Prepare reports to visualize our risks and competitive positions in the industry based on transparency data.• Create models based on the data provided from Milliman, Mercer, and Aon Hewitt, and work with the consultants.• Complete the analysis based shared claim data and compare the discounts among competitors.• Apply Macros to complete parity plans by each market, and reconcile the most possible discounts by carrier by provider.• Maintain and update data tables for the team, and be responsible for trouble shooting and debugging.• Prepare benchmark data to be submit to actuarial and consulting firms and conduct study based on these external data.