Sr. Data and BI Lead Analyst, VP

About Citi:

Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments, and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.

As a bank with a brain and a soul, Citi creates economic value that is systemically responsible and in our clients’ best interests. As a financial institution that touches every region of the world and every sector that shapes your daily life, our Enterprise Operations & Technology teams are charged with a mission that rivals any large tech company. Our technology solutions are the foundations of everything we do from keeping the bank safe, managing global resources, and providing the technical tools our workers need to be successful to designing our digital architecture and ensuring our platforms provide a first-class customer experience. We reimagine client and partner experiences to deliver excellence through secure, reliable, and efficient services.

Our commitment to diversity includes a workforce that represents the clients we serve from all walks of life, backgrounds, and origins. We foster an environment where the best people want to work. We value and demand respect for others, promote individuals based on merit, and ensure opportunities for personal development are widely available to all. Ideal candidates are innovators with well-rounded backgrounds who bring their authentic selves to work and complement our culture of delivering results with pride. If you are a problem solver who seeks passion in your work, come join us. We’ll enable growth and progress together.

The Sr. Data & BI Lead Analyst, VP is an intermediate level position responsible for driving efforts to prevent, monitor and respond to information/data breaches and cyber-attacks. The overall objective of this role is to ensure the execution of Information Security directives and activities in alignment with Citi's data security policy.

Responsibilities:

Report production:

• Build and maintain highly detailed Business Intelligence reports in Cognos.

• Produce monthly and periodic reports on designated Cybersecurity programs and on any assigned topics.

• Work with the Cybersecurity program owners, gather Cybersecurity risk data from them, process the data as needed and produce IS reports and metrics.

• Maintain the reports as needed. Analyst needs to have a keen eye for the numbers, be able to self-QC his /her own reports and data, be able to present the data in clear and concise way.

Report QC:

• Perform Quality Control checks on others' reports for both formatting and data issues. Be able to look at the source data and compare it with the pdf reports and spot discrepancies and other issues.

Data Analysis:

• Perform data analysis using, database tools (SQL), Excel, and Access.

• Produce data sets which are the basis for the interactive analytics and update the data sets on a daily / weekly / monthly basis through automatic ETL jobs.

• Create and maintain and improve the interactive analytics dashboards with appropriate data visualizations.

• Design and document Business Requirements supporting automation of data feeds from upstream applications to the Cybersecurity reporting application.

Presentation skills:

• The reports and data analysis artifacts must be presented to stakeholders in clear and easily understood format in Excel, PowerPoint, Word or PDF documents.

• Work on Cybersecurity Metrics related projects

• Work on assigned projects which generally involve the above areas.

Required technical skills:

• Be proficient in crafting data sets needed to support interactive analytics

• Understand the concepts of ETL (extraction, transform, and load)

• Must be able to produce precise and well-crafted reports, familiarity with SQL, and databases

• Understand general Information Security and understand Info Sec metrics in particular

• Should be able to work independently and also in a team environment Be able to multi-task

• Be able to pay attention to details

• Be proficient in Microsoft Office products such as Excel, Access, PowerPoint, and Word

• Have a working understanding of databases, tables, and data design concepts

• Have good presentation skills and produce precise and well-crafted reports

• Be able to automate one's tasks for expediency