Infrastructure Engineering Advisor- Hybrid

Cigna Healthcare•Raleigh, NC

22h•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 advisor will be responsible for the architecture, engineering, and support of Enterprise BI application environments, gathering customer requirements, designing and implementing system architectures for high availability and low application latency, and configuring/deploying the BI applications suite. The role also includes integrating BI services into web applications, managing web infrastructure (IIS, DNS, Https, Domain certificates, Active Directory/LDAP), automating routine tasks, deploying new applications and services with DevOps, participating in risk assessments and system upgrades, ensuring service availability, and serving as an escalation point for technical support. A hybrid work schedule is in place.

Requirements

Bachelor’s degree in Computer Science, Electrical Engineering, or closely related field and 4 years of experience.
Experience with BI Architecture and BI Product Suites (BI Server/Web Portal/Data Store/Desktop Clients).
Experience with Product installation with SAS deployment manager on user machines and assisting users in connecting to the SAS servers.
Experience 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.
Experience with Authentication technologies including Windows Active Directory, LDAP, and Kerberos.
Experience with Analysis including Behavioral model, Customer Profiling, Segmentation, Optimizing open-ended offers.
Experience 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.
Experience with Various Statistical Procedures including PROC FREQ, PROC REG, PROC and PROC GLM to analyze data and generate reports.
Experience with R Package installations and automating Unix shell scripts to monitor the health of R services.
Experience with OBIEE migration to OAS, which includes OAS product installation, Fusion middleware, web Logic with patches installations.
Experience providing operational support on SAS technologies focusing in the areas of installation, configuration, security, data management, system integration, and user interface.
Experience creating and removing the User IDs, user groups, and roles on the SAS Metadata and giving the library access.
Experience writing SQL, PL/SQL, and stored procedures for implementing business rules for ad hoc data.
Experience writing, testing, and implementing UNIX scripts for automating ETL process.
Experience using Tableau, SAP Business object, SSIS, Erwin, Data Integration hub, and COBOL.
Internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload if working at home occasionally or permanently.

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.