The Analyst is responsible for supporting the reporting and analytics function by consulting with business users to fully understand data and reporting needs. This will include generating semi-complex to complex queries and reports, performing specialized analyses of employee data, and/or providing advanced services related to Vendor Management or Applicant Tracking Systems reporting while following best practices.

Responsibilities

In order to perform this job successfully, an individual must be able to perform each essential duty listed below. The requirements listed below are representative of knowledge, skill and ability required for the position.

Design, develop, and maintain reports, reporting templates, and dashboards by leveraging data from various sources such as Applicant Tracking Systems, Vendor Management Systems, Finance systems, MS Excel and MS Access or MS Azure Databases
Query or extract data from the various source systems using the following report writing tools – Oracle BI, SQL Server Reporting Services, and PS Query
Schedule, design and execute standard and semi-complex ad hoc reports, troubleshoot and resolve data anomalies, initiate data validation and ensure data integrity across data sources
Interact with various users to establish and clarify requirements in order to develop report specifications, consults with end users on medium to complex level reporting requests and to determine client reporting needs as to how data can be provided to support strategic business decisions
Respond to user questions regarding data sources, with explanations on data elements and others regarding limitations of specific data analysis projects
Perform mid-level data quality checks using advanced knowledge of the repository and other data sources to identify data anomalies proactively prior to report delivery to the users and resolves semi-complex data integrity and escalates problems outside area of expertise to stakeholders/management
Assist in special projects as assigned to support account initiatives and Centers of Excellence
Provide written analysis of business issues using internal data sources, trending analysis and problem solving skills.
Maintain program reporting catalogs, schedules and documentation to support business continuity.
Document reporting requirements, procedures, and business rules necessary to support the delivery of reporting for our programs and customers.
Manage a combination of regularly scheduled deliverables as well as ad hoc reporting requests.
Critical involvement in the creation of QBR presentations including recommendations for improvement, relevant benchmarking, outside data sources, etc.
Identify areas for process improvement, and implement changes to drive efficiency/quality.
Act as leader/mentor to junior analysts in increasing their industry, technical or analytical skills with the intended purpose of advancing overall knowledge and performance in their role.