Truist Financial
IAM Lead Strategist - ETL Developer
Truist Financial, Atlanta, GA
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?
If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (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:
Works with key stakeholders, including senior leaders and executives, as well as LOBs to clearly define information security initiatives, vision and approach to meet security business needs, risks, exposures and remediation. Collaborate with key team stakeholders and senior management to drive initiatives to completion and rollout, enhance security standards, integrate solutions and maintain the strategic direction of Cybersecurity. Responsible for oversight and communication of the cybersecurity programs, which includes: providing strategic direction, financial oversight, and investment prioritization of new security controls/initiatives to address emerging threats; managing portfolio reporting and delivery of cybersecurity controls/capabilities to address risks in our environment.
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.
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.
Preferred Qualification:
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. 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 Pay Transparency Nondiscrimination Provision E-Verify
Need Help?
If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (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:
Works with key stakeholders, including senior leaders and executives, as well as LOBs to clearly define information security initiatives, vision and approach to meet security business needs, risks, exposures and remediation. Collaborate with key team stakeholders and senior management to drive initiatives to completion and rollout, enhance security standards, integrate solutions and maintain the strategic direction of Cybersecurity. Responsible for oversight and communication of the cybersecurity programs, which includes: providing strategic direction, financial oversight, and investment prioritization of new security controls/initiatives to address emerging threats; managing portfolio reporting and delivery of cybersecurity controls/capabilities to address risks in our environment.
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.
- Develop and maintain ETL processes
- Develop, implement, and maintain change control and testing processes for modifications to databases and ETL processes
- 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
- 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
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
- More than seven years of demonstrated progressive experience in Cybersecurity, with emphasis on data lost prevention, vulnerability management, access management, firewalls, security awareness training, etc.
- 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 on Microsoft BI Platform - SSIS, SSRS, MS SQL Server
- Database Development using MS SQL and/or Oracle SQL Developer
- Experience supporting a Data Warehouse environment.
- Experience in Data Migration from various systems to SQL Server Database
- Experience using MS T-SQL
- Experience using Oracle PL/SQL
- Experience using Microsoft SQL Server Data Tools for Visual Studio
- Experience using version control tools and CI/CD pipelines such as Azure DevOps or GitLab
- 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
- Experience in building Dashboards and KPI visualization on Power BI and/or Tableau
- Experience in building Data Marts using dimensional models
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. 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 Pay Transparency Nondiscrimination Provision E-Verify