Software Engineering II
Role summary
Equitable Financial Life Insurance Company is seeking a Software Engineering II in Charlotte, NC. This full-time, hybrid role involves designing and implementing enterprise data warehousing solutions, including data modeling, database design, and performance tuning. The position requires a Master's degree and 4 years of experience with technologies such as Datastage, Oracle, SQL, Python, PySpark, and C++. Responsibilities include ensuring data security, optimizing system performance, and providing technical leadership. The role offers a salary of $156,166 – $185,000 per year.
Software Engineering II
(26000099)
Primary Location : UNITED STATES-NC-Charlotte
Organization : Equitable
Schedule : Full-time
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.
