Infrastructure Engineering Advisor- Hybrid

Cigna-Evernorth Services, Inc. seeks an Infrastructure Engineering Advisor for our Raleigh, NC location to design and provide engineering support and oversight on Business Intelligence (BI) design, engineering and development of information technology solutions. Responsibilities Responsible for complex, multisite, multi domain BI tool activities and integration. Manage the troubleshooting and resolution of BI infrastructure compatibility issues based on system architecture, project requirements, and customer expectations. Partner with IT resources on BI engineering related issues and strategies. Responsible for the architecture, engineering and support of the Enterprise BI application environments. Perform BI Application Suite Architecture and Management. Gather theater-wide customer requirements, design, and implement system architectures to ensure high availability and low application latency for various BI suite services. Configure and deploy the entire suite of BI applications to suit customer requirements. Work with a team of developers to integrate BI services into business process specific web applications. Manage content, create maps, overlays, and auditing reports as needed. Manage web infrastructure – IIS, DNS, Domain certificates, Identity Active Directory / LDAP. Automate routine tasks to manage the BI server environment and demonstrate improved efficiencies and cost savings. Work with devops to deploy new applications, services, scheduled jobs and support automation capabilities and requirements. Participate in risk assessments and project life cycle design activities to support more senior engineers. Participate in the planning and implementation of system upgrades and maintenance. Ensure service availability in accordance with customer-established requirements. Be escalation point for technical support and troubleshooting efforts. Hybrid work schedule Qualifications Bachelor’s degree in Computer Science, Electrical Engineering, or closely related field and 4 years of experience. Requires experience with: BI Architecture and BI Product Suites (BI Server/Web Portal/Data Store/Desktop Clients); Product installation with SAS deployment manager on user machines and assisting users in connecting to the SAS servers; Assisting with disaster recovery planning and execution and reviewing SAS logs to determine the errors and develop processes to increase the efficiency of SAS platforms; Authentication technologies including Windows Active Directory, LDAP, and Kerberos; Analysis including Behavioral model, Customer Profiling, Segmentation, Optimizing open-ended offers; Importing raw data files in excel format in SAS and subsequently creating SAS Datasets and performing data manipulations on the datasets on different Databases including Teradata, SQLSVR, Oracle, and DB2; Various Statistical Procedures including PROC FREQ, PROC REG, PROC and PROC GLM to analyze data and generate reports; R Package installations and automating Unix shell scripts to monitor the health of R services; OBIEE migration to OAS, which includes OAS product installation, Fusion middleware, web Logic with patches installations; Providing operational support on SAS technologies focusing in the areas of installation, configuration, security, data management, system integration, and user interface; Creating and removing the User IDs, user groups, and roles on the SAS Metadata and giving the library access; Writing SQL, PL/SQL, and stored procedures for implementing business rules for ad hoc data; Writing, testing, and implementing UNIX scripts for automating ETL process; and Using Tableau, SAP Business object, SSIS, Erwin, Data Integration hub, and COBOL. If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload. #J-18808-Ljbffr