Software Engineering II

Equitable•Charlotte, NC

5d•Hybrid

About The Position

Equitable Financial Life Insurance Company seeks a Software Engineering II for its Charlotte, NC location. This role is responsible for designing strategies for enterprise databases, data warehouse systems, and multidimensional networks. The position involves 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 critical applications, and provide technical, functional, and systems design for 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 senior member for production support of complex systems, acting as a subject matter expert for Datawarehouse Processes and infrastructure, maintaining current Datawarehouse applications, and developing procedures to improve the environment while complying with security and audit standards. The position also requires designing, developing, testing, and deploying Datastage code for loading data into the Datawarehouse IIAS appliance and providing technical expertise for 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.
Experience with Datastage 11.7
Experience with IBM IIAS Appliance
Experience with Oracle Database
Experience with SQL
Experience with Data Security/Privacy and Data Quality
Experience with Performance Tuning
Experience with Shell Scripting and Cron Jobs
Experience with Linux
Experience with Hadoop
Experience with PySpark
Experience with C#
Experience with C++
Experience with Web Services
Experience with Grafana
Experience with Tableau
Experience with Power BI
Experience with R
Experience with Python
Experience with .NET Hadoop
Experience with TOAD
Experience with 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.