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.