Software Engineering II

Requires a Masters 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 Hadoop and TOAD; and data management and warehousing development for insurance/annuities industry.

40 hours/week. Salary is $156166 $185000/year. Direct applicants only. Hybrid work schedule: 2d-in office/3d-remote. Direct applicants only. Applicants send resume to (Ref. job code PV1693) or search job title through EOE M/F/D/V.

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.