{"domain": "americanfidelity.com", "user": "Import americanfidelity.com", "isWillingToRelocate": false, "isUserAuthenticated": false, "isUserETXCandidate": false, "isDomainETX": false, "isCareerPlannerEnabled": false, "isMyApplicationsEnabled": false, "showVeteranEmployerSignUp": false, "candidate": {"enc_id": 0, "fullname": "", "firstname": "", "lastname": "", "skills": [], "email": "", "phone": "", "location": "", "filename": null, "starred_positions": [], "resumeUrl": "", "onboardingCompleted": false, "isUserInPcsIjp": false, "linkedinUrl": ""}, "branding": {"enableTalentNetwork": 1, "homePageHeroBanner": {"opacity": 1, "image": "https://static.vscdn.net/images/careers/demo/americanfidelity/1705691499::Tall+Banner.png", "title": "Join Our Team", "hideInMobileView": false}, "navBar": {"color": "#ffffff", "image": "https://static.vscdn.net/images/careers/demo/americanfidelity/1692893664::AF_PCS_Logo\n", "link": "https://americanfidelity.eightfold.ai/careers", "background": "#ffffff", "opacity": 1, "title": "American Fidelity"}, "privacyLink": "https://americanfidelity.com/footer/internet-privacy-notice/", "uploadResumeModal": {"title": "Welcome to {company_name}'s Career Center", "subtitle": "Streamline your search by uploading your resume to be matched with positions that best suit your qualifications.", "disclaimer": "**Uploading a resume is not a formal application for employment**"}, "perks": [{"image": "https://static.vscdn.net/images/careers/demo/americanfidelity/1692894433::AF_About_Us_Perk.jpeg", "description": "American Fidelity specializes in serving the education, public sector, automotive and healthcare industries with financial security products and services including group and individual life, health and annuity services. <u><a href=\"https://americanfidelity.com/about-us/\" target=\"_blank\">Get to know American Fidelity!</a></u> ", "title": "About Us"}, {"image": "https://static.vscdn.net/images/careers/demo/americanfidelity/1692894421::AF_Benefits_Perk.jpeg", "description": "At American Fidelity, as part of our dedication to being a Great Place to Work for All, we provide a range of benefits and perks that help Colleagues regardless of where they are  in life. <u><a href=\"https://americanfidelity.com/careers/corporate-careers/benefits/\" target=\"_blank\">Explore the benefits we offer.</a></u> ", "title": "Benefits"}, {"image": "https://static.vscdn.net/images/careers/demo/americanfidelity/1692894401::AF_Home+Office_Perk.png", "description": "We know that life doesn\u2019t stop between the hours of 8-5, which is why our Home Office in Oklahoma City offers an onsite medical clinic, Waterfront grill, fitness center, walking trails and outdoor rec areas for Colleagues. <u><a href=\"https://americanfidelity.com/careers/corporate-careers/headquarters/\" target=\"_blank\">Learn more about our HQ!</a></u> ", "title": "Home Office"}, {"image": "https://static.vscdn.net/images/careers/demo/americanfidelity/1692894410::AF_Culture_Perk.jpeg", "description": "We strive to be a place where Colleagues enjoy coming to work because they know they are a valued and essential part of what we do. Whether you\u2019re in the office or remote, you\u2019ll enjoy a collaborative, inviting environment. <u><a href=\"https://americanfidelity.com/careers/corporate-careers/culture-and-life/\" target=\"_blank\">Picture yourself at AF!</a></u> ", "title": "Culture and Life"}], "custom_style": {"css": ".refer .user-name { color: #fff !important; } \n\n.fixed-top { background-color: #000 !important; } \n\n.position-job-description .block__field--wide-rich-text { width: inherit !important; } \n\n.navbar img {height: 60px !important;}  .navbar {position: relative !important;}\n\n.join-tn-link, .custom-navbar-item {color: #000000 !important; top: 15px !important;} \n\n.candidate-login-link {color: #000000 !important; top: 15px !important;} \n\nnav.navbar {position: relative !important; background-color: #ffffff !important;} \n\n.go-button {color: #EB0029 !important; background-color: #ffffff !important; border-color: #EB0029 !important;}\n\n .job-cart-button {color: #EB0029 !important; background-color: #ffffff !important; border-color: #EB0029 !important;} \n\n.advanced-options-button {color: #EB0029 !important;} \n\n.btn-secondary {color: #EB0029 !important; background-color: #ffffff !important; border-color: #EB0029 !important;}\n\n .add-to-job-cart-button {color: #EB0029 !important; background-color: #ffffff !important; border-color: #EB0029 !important} \n\n.jumbotron h1 {font-weight: 600 !important;} .pointer.btn.btn-secondary.job-cart-button:hover {color: #AA0A1E !important; border-color: #AA0A1E !important;} \n\nbutton.go-button:hover {color: #AA0A1E !important; border-color: #AA0A1E !important;}  \n\nbutton.btn.btn.btn-primary.get-matched-button {border-color: #EB0029 !important; background-color: #EB0029 !important;}\n\nbutton.btn.btn.btn-primary.get-matched-button:hover {background-color: #AA0A1E !important; border-color: #AA0A1E !important;}\n\nbutton.btn.position-apply-button:hover {background-color: #AA0A1E !important;} \n\nbutton.btn.position-apply-button.add-to-job-cart-button:hover {color: #AA0A1E !important; background-color: white !important; border-color: #AA0A1E !important;}\n\nbutton.btn.btn-sm.btn-secondary.show-more-positions:hover {color: #AA0A1E !important; border-color: #AA0A1E !important;} \n\nbutton.btn.btn-secondary.upload-resume-button:hover {color: #AA0A1E !important; border-color: #AA0A1E !important;} \n\n.search-results-main-container .position-cards-container .card-selected {background: #fff !important; border: 1px solid #e5e6e7 !important; border-left: 8px solid #AA0A1E !important;}\n\n.perk .perk-icon {color: #AA0A1E !important;}\n\n.fa-share {color: #AA0A1E !important;}\n\n.upload-resume-modal .privacy-agreement .action-buttons .btn-primary {color: #ffffff !important; border-color: #EB0029 !important; background-color: #EB0029 !important;}\n\n.upload-resume-modal .privacy-agreement .action-buttons .btn-primary:hover {color: #ffffff !important; border-color: #AA0A1E !important; background-color: #AA0A1E !important;}\n\nbutton.btn-sm.btn-secondary.pointer:hover {color: #AA0A1E !important; border-color: #AA0A1E !important; }\n\n.upload-resume-modal .dropzone-container .browse-button {color: #ffffff !important; border-color: #EB0029 !important; background-color: #EB0029 !important;}\n\nbutton#careers-jtn-submit {background-color: #EB0029 !important; border-color: #EB0029 !important;}\n\nbutton#careers-jtn-submit:hover {background-color: #AA0A1E !important; border-color: AA0A1E !important;}\n\nbutton.btn-sm.btn-primary.pointer.position-apply-button {color: #ffffff !important; background-color: #EB0029 !important; border-color: #EB0029 !important;}\n\nbutton.btn-sm.pointer.position-apply-cancel-button {color: #EB0029 !important; border-color: #EB0029 !important;}\n\n#eightfold-chatbot .open-chat-bot .open-chat-bot-header {background-color: #157885 !important;}\n\n#eightfold-chatbot .botui-actions-buttons-button {background-color: #157885 !important;}\n\nbutton.botui-actions-buttons-button.something-else {color: #ffffff !important;}\n\n#eightfold-chatbot .botui-actions-buttons-button:nth-last-child(1) {color: #ffffff !important;}\n\nbutton.btn.btn.btn-primary {background-color: #EB0029 !important; border-color: #EB0029 !important;}\n\n.success-form .browse-more .btn {border-color: #EB0029 !important; color: #eb0029 !important;}\n\n.success-form .checkmark .fa-check {color: #157885 !important;}\n\ndiv.perk {width: 20% !important; padding: 30px !important;}\n\n.human.botui-message-content.text {color: #ffffff !important; background-color: #4f5666 !important;}\n\n.botui-message-content.text {background-color: #ebebeb !important;}\n\n.perk .perk-description a {color: #157885 !important;}\n\nbutton.btn.btn.btn-primary.job-cart-button {color: #ffffff !important;}\n\n"}, "page_image": "", "max_applications_refer": 0, "applyButton": {"background": "#EB0029"}, "links": {"videos": ["https://www.youtube.com/watch?v=8PknUqSM8KE", "https://www.youtube.com/watch?v=E0EV0KxWCBg", "https://www.youtube.com/watch?v=cuZHa9FD270", "https://www.youtube.com/watch?v=Ks4lE5Qge3c", "https://www.youtube.com/watch?v=8fukq5buFbQ"]}, "talent_form_mandatory_fields": ["resume", "firstname", "lastname"], "privacy": {"text": "Please click <a href=\"https://americanfidelity.com/footer/privacy-notices/\" target=_blank\">here</a> to review our Data Privacy Policies.", "title": "Data Privacy Policy", "button": "Continue"}, "defaultState": {"pymww": false}, "advancedSearchOptions": [{"key": "skills", "name": "Your relevant skills"}, {"key": "department", "name": "Departments"}, {"key": "seniority", "name": "Seniority Level"}], "redesignedNuxConfig": {"enabled": false}, "favicons": {"favicon": "https://static.vscdn.net/images/careers/demo/americanfidelity-sandbox/1681932974::AF+logo+sample"}, "recaptcha_enabled": 1, "companyName": "American Fidelity", "showLoggedOutNotificationsPrivacyPolicy": true}, "pid": "790298424412", "positions": [{"id": 790298424412, "name": "Senior Data Engineer", "location": null, "locations": [], "hot": 0, "department": "Digital Engineering", "business_unit": "Unknown", "t_update": 1725610355, "t_create": 1723569493, "ats_job_id": 790298424412, "display_job_id": 790298424412, "type": "ATS", "id_locale": "790298424412-en", "job_description": "Design, develop, document, test, and assist in implementation of secure medium to complex database solutions and ETL processes. Collaborate with other IT colleagues and business users to define developmental requirements. Advanced skills in SQL development and comfortable designing, writing, and maintaining complex SQL based ETL, which includes building large-scale batch and real-time data pipelines Well-versed in designing data models and data management strategies to support analytical and modeling applications as well as Analytical and Data Science teams. Strong background in data warehouse concepts and designs; ETL, Star Schema, Multi-Dimensional databases Cloud computing, ideally Azure or (but not limited to); AWS, Redshift, Lambda, Cassandra Familiar with at least one scripting language (PowerShell, JavaScript, Python, Ruby, Perl, Bash) Strong data management and processing skills, including experience with Relational and Non-relational data stores (NoSQL, S3, Hadoop, etc.) Ability to adjust designs to meet project objective and timelines while maintaining the vision and goals of solid database design principles. Expert in eliciting solid data element descriptions and definitions and with physical data modeling tools and proficient in at least one (e.g., Erwin) Experience with SOA, Service Bus technologies, and other data abstraction tools and access layers. Strong communication skills both in written (technical documents, Jupyter notebooks) and spoken (meetings, presentations) forms Efficiently work and produce results within the structure of project management methodologies (e.g., Agile, Scrum, Waterfall) Demonstrate commitment to meeting organizational, department and team goals and objectives Familiar with the DevOps, data pipeline and sharing code repositories with tools such as GIT", "stars": 0.0, "medallionProgram": null, "location_flexibility": null, "work_location_option": "onsite", "canonicalPositionUrl": "https://jobs.americanfidelity.com/careers/job/790298424412", "isPrivate": false}], "isFallback": false, "debug": {}, "count": 1, "personal_message": "We thought you would be interested in this position.", "scheduling": {"minTime": 9, "limit": 10, "maxTime": 17, "increments": 60, "minTimeslots": 3}, "userTitles": [], "enableTargetedResume": 0, "query": {"query": "", "location": "", "department": [], "skill": [], "seniority": [], "pid": "790298424412"}, "singleview": true, "see_all_jobs": true, "recommended_star_threshold": 4.0, "chatbot": true, "iframeImplementation": null, "pcsApplyFormV2Enabled": false, "isPcsBrandingApril2023Enabled": false, "allowedFileTypes": {}, "pcsTextConfiguration": {}, "hideDepartment": null, "pcsOctupleMigration0Enabled": true, "pcsOctupleMigration1Enabled": false, "replaceUrlOnGoBack": true, "pcsRedesignedNuxEnabled": false, "readmoreInstructionEnabled": false, "userActivityTimeout": 86400000, "userActivityTimeoutEnabled": 1, "isLoggedInPcsEnabled": true, "sortByConfig": null, "searchBoxConfig": {}, "excludePrivatePositions": true, "eeocFilterKeywords": ["veteran", "disability", "gender", "race", "citizen", "visa", "ethnicity"], "disableScrollLoadPositionSidebar": false, "locationFlexibilityFrontendEnabled": false, "workLocationOptionFrontendEnabled": true, "remoteFlexibleJobsFilterEnabled": false, "loggedOutNotificationsEnabled": true, "candidateLogin": {"postApplyReviewLink": {"enabled": true, "url": "/api/apply/v2/profile/review/initialize_user?domain=americanfidelity.com", "title": "What's next? Increase your chances of getting hired!", "message": "Knowing more about you helps us review your application faster. Enrich your profile by adding more skills, awards, and other recognition.", "buttonText": "Review my profile", "verifyEmailTitle": "Let's verify your email", "verifyEmailText": "Click the link in the email to continue reviewing your profile. If you do not immediately see the email, check your spam folder."}, "postLoginLink": {"enabled": true, "message": "Candidate Login", "url": "/careerhub/me?action=edit&trackApplicationStatus=false&profile_type=candidate&domain=americanfidelity.com&customredirect=1&utm_source=Eightfold"}, "trackApplicationLink": {"enabled": true, "message": "Track Application Status", "url": "/careerhub/my/jobs/applications?trackApplicationStatus=true&profile_type=candidate&domain=americanfidelity.com&customredirect=1&utm_source=Eightfold"}}, "prepopulateApplyFormEnabled": true, "prepopulateSettings": {"prepopulateCheckboxText": "Save my answers for future applications", "showPrepopulateCheckbox": false}, "candidateBuildProfile": {"enabled": true, "message": "Build your resume", "url": "/careerhub/me?action=edit&profile_type=candidate&domain=americanfidelity.com&customredirect=1"}, "enhancementsEnabled": false, "themeBuilderUser": null, "mandatoryFields": ["firstname", "lastname", "email", "phone"], "blindfoldWidgetPcsGate": false, "pcsApplyFormLocationGate": false, "t3sEnabled": false, "uploadApplicationAnswers": false, "candidateAuthV2Enabled": false, "preApplicationSubmitAuthEnabled": false, "applyFormV2Enabled": false, "loggedOutSavedSearchEnabled": false, "locationRadiusTypeToggleEnabled": true, "incompleteApplicationsEnabled": false, "incompleteApplicationConfig": {}, "fallbackPcsJdGate": true, "enableResumeCoach": false, "isPcsEnabled": true, "applicationInfoReviewEnabled": false, "phoneWithCountryCodeEnabled": true, "phoneWithCountryCodeJTNEnabled": false, "notificationSuggestVerificationToken": null, "cookiesAutoDisabled": false, "strictEmailValidationEnabled": true, "chatbotxConfig": {"enabled": false, "featureAccessFlags": {"resumeCoachCardFlags": {"showApplyWithResume": true, "showEditResume": true}, "positionCardFlags": {"showAddToJobCart": true}}}, "pcsOptionalResumeWithJobcartGate": false, "loggedInCandidate": {}, "hamburgerMenuEnabled": false, "sharedTalentPoolGate": false, "pcsAccessibilityHomeEnabled": true, "pcsAccessibilityApplyFormEnabled": true, "showLanguageDropdown": false, "languages": [{"value": "en", "title": "English"}, {"value": "it", "title": "Italiano"}, {"value": "es", "title": "Espa\u00f1ol"}, {"value": "fr", "title": "Fran\u00e7ais"}, {"value": "pt", "title": "Portugu\u00eas"}, {"value": "nb", "title": "Norsk"}, {"value": "de", "title": "Deutsch"}, {"value": "ja", "title": "\u65e5\u672c\u8a9e"}, {"value": "ms", "title": "Bahasa melayu"}, {"value": "zh-CN", "title": "\u4e2d\u6587 (\u7b80\u4f53)"}, {"value": "zh-TW", "title": "\u4e2d\u6587 (\u7e41\u9ad4)"}, {"value": "ko", "title": "\ud55c\uad6d\uc5b4"}, {"value": "th", "title": "\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22"}, {"value": "nl", "title": "Nederlands"}, {"value": "pl", "title": "Polski"}, {"value": "uk", "title": "Y\u043a\u0440\u0430\u0457\u043d\u0441\u044c\u043a\u0430"}, {"value": "hr", "title": "Hrvatski"}, {"value": "el", "title": "\u0395\u03bb\u03bb\u03b7\u03bd\u03b9\u03ba\u03ac"}, {"value": "hu", "title": "Magyar"}, {"value": "cs", "title": "\u010de\u0161tina"}, {"value": "tr", "title": "T\u00fcrk\u00e7e"}, {"value": "ru", "title": "P\u0443\u0441\u0441\u043a\u0438\u0439"}, {"value": "ht", "title": "Haitian"}, {"value": "he", "title": "\u05e2\u05d1\u05e8\u05d9\u05ea"}, {"value": "pt-BR", "title": "Brazilian Portugu\u00eas"}, {"value": "da", "title": "Dansk"}, {"value": "fi", "title": "Suomi"}, {"value": "sv", "title": "Svenska"}, {"value": "fr-CA", "title": "Fran\u00e7ais (Canada)"}, {"value": "pt-PT", "title": "portugu\u00eas (Portugal)"}, {"value": "vi", "title": "Ti\u1ebfng Vi\u1ec7t"}, {"value": "ro", "title": "rom\u00e2n\u0103"}, {"value": "bg", "title": "\u0431\u044a\u043b\u0433\u0430\u0440\u0441\u043a\u0438"}, {"value": "ar", "title": "\u0627\u0644\u0639\u0631\u0628\u064a\u0629"}], "displayLanguage": "en", "installed_app_data": [], "singlePageCareersNavbarGate": false, "customJobDescTranslationSkipList": []}