Job Information
Truist IAM Lead Strategist – SQL Developer in Atlanta, Georgia
The position is described below. If you want to apply, click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application, you'll be invited to create a profile, which will let you see your application status and any communications. If you already have a profile with us, you can log in to check status.
Need Help? (https://www.brainshark.com/bbandt/careers-site-faq)
If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (careers@truist.com?subject=Accommodation%20request)
(accommodation requests only; other inquiries won't receive a response).
Regular or Temporary:
Regular
Language Fluency: English (Required)
Work Shift:
1st shift (United States of America)
Please review the following job description:
The IAM Lead Strategist-, develops & maintains solution using technologies as ASP.net, C#, HTML, JavaScript and SSIS. Demonstrates strong communications skills, aptitude for working with the business, and propensity to learn new technology. Participates in requirements gathering and research, proposes technology solutions, and develops solutions within agreed upon timelines.
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 for management of 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.
Performs root cause analysis to prevent recurrence of problem and manages the resolution of complex problems.
Ability to work effectively in virtual environments where key team members and partners are in various locations
Essential Duties and Responsibilities: Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
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 including risk assessments, application development, project management, and ongoing operations reflect CIS requirements.
Act as a thought leader and trusted partner enabling business units to more aggressively leverage its capabilities to drive business value and strengthen its role in upholding Truist's competitive advantage.
Drive initiatives that improve communication and documentation of potential solutions, impact analysis, benefits/risks, implementation requirements, and recommended approach.
Advise and consult on options, improvements, cost savings opportunities and cross-project impact to other business processes and systems priorities.
Remain aware of the corporate technology, infrastructure, standards, processes, and strategic direction and use these tools to help guide the client in accomplishing their business goals.
Required Qualifications :
The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
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 terms that are understandable to all levels of Lines of Business and corporate management both verbally and in writing.
Strong working knowledge of cybersecurity terms, concepts, disciplines, frameworks, best practices, and industry/regulatory requirements
Preferred Qualification:
Two/four degree in IS related curriculum or equivalent education and related training.
Software development experience using Microsoft tool 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.
Designs, builds, and maintains C# code for software and applications that run on Windows systems.
Working knowledge of JavaScript & HTML.
Able to write bash scripts.
Database Development using MS SQL.
Experience in Data Migration from various systems to SQL Server Database
Optimizing database performance and ensuring data integrity.
Troubleshooting and resolving database-related issues.
Experience using Oracle PL/SQL.
Experience using Microsoft SQL Server Data Tools for Visual Studio
Experience with different project development life cycle methodologies such as Waterfall Model, agile/scrum to iterate quickly on product changes, developing user stories, and working through backlogs.
Writing complex SQL queries for data retrieval and manipulation.
Familiarity with Active Directory is a plus.
General Description of Available Benefits for Eligible Employees of Truist Financial Corporation: All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position. Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays. For more details on Truist’s generous benefit plans, please visit our Benefits site (https://benefits.truist.com/)
. Depending on the position and division, this job may also be eligible for Truist’s defined benefit pension plan, restricted stock units, and/or a deferred compensation plan. As you advance through the hiring process, you will also learn more about the specific benefits available for any non-temporary position for which you apply, based on full-time or part-time status, position, and division of work.
Truist supports a diverse workforce and is an Equal Opportunity Employer that does not discriminate against individuals on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. Truist is a Drug Free Workplace.
EEO is the Law (https://www.eeoc.gov/sites/default/files/2022-10/EEOC_KnowYourRights_screen_reader_10_20.pdf)
Pay Transparency Nondiscrimination Provision (https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf)
E-Verify (https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf)