IAM Lead Strategist - SQL Developer

Truist Financial - Raleigh, NC

Part-time,Full-time - Mid Level

Raleigh, NC

Credit Intermediation and Related Activities

About the position

The IAM Lead Strategist - SQL Developer is responsible for developing and maintaining solutions using various technologies including ASP.NET, C#, HTML, JavaScript, and SSIS. This role requires strong communication skills and the ability to work collaboratively with business units to gather requirements and propose technology solutions. The strategist will lead initiatives to enhance information security, manage SQL databases, and ensure data security while driving business value and supporting the organization's competitive advantage.

Responsibilities

• Develop and maintain SQL Databases.
• Develop and maintain database stored procedures, views, and functions that support integration of applications.
• Create and maintain technical documentation.
• Assure security of data from external parties and manage row-level security within the organization.
• Design and deploy data table structures, reports, and queries.
• Write and edit scripts based on team direction and feedback.
• Perform root cause analysis to prevent recurrence of problems and manage the resolution of complex issues.
• Lead collaboration efforts with internal and external IT service providers and business units in evaluating and gathering technical requirements for business clients' information security initiatives.
• Lead cross-functional teams and shape client expectations by driving initiatives and matching outcomes to expectations.
• Provide leadership and direction to ensure program elements reflect CIS requirements.
• Act as a thought leader and trusted partner enabling business units to leverage capabilities to drive business value.
• Drive initiatives that improve communication and documentation of potential solutions, impact analysis, benefits/risks, implementation requirements, and recommended approach.

Requirements

• Bachelor's degree in business administration, technology related field or equivalent education and related training.
• Excellent ability to express complex multi-disciplinary technical and business concepts in understandable terms for all levels of management.
• Strong working knowledge of cybersecurity terms, concepts, disciplines, frameworks, best practices, and industry/regulatory requirements.

Nice-to-haves

• Two/four degree in IS related curriculum or equivalent education and related training.
• Software development experience using Microsoft tools such as SSIS, SSRS, MS SQL Server.
• Substantial familiarity with .NET framework, web services, APIs, and Microsoft Visual Studio.
• Expertise in SQL Server, T-SQL, and database design including model-view-controller (MVC).
• Experience creating web APIs and web pages within the ASP.NET framework.
• Working knowledge of JavaScript & HTML.
• Able to write bash scripts.
• Experience in Data Migration from various systems to SQL Server Database.
• Experience using Oracle PL/SQL.
• Experience using Microsoft SQL Server Data Tools for Visual Studio.
• Familiarity with Active Directory.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Disability insurance
• Accidental death and dismemberment insurance
• Tax-preferred savings accounts
• 401k plan
• Vacation days (minimum of 10 days)
• Sick days (minimum of 10 days)
• Paid holidays
• Defined benefit pension plan (depending on position)
• Restricted stock units (depending on position)
• Deferred compensation plan (depending on position)