Infrastructure Engineering Advisor- Hybrid

Cigna Group•Raleigh, NC

10d•Hybrid

About The Position

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. This role involves complex, multisite, multi-domain BI tool activities and integration, managing troubleshooting and resolution of BI infrastructure compatibility issues, and partnering with IT resources on BI engineering related issues and strategies. The position is responsible for the architecture, engineering, and support of Enterprise BI application environments, including performing BI Application Suite Architecture and Management. The advisor will gather customer requirements, design and implement system architectures for high availability and low application latency, and configure and deploy BI applications. Collaboration with developers for integrating BI services into web applications, managing content, and creating reports are key aspects. The role also includes managing web infrastructure (IIS, DNS, Https, Domain certificates, Identity Active Directory / LDAP), automating routine tasks for BI server environment management, and working with devops for application deployment and automation support. Participation in risk assessments, project life cycle design, system upgrades, maintenance, and ensuring service availability are also expected. The advisor will serve as an escalation point for technical support and troubleshooting efforts. This is a hybrid work schedule position.

Requirements

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;
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.

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, Https, 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.