Infrastructure Engineering Advisor- Hybrid

The Cigna Group • Raleigh, NC

1d • 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 the Enterprise BI application environments, performing BI Application Suite Architecture and Management. They will gather customer requirements, design and implement system architectures for high availability and low application latency, and configure and deploy the entire suite of BI applications. Collaboration with developers to integrate BI services into web applications, managing content, creating maps, overlays, and auditing reports, and managing web infrastructure (IIS, DNS, Https, Domain certificates, Identity Active Directory / LDAP) are key aspects of the role. Additionally, the position requires automating routine tasks for BI server environment management to demonstrate efficiencies and cost savings, working with devops for new application deployments and automation support, participating in risk assessments and project life cycle design activities, and participating in system upgrade and maintenance planning. Ensuring service availability and acting as an escalation point for technical support are also crucial responsibilities. The role offers a hybrid work schedule.

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.

Nice To Haves

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

Benefits

• Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.
• If you need a reasonable accommodation to complete the online application process, please email [email protected] for assistance. Please note that this email inbox is dedicated to accommodation requests only and cannot provide application updates or accept resumes.
• The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.
• Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior