Security Data Analytics & Reporting Specialist

Deloitte France; Village of Williamsville (NY); On-site; USD 69,000 - 116,000; Full time

Job summary

Deloitte GPS Security is seeking a data analyst to lead reporting and data analysis efforts. You will develop, implement, and analyze reports to support strategic decisions, identify data issues, and improve efficiency.

The role requires SQL, Excel advanced skills, Tableau, SharePoint management, and a US Secret clearance; travel about 10%. Join a team protecting sensitive information under the National Industrial Security Program.

Qualifications

• 4+ years of data analysis and reporting experience.
• Active US Secret Security clearance.
• Advanced Excel skills: Pivot Tables, VLOOKUP, Macros.
• Experience with Tableau and SharePoint management.
• Able to travel ~10% to meet client needs.
• Understanding of databases and data mining basics.

Responsibilities

• Run routine and ad-hoc reports.
• Create dashboards with Tableau, Power BI, or similar tools.
• Write and update SQL queries across relational databases.
• Audit data for integrity in reporting and metrics.
• Develop data quality rules and monitoring for reporting repositories.
• Prepare clear summaries to communicate metrics to clients and leaders.
• Recommend improvements for reporting processes and data integrity.
• Manage and organize reporting information on SharePoint.
• Learn about the National Industrial Security Program and Deloitte GPS Security.
• Develop general knowledge of security processes and Deloitte GPS Security services.
• Maintain confidentiality of sensitive and/or PII.

Skills

Data analysis

Pivot Tables

VLOOKUP

Macros

Tableau

SharePoint

Databases basics

SQL familiarity

Attention to detail

Team collaboration

Data visualization

Tools

Tableau

SharePoint

SQL

Job description

Deloitte GPS Security is seeking a data analyst to lead reporting and data analysis efforts. You will develop, implement, and analyze reports to support strategic decisions, identify data issues, and improve efficiency.

The role requires SQL, Excel advanced skills, Tableau, SharePoint management, and a US Secret clearance; travel about 10%. Join a team protecting sensitive information under the National Industrial Security Program.