Report Analyst
BASIC PURPOSE:
The primary focus of this position is to produce reports with reliable and meaningful statistics about the operation and performance of the Neiman Marcus Direct call center. The Reporting Analyst will execute and maintain current processes for generating and distributing reports. They will also support efforts to develop and launch new reports including gathering requirements, preparing and integrating data inputs from various systems and making recommendations on design decisions.
KEY RESULT AREAS:
Job Responsibilities:
-
Prepare and distribute accurate daily, weekly, monthly and ad-hoc reports by established deadlines
-
Evaluate current reports and processes to determine validity, integrity and relevancy of output
-
Implement improvements and automation to current processes to increase efficiency
-
Create and maintain thorough documentation of team processes and useful reference material
-
Proactively identify and communicate trends, opportunities and issues before they escalate
-
Work with other business units to gather requirements and develop new reports
-
When developing new reports, identify and communicate potential risks of proposed design requirements and make recommendations on ways to reduce or eliminate those risks
-
Provide technical input to ensure that new report designs effectively accomplish strategic objectives
-
SKILLS/EXPERIENCE REQUIRED:
-
Strong organizational and analytical skills
-
Excellent attention to detail
-
Ability to work multiple projects concurrently
-
Proficient in Microsoft Office applications
-
Experience developing & maintaining relational databases (SQL Server preferred)
-
Creating tables, keys, indexes, triggers, stored procedures
-
Writing optimized efficient queries
-
Running routine maintenance tasks
-
Previous experience with SSIS,SSAS or SSRS is a plus
-
-
Advanced Microsoft Excel experience
-
Writing and using advanced functions and formulas (e.g. lookup & reference, nested logical expressions, aggregation, etc.)
-
Advanced Excel features (e.g. conditional formatting, data validation, pivot tables, external data connections)
-
-
Experience automating tasks with VBA, VBScript or other scripting technology
-
Understanding of descriptive statistics
-
Previous experience with call center or workforce management systems (e.g. NICE IEX WFM, Avaya CMS, etc.) preferred
-
Tableau Experience a plusADDITIONAL ATTRIBUTES:
-
Aptitude for learning new technologies.
-
Ability to work well with others, to listen effectively, and share necessary information.
-
Composes and communicates materials and information that is clear, concise and appropriate to the audience.
-
Ability to adapt in a regularly changing environment
-
Dependable and trustworthy