Software Engineering II

EQH•Charlotte, NC

5d•Hybrid

About The Position

Equitable Financial Life Insurance Company seeks a Software Engineering II for its Charlotte, NC location. This role involves designing strategies for enterprise databases, data warehouse systems, and multidimensional networks. The position is responsible for data gathering and analysis, systems design and implementation, logical and detailed design, ensuring data security, and system evaluation, integration, vetting, modification, troubleshooting, and optimization. The Software Engineering II will liaise with business unit customers, vendors, and IT Senior Executives, prepare design specifications for large or critical applications, and provide technical, functional, and systems design for all work related to system development projects. This role also involves setting standards for database operations, programming, query processes, and security, as well as modeling, designing, and constructing large relational databases or data warehouses. The individual will create and optimize data models, integrate new systems with existing warehouse structures, refine system performance, and lead the process of compiling, analyzing, designing, testing, and prioritizing system design components. Additionally, the role includes assisting with technical testing, providing leadership and guidance to team members, serving as a subject matter expert for Datawarehouse Processes and infrastructure, and maintaining current Datawarehouse applications while developing procedures to improve the environment. The position requires designing, developing, testing, and deploying Datastage code to load data into the Datawarehouse IIAS appliance and providing technical expertise for the implementation of Datawarehouse solutions.

Requirements

Master’s degree in Information Management, Computer Science or related technical field
4 years of progressive post-Baccalaureate experience as Software Engineer or related occupation involving data management and warehousing development, data modeling and Big Data analytics
Datastage 11.7
IBM IIAS Appliance
Oracle Database
SQL
Data Security/Privacy and Data Quality
Performance Tuning
Shell Scripting and Cron Jobs
Linux
Hadoop
PySpark
C#
C++
Web Services
Grafana
Tableau
Power BI
R
Python
.NET Hadoop
TOAD
data management and warehousing development for insurance/annuities industry

Responsibilities

Design strategies for enterprise databases, data warehouse systems, and multidimensional networks.
Responsible for data gathering and analysis; systems design and implementation; logical design; detailed design; ensuring data security in the design; and system evaluation, integration, vetting, modification, troubleshooting, and optimization.
Liaise with business unit customers and vendors depending on assignment and IT Senior Executives.
Prepare design specifications of one or more large or critical applications or systems.
Provide technical, functional and systems design for all work related to a system development project.
Set standards for database operations, programming, query processes, and security.
Model, design, and construct large relational databases or data warehouses.
Create and optimize data models for warehouse infrastructure and workflow.
Integrate new systems with existing warehouse structure and refine system performance and functionality.
Lead the process of compiling, analyzing, designing, testing and prioritizing system design components and implementation.
Assist with technical testing, ensuring that the system and unit tests were performed and reviews the test results.
Provide leadership/guidance to team members.
Work as a senior member of a team providing production support for new/existing systems of high complexity and scope.
Serve as subject matter expert (SME) for Datawarehouse Processes and infrastructure.
Maintain current Datawarehouse applications and develops procedures, where necessary, to improve the environment as required. Complies with all security and audit standards.
Design, Develop, test and deploy Datastage code based on requirements to load data into Datawarehouse IIAS appliance.
Provide technical expertise to the development and implementation of Datawarehouse solutions.