SQL Database Specialist - VP

| Dallas-Fort Worth, TX
Sorry, this job was removed at 4:49 p.m. (CST) on Wednesday, February 8, 2023
Find out who's hiring in Dallas, TX.
See all Data + Analytics jobs in Dallas, TX
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Job Purpose:

Security State Management Information Security Senior Data Specialist will play a leading role in driving information security analysis and strategy within the Enterprise Infrastructure Operations & Technology (EO&T) Information Security State Management (SSM) team. This role is a key business enabler to provide information security risk analysis and strategic recommendations for the ongoing improvement of Information Security within Enterprise Infrastructure and Citi Technology Infrastructure (CTI).

Job Background:

Information Security is a primary area of focus for Citi. The EO&T IS organization partners with Citi Technology Infrastructure (CTI) to provide world class Information Security support. This key position reports into the Security State Management organization and will be at the heart of managing vulnerabilities and threats affecting technology infrastructure.

Key Responsibilities:

  • Develop and maintain transactional and dimensional databases/warehouse with further expansion to big data and other products if necessary.
  • Develop and maintain ETL and data load jobs (Talend).
  • Analyze requirements, co-design and develop specifications and manage data which supplies information to all threat reporting and analysis for the purpose of reducing risks to Citi's infrastructure.
  • Develop and maintain transactional and dimensional databases/warehouse.
  • Act as data owner for the team. Create and maintain data models and ontology, participate in the organization's data governance.
  • Develop and manage program metrics and performance through tracking/reporting and active engagement with stakeholders for continuous service improvement.
  • Develop horizontal view of risk posture across multiple technology domains.
  • Work with various risk and information security teams in presenting recommendations for improvement to technology subject matter experts and management.
  • Engage with cross sector, global and risk teams in the review and reengineering of key controls and processes to effectively and efficiently manage IS issues.
  • Work with vulnerability lifecycle managers, operations and application support teams and the SSM team to analyze requirements, design and develop specs and manage data which supplies information to all vulnerability threat reporting and analysis.
  • Additional ad-hoc IS & Risk related initiatives and projects
  • Complete additionally any other tasks in connection with the role but not detailed in the current job description, charged by the direct manager, supervisor, or the functional head.



Skills:

  • Expert level Microsoft T-SQL knowledge and experience with other business analytics software
  • Experienced in designing data / reporting systems from the ground up.
  • Comfortable with complex ETL data flows, ability to reverse engineer existing packages and create new ones (Talend)
  • Advanced knowledge of complex query for data analysis.
  • Strong understanding of performance tuning and optimization (analyzing query execution plans, implementing and maintaining indexes, etc.)
  • Technical background in RDBMS, Windows/Unix Operating systems, security technologies, and network architectures.
  • Basic understanding of security assessment methodology and risk management process.
  • Strong knowledge of industry standards as they relate to information security management.



Advantages:

  • Experience with Splunk
  • Experience with CI/CD type development
  • Experience with Atlassian suite (JIRA, Confluence, BitBucket)
  • Experience with at least one coding language (PowerShell, Python, C#, etc.)



Qualifications:

  • BA/BS degree or equivalent experience preferred.
  • Prior experience includes 3+ years in information security
  • 5+ years as a database developer



Apply to join the world's most global bank and discover the true extent of your capabilities.

Competencies:

  • Excellent problem solving abilities and analytical skills. Ability to see the big picture with high attention to critical details.
  • Strong work ethic, excellent use of discretion and judgment.
  • Results oriented, is able to achieve desired outcomes independently and at appropriate priority levels.
  • Well organized with follow-up abilities; has a track record of effectively managing multiple tasks in a dynamic environment.
  • Ability to work under pressure, meet challenging deadlines.
  • Demonstrated ability to work effectively as part of a team, as well as, independently.
  • Effective communicator; has excellent writing and verbal skills.
  • Has the ability to influence others and shape/obtain desired outcome in areas outside of direct control.
  • Demonstrated ability to develop and implement process improvement initiatives.



Job Family Group:
Technology

Job Family:
Information Security

Time Type:
Full time

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi") invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View the "EEO is the Law" poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting

Effective November 1, 2021, Citi requires that all successful applicants for positions located in the United States or Puerto Rico be fully vaccinated against COVID-19 as a condition of employment and provide proof of such vaccination prior to commencement of employment.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about CitiFind similar jobs