The State Corporation Commission (SCC) Health Benefit Exchange (HBE) division needs a Data Analyst to collect, analyze, and interpret large datasets from Virginia's Insurance Marketplace to identify patterns, prepare reports, and create visualizations for informed decision-making.
Requirements
- Develop SQL queries to extract, load, and manage data in a relational database.
- Develop and maintain data sets, reports, data visualizations, and dashboards to monitor the HBE’s performance for internal and external stakeholders.
- Assist in the preparation of mandatory statutory and ad hoc reports including working with end users to identify requirements, writing queries, and establishing templates.
- Identify, assess, and request resolution of data discrepancies by Virginia’s Insurance Marketplace vendor, as well as validate the vendor’s resolution.
- Collect, analyze, and interpret statistical and numerical data.
- Validate reports and dashboards provided by the vendor for the Virginia Insurance Marketplace.
Responsibilities
- Perform data mining and analysis to facilitate informed decision-making across the HBE.
- Develop SQL queries to extract, load, and manage data in a relational database.
- Develop and maintain data sets, reports, data visualizations, and dashboards to monitor the HBE’s performance for internal and external stakeholders.
- Assist in the preparation of mandatory statutory and ad hoc reports including working with end users to identify requirements, writing queries, and establishing templates.
- Identify, assess, and request resolution of data discrepancies by Virginia’s Insurance Marketplace vendor, as well as validate the vendor’s resolution.
- Collect, analyze, and interpret statistical and numerical data.
- Validate reports and dashboards provided by the vendor for the Virginia Insurance Marketplace.
Other
- Document business requirements for specific reports and analytics, and then create solutions to meet those requirements.
- Support reconciliations required by HBE finance and other stakeholders.
- Collaborate across the HBE division to educate and improve the understanding of data and analysis.
- Create and present reports on key metrics to colleagues and HBE senior leadership to support decision-making.
- Develop, implement, and maintain business processes necessary to support the data analytics team
