Software Engineering II

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

Do you have experience in Tableau?, Do you have a Master's degree?, 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.

3.33.3 out of 5 stars Charlotte, NC Hybrid work $156,166 - $185,000 a year - Full-time