Data Architect Position Available In Leon, Florida

The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate’s/applicant’s qualifications, skills, and level of experience as well as the geographical location of the position. Applicants must be legally authorized to work in the United States. Sponsorship not available. Our client is seeking a Data Architect in Jacksonville, FL. Role Description Extracting data from the Guidewire Cloud Platform via the CDA path for KCC, PolicyCenter (PC), and BillingCenter (BC) into Snowflake. Proficiency in using EOR (Extract, Organize, and Replicate) to populate PC, BC, and KCC data into the DataHub. Experience working with General Ledger, Commission, and Financial Data Marts. Hands-on experience with Data Vault modeling techniques. Extract Data from GWCP to Rawzone through the CDA Path for KCC, PC, and BC Extract data from Guidewire Cloud Platform (GWCP) to the Rawzone using the Change Data Capture (CDA) path for key components such as KCC (Kemper Claims Center), PC (PolicyCenter), and BC (BillingCenter). Ensure the extraction process is efficient and reliable, minimizing downtime and data loss. Ensure Data is Sourced to New Schemas in Rawzone Design and implement new schemas in the Rawzone to accommodate the extracted data. Ensure that the data is accurately mapped to the new schemas, maintaining data integrity and consistency. Integrate New Rawzone Schemas into the Trusted Zone/Vault Layer Integrate the new Rawzone schemas into the trusted zone or vault layer. Ensure that the data flows seamlessly from the Rawzone to the trusted zone, maintaining data quality and security. Design and Implement Schema Mappings and Transformations Design schema mappings and transformations to convert raw data into a structured format suitable for analysis and reporting. Implement these mappings and transformations, ensuring they are optimized for performance and accuracy. Implement Minimal Changes to the Refined Zone Make minimal changes to the refined zone to accommodate the new data structures. Ensure that the refined zone remains consistent and accurate, reflecting the latest data updates. Ensure Data Consistency and Accuracy in the Refined Zone Monitor the refined zone to ensure data consistency and accuracy. Implement data validation and reconciliation processes to identify and resolve any discrepancies. Leverage EOR to Populate PC, BC, and KCC Data to Datahub Use the Extract-Only Region (EOR) to populate PolicyCenter (PC), BillingCenter (BC), and Kemper Claims Center (KCC) data to Datahub. Ensure that the data is accurately and efficiently transferred to Datahub. Monitor and Validate Data Integration Processes Continuously monitor data integration processes to ensure they are running smoothly. Validate the data integration to ensure that the data is accurate and complete. Implement Any Required Changes to Datahub ODS and Extraction Layers Identify and implement any necessary changes to the Datahub Operational Data Store (ODS) and extraction layers. Ensure that these changes are optimized for performance and do not disrupt existing processes. Ensure Data Extraction Processes are Optimized and Efficient Optimize data extraction processes to ensure they are efficient and scalable. Implement best practices for data extraction to minimize resource usage and maximize performance. Load KSG EDW Loss Leveraging Either Snowflake Rawzone GWCP New Schemas or GWCP Read Replica Load KSG Enterprise Data Warehouse (EDW) Loss data using either the Snowflake Rawzone GWCP new schemas or the GWCP read replica. Ensure that the data loading process is accurate and efficient. Validate and Reconcile Data Loading Processes Validate the data loading processes to ensure that the data is accurate and complete. Reconcile any discrepancies in the data to maintain data integrity. Implement Any Required Changes to EDW Identify and implement any necessary changes to the Enterprise Data Warehouse (EDW). Ensure that these changes are optimized for performance and do not disrupt existing processes. Ensure Data Integrity and Performance in the EDW Environment Monitor the EDW environment to ensure data integrity and performance. Implement best practices for data management and optimization to maintain a high-performing EDW environment Benefits/Other Compensation This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit). Why Hays? You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there’s a position you really want, you’re fully prepared to get it. Nervous about an upcoming interview? Unsure how to write a new resume? Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting. Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays’ guiding principles is ‘do the right thing’. We also believe that actions speak louder than words. In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us. In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text 813.336.5570. Drug testing may be required; please contact a recruiter for more information. #LI-DNI #1176315 – Olivia Dyroff