Citi

Senior Data and BI Lead Analyst

Citi

full-time

Posted on:

Location Type: Hybrid

Location: IrvingFloridaTexasUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $125,760 - $188,640 per year

Job Level

About the role

  • 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.
  • Perform Quality Control checks on others' reports for both formatting and data issues.
  • 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.
  • The reports and data analysis artifacts must be presented to stakeholders in clear and easily understood format in Excel, PowerPoint, Word or PDF documents.

Requirements

  • Minimum 6 years working in IT / Information Security, preferably focused in Financial Services industry.
  • 5+ years of Reporting area experience is a must.
  • Industry Cybersecurity certifications are a plus.
  • Proficiency in Cognos report authoring is strongly preferred.
  • Undergraduate degree required; Masters in Data Sciences preferred.
  • Be proficient in crafting data sets needed to support interactive analytics.
  • Understand the concepts of ETL (extraction, transform, and load).
  • Familiarity with SQL, and databases.
  • Should be able to work independently and also in a team environment.
  • Be able to multi-task and pay attention to details.
  • Be proficient in Microsoft Office products such as Excel, Access, PowerPoint, and Word.
  • Have good presentation skills.
Benefits
  • medical, dental & vision coverage
  • 401(k)
  • life, accident, and disability insurance
  • wellness programs
  • planned time off (vacation)
  • unplanned time off (sick leave)
  • paid holidays
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
CognosSQLETLdata analysisdata visualizationreportingdata setsBusiness IntelligenceQuality Controldata processing
Soft Skills
attention to detailpresentation skillsindependent workteam collaborationmulti-taskingcommunication
Certifications
Cybersecurity certifications