{"id":806,"date":"2025-12-12T09:27:42","date_gmt":"2025-12-12T09:27:42","guid":{"rendered":"https:\/\/skillbasedmatching.com\/jobs\/?post_type=jobpost&#038;p=806"},"modified":"2025-12-12T09:27:45","modified_gmt":"2025-12-12T09:27:45","slug":"data-warehouse-analyst-contract-specialty-insurance-bi-etl","status":"publish","type":"jobpost","link":"https:\/\/skillbasedmatching.com\/jobs\/current-jobs\/data-warehouse-analyst-contract-specialty-insurance-bi-etl\/","title":{"rendered":"Data Warehouse Analyst (Contract) \u2013 Specialty Insurance BI\/ETL"},"content":{"rendered":"\n<p>\u200bThis is a full-time <strong>Data Warehouse Analyst<\/strong> role at WorldTrips (a member of Tokio Marine HCC), specializing in specialty travel medical and trip protection insurance. This is a <strong>1099 contract role<\/strong> anticipated to last <strong>3-6 months<\/strong> and is <strong>fully remote (USA)<\/strong>. The analyst is responsible for the design, development, maintenance, and support of the enterprise data warehouse system, focusing heavily on ETL processes and Microsoft BI solutions.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Location:<\/strong> Remote, USA (1099 Contract).<\/li>\n\n\n\n<li>\u200b<strong>Duration:<\/strong> Anticipated <strong>3\u20136 months<\/strong>.<\/li>\n\n\n\n<li>\u200b<strong>Experience Required:<\/strong> Minimum of <strong>two years<\/strong> of relevant and progressive professional experience.<\/li>\n\n\n\n<li>\u200b<strong>Focus:<\/strong> Designing logical and physical data warehouse architecture, developing ETL packages, ensuring data accuracy\/consistency, and utilizing Microsoft BI technology for solutions.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u200bResponsibilities: Architecture, ETL, and BI Delivery<\/h2>\n\n\n\n<p>\u200bThe analyst ensures the integrity and functionality of the data warehouse, making data accessible and actionable for the business.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Architecture &amp; Design:<\/strong> Determine <strong>logical and physical architecture requirements<\/strong> necessary to integrate new or existing sources into an Enterprise Business Intelligence (data warehouse) system. Continuously improve how the system functions.<\/li>\n\n\n\n<li>\u200b<strong>Database Management:<\/strong> Review, evaluate, design, test, implement, and maintain company databases to support the organization&#8217;s data needs.<\/li>\n\n\n\n<li>\u200b<strong>ETL Development:<\/strong> <strong>Write code for database access, modifications, and construction<\/strong> including stored procedures and <strong>Extract\/Transfer\/Load (ETL) packages<\/strong> to integrate new or existing data sources.<\/li>\n\n\n\n<li>\u200b<strong>Change Data Capture (CDC):<\/strong> Integrate <strong>Change Data Capture software<\/strong> to monitor transaction data from source systems.<\/li>\n\n\n\n<li>\u200b<strong>BI Delivery:<\/strong> Deliver Business Intelligence Solutions using <strong>Microsoft technology<\/strong> such as <strong>SharePoint, Excel, Analysis Services, Reporting Services<\/strong>, and others.<\/li>\n\n\n\n<li>\u200b<strong>Standards &amp; Security:<\/strong> Create standards for installation, operational support, and information security to adhere to corporate IT standards.<\/li>\n\n\n\n<li>\u200b<strong>Consultation:<\/strong> Consult with clients and team members to obtain requirements needed for constructing business intelligence architectures.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u200bRequired Skills and Experience<\/h2>\n\n\n\n<p>\u200bThe position demands technical expertise in database and ETL development, paired with strong organizational and communication abilities.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u200b<strong>Technical Experience:<\/strong> Minimum of <strong>two years<\/strong> of relevant and progressive professional experience in a related field.<\/li>\n\n\n\n<li>\u200b<strong>ETL\/Database Tools:<\/strong> Must be proficient in writing code for ETL packages, stored procedures, and handling database modifications and access. Experience integrating Change Data Capture software is necessary.<\/li>\n\n\n\n<li>\u200b<strong>BI Tools:<\/strong> Experience delivering BI Solutions using the <strong>Microsoft stack<\/strong> (<strong>Analysis Services, Reporting Services, SharePoint, Excel<\/strong>).<\/li>\n\n\n\n<li>\u200b<strong>Soft Skills:<\/strong> Demonstrated ability of exceptional <strong>attention to detail<\/strong> to manage multiple tasks simultaneously. Excellent written and verbal communication skills.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u200bThis is a full-time Data Warehouse Analyst role at WorldTrips (a member of Tokio Marine HCC), specializing in specialty travel medical and trip protection insurance. This is a 1099 contract role anticipated to last 3-6 months and is fully remote (USA). The analyst is responsible for the design, development, maintenance, and support of the enterprise [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","jobpost_category":[46,734],"jobpost_job_type":[47,39],"jobpost_location":[1041],"jobpost_tag":[3713,3646,3715,3716,953,961,131,3714,81,3717],"class_list":["post-806","jobpost","type-jobpost","status-publish","hentry","jobpost_category-data","jobpost_category-support-service","jobpost_job_type-contract","jobpost_job_type-remote","jobpost_location-united-states","jobpost_tag-1099-contract","jobpost_tag-2-years-experience","jobpost_tag-analysis-services","jobpost_tag-change-data-capture-cdc","jobpost_tag-data-architecture","jobpost_tag-data-warehouse-analyst","jobpost_tag-etl","jobpost_tag-microsoft-bi-stack","jobpost_tag-remote","jobpost_tag-reporting-services"],"_links":{"self":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost\/806","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=806"}],"wp:term":[{"taxonomy":"jobpost_category","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_category?post=806"},{"taxonomy":"jobpost_job_type","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_job_type?post=806"},{"taxonomy":"jobpost_location","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_location?post=806"},{"taxonomy":"jobpost_tag","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_tag?post=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}