Software Engineering II
Location: Charlotte, North Carolina US
Job Number: 10051
Job Number: 26000099
External Description:
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.
Community / Marketing Title: Software Engineering II
Location_formattedLocationLong: Charlotte, North Carolina US