{"id":807,"date":"2025-12-12T09:30:54","date_gmt":"2025-12-12T09:30:54","guid":{"rendered":"https:\/\/skillbasedmatching.com\/jobs\/?post_type=jobpost&#038;p=807"},"modified":"2025-12-12T09:30:57","modified_gmt":"2025-12-12T09:30:57","slug":"actuarial-data-analyst-insurance-data-management-and-validation","status":"publish","type":"jobpost","link":"https:\/\/skillbasedmatching.com\/jobs\/current-jobs\/actuarial-data-analyst-insurance-data-management-and-validation\/","title":{"rendered":"\u200bActuarial Data Analyst \u2013 Insurance Data Management and Validation"},"content":{"rendered":"\n<p>This is a full-time <strong>Actuarial Data Analyst<\/strong> role at Florida Blue\/GuideWell, focusing on providing essential data support for actuarial activities. The analyst is responsible for creating, reconciling, summarizing, and analyzing data used in various actuarial analyses. A critical component of this job involves supporting the <strong>month-end close process<\/strong>, requiring availability\/on-call work during the first week of each month to manage data loads.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Location:<\/strong> Remote, United States.<\/li>\n\n\n\n<li>\u200b<strong>Annualized Salary Range:<\/strong> $$75,700 &#8211; $123,000.<\/li>\n\n\n\n<li>\u200b<strong>Typical Annualized Hiring Range:<\/strong> $$75,700 &#8211; $94,600.<\/li>\n\n\n\n<li>\u200b<strong>Experience Required:<\/strong> <strong>5+ years<\/strong> of related work experience in programming, database management, or data validation.<\/li>\n\n\n\n<li>\u200b<strong>Key Focus:<\/strong> Data reconciliation\/analysis for Actuarial, month-end data loading, data process documentation, and troubleshooting technical data issues.<\/li>\n\n\n\n<li>\u200b<strong>Market Segments:<\/strong> Supporting Medicare, Individual, Local Group, and National Account Market Segments.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u200bEssential Functions: Reconciliation, Troubleshooting, and Close Support<\/h2>\n\n\n\n<p>\u200bThe analyst acts as the key data expert for the Actuarial team, ensuring data quality, consistency, and timely availability.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Data Management &amp; Analysis:<\/strong> Create, reconcile, summarize, and <strong>analyze data used for actuarial analyses<\/strong>.<\/li>\n\n\n\n<li>\u200b<strong>Month-End Criticality:<\/strong> As part of the month-end close process, the analyst must <strong>manage data loading between the 1st and 5th of each month<\/strong> and be available to work or be on-call during this time.<\/li>\n\n\n\n<li>\u200b<strong>Technical Support:<\/strong> <strong>Troubleshoot, identify, report, and resolve technical issues<\/strong> in a timely manner. Train others regarding data sources, data limitations, and efficient retrieval methods.<\/li>\n\n\n\n<li>\u200b<strong>Process Improvement:<\/strong> History in <strong>documenting data processes<\/strong> and identifying redundancies and improvements. Experience in process improvement and workflows.<\/li>\n\n\n\n<li>\u200b<strong>Methodology Development:<\/strong> Support the design and development of methods, tools, models, frameworks of analysis, and research techniques using BCBSF business and industry relation information.<\/li>\n\n\n\n<li>\u200b<strong>Actuarial Representation:<\/strong> Represent Actuarial in workgroups, attending meetings, and <strong>UAT (User Acceptance Testing)<\/strong>, including creating and executing test cases.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u200bRequired and Preferred Skills<\/h2>\n\n\n\n<p>\u200bThe role demands strong technical execution skills, particularly in Excel and database management, with a preference for scripting knowledge.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Required Experience (5+ years):<\/strong> Experience in programming, database management, or data validation.<\/li>\n\n\n\n<li>\u200b<strong>Core Technical Skills:<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Expert Excel skills<\/strong> including VBA, Pivot Tables, using Formulas, and linking to data.<\/li>\n\n\n\n<li>\u200bHistory in documenting data processes and identifying redundancies and improvements.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u200b<strong>Preferred Technical Skills:<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u200bWorking knowledge of <strong>scripting languages and data analysis tools, including R Studio<\/strong>.<\/li>\n\n\n\n<li>\u200bExperience with <strong>user testing and ability to create and execute test cases<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u200b<strong>Communication:<\/strong> Experience working with cross-functional teams and customers to understand their needs and provide solutions.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This is a full-time Actuarial Data Analyst role at Florida Blue\/GuideWell, focusing on providing essential data support for actuarial activities. The analyst is responsible for creating, reconciling, summarizing, and analyzing data used in various actuarial analyses. A critical component of this job involves supporting the month-end close process, requiring availability\/on-call work during the first week [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","jobpost_category":[46],"jobpost_job_type":[39],"jobpost_location":[1041],"jobpost_tag":[990,3718,3720,673,3722,3719,3721,3723,81,3724],"class_list":["post-807","jobpost","type-jobpost","status-publish","hentry","jobpost_category-data","jobpost_job_type-remote","jobpost_location-united-states","jobpost_tag-5-years-experience","jobpost_tag-actuarial-data-analyst","jobpost_tag-data-reconciliation","jobpost_tag-data-validation","jobpost_tag-excel-vba","jobpost_tag-insurance-healthcare","jobpost_tag-month-end-close","jobpost_tag-r-studio-preferred","jobpost_tag-remote","jobpost_tag-uat"],"_links":{"self":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost\/807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost"}],"about":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/types\/jobpost"}],"author":[{"embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"jobpost_category","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_category?post=807"},{"taxonomy":"jobpost_job_type","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_job_type?post=807"},{"taxonomy":"jobpost_location","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_location?post=807"},{"taxonomy":"jobpost_tag","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_tag?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}