Software Engineering II

Software Engineering II

ID (26000099)

Primary Location: UNITED STATES-NC-Charlotte

Organization: Equitable

Schedule: Full-time

Job Description:

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.