{"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, "hideEightfoldBranding": false}, "pid": "790298839653", "positions": [{"id": 790298839653, "name": "Data Engineer", "location": null, "locations": [], "hot": 0, "department": "Digital Engineering", "business_unit": "Unknown", "t_update": 1728311334, "t_create": 1725392470, "ats_job_id": 790298839653, "display_job_id": 790298839653, "type": "ATS", "id_locale": "790298839653-en", "job_description": "Develop simple to complex database solutions for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) environments. Knowledge about how the development process for ETL and SQL processes work. Will work under guidance of more experienced team members in the development of (OLTP and OLAP) that are efficient and meet the expectations of the enterprise. * Efficient working independently or as part of a team to deliver solutions and easily adjust to new environments and tool sets. * Good at communicating ideas, specifications and status updates to both technical and non-technical professionals. * Knowledgeable of enterprise-class relational database systems (SQL Server/ Oracle) or multi-dimensional databases (Essbase). * Excellent organizational skills, attention to detail and highly motivated. * Skilled in the development of queries, stored procedures, creation of tables, views and function through SQL scripts. * 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 * Working knowledge of enterprise-class security tools, processes and principles * Knowledge of software development practices", "stars": 0.0, "medallionProgram": null, "location_flexibility": null, "work_location_option": "onsite", "canonicalPositionUrl": "https://jobs.americanfidelity.com/careers/job/790298839653", "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": "790298839653"}, "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": true, "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": []}