Application Security Data Analyst
| Company | Citigroup |
|---|---|
| Location | Tampa, FL, USA, Irving, TX, USA |
| Salary | $125760 – $188640 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Senior, Expert or higher |
Requirements
- 7+ years’ experience of strong data analysis and report development working with BI tools (Cognos, Tableau, etc.) on relational databases (Oracle, SQL Server, Microsoft Access)
- Excellent Excel data analysis and Access database skills
- Excellent SQL Skills
- Strong BI development skills
- Strong understanding of application development life cycle, CI/CD and DevOps concepts
- Excellent Analytical Ability to understand the systems and data flow at a high level to evaluate if appropriate controls are in place for the standards
- Experience with issue resolution with proven ability to research, identify and communicate solutions
- Excellent documentation skills to collect, summarize and synthesize information in an auditable format
- Excellent organization and multi-tasking skills
- Proven influencing and relationship management skills
Responsibilities
- Perform data analysis from multiple systems and assess completeness of data for reporting
- Work with the Metrics reporting team to enhance and refine the metrics and key performance indicators reported to senior management and external regulatory agencies
- Analyze and report aggregated data from multiple data sources
- Develop data visualization mock-ups for monitoring program data trends and communicate using analytical tools
- Design and implement a solution for performance measurements on effectiveness of controls and overall vulnerability assessment program
- Document data extraction and transformation rules to integrate new sources of data into a data warehouse
- Analyze trends on assets security health posture and report using visualization tools for program review with management and stakeholders
- Develop reports for tracking program effectiveness and update power point deck for weekly, monthly and quarterly updates
- Provide timely, accurate, and actionable reporting on application vulnerability activity, trends, service levels, and areas of concern to senior management
- Develop, optimize and provide continuous support for reports and ad-hoc queries from end user
- Create dashboards with parameters and interactive drill down functionality
- Streamline and automate report creation and distribution for weekly & monthly reporting
- Develop User acceptance test plans for testing changes to system enhancements that impact governance and compliance
- Document business requirements related to system enhancements and submit for reviews and approvals
- Ensure data integrity and compliance by performing data audits and data validation
- Performs root cause analysis on metric trends and provide insight to governance team for appropriate refinements to rules
Preferred Qualifications
- Relevant experience in Information Security and/or Application Security is highly preferred