
Senior Data and BI Lead Analyst
Citi
full-time
Posted on:
Location Type: Hybrid
Location: Irving • Florida • Texas • United States
Visit company websiteExplore more
Salary
💰 $125,760 - $188,640 per year
Job Level
Tech Stack
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