Truist Financial - Raleigh, NC

posted 2 months ago

Part-time,Full-time - Mid Level
Raleigh, NC
Credit Intermediation and Related Activities

About the position

The IAM Lead Strategist - ETL Developer position is a critical role within the cybersecurity domain, focusing on the development and maintenance of ETL processes while ensuring the security and integrity of data. This position requires collaboration with key stakeholders, including senior leaders and executives, to define and implement information security initiatives that align with business needs and address potential risks and exposures. The successful candidate will be responsible for overseeing cybersecurity programs, providing strategic direction, financial oversight, and prioritizing investments in new security controls to combat emerging threats. This role also involves managing portfolio reporting and the delivery of cybersecurity capabilities to mitigate risks in the organization’s environment. In this role, the IAM Lead Strategist will develop and maintain ETL processes, implement change control and testing processes for database modifications, and create technical documentation to support integration efforts. The position requires a strong focus on data security, including managing row-level security and ensuring the protection of data from external threats. The candidate will also design and deploy data structures, reports, and queries, and perform root cause analysis to resolve complex problems effectively. The ability to work in virtual environments with team members located in various locations is essential for success in this position.

Responsibilities

  • Develop and maintain ETL processes
  • Implement and maintain change control and testing processes for database modifications
  • Develop and maintain database stored procedures, views, and functions
  • Create and maintain technical documentation
  • Ensure data security from external parties and manage row-level security
  • Design and deploy data table structures, reports, and queries
  • Perform root cause analysis to prevent recurrence of problems and manage complex problem resolution
  • Collaborate with key stakeholders to drive initiatives to completion and rollout
  • Enhance security standards and integrate solutions within the cybersecurity framework

Requirements

  • 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 loss prevention, vulnerability management, access management, firewalls, and security awareness training
  • Excellent ability to express complex 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 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
  • Experience in building Dashboards and KPI visualization on Power BI and/or Tableau
  • Experience in building Data Marts using dimensional models

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)
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service