Software Engineering II

Equitable Financial Life Insurance Company seeks a Software Engineering II for its Charlotte, NC location.



Duties:

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

Requires a Master's degree in Information Management, Computer Science or related technical field and 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 must include: 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, and TOAD; and data management and warehousing development for insurance/annuities industry.



40 hours/week. Salary is $156,166 - $185,000/year . Direct applicants only. Hybrid work schedule: 2d-in office/3d-remote. Direct applicants only. Applicants send resume to TalentAquisition@equitable.com (Ref. job code PV1693) or search job title through https://equitable.com/about-us/careers. EOE M/F/D/V.