Data Analyst - Cyborgwave

Position:& OVR - Data Analyst

Location: Dauphin County, PA

Client: Commonwealth of PA

Agency: OVR

Interview Type: Webcam

Position ID: 748910

Position Description:

The technical Data Analyst lead provides technical design expertise and will play a pivotal role in addressing identified issues within the Office of Vocational Rehabilitation’s (OVR) data management system in the Commonwealth Workforce Development System (CWDS). This position involves developing solutions, creating an overall plan, and building necessary reports. The primary focus areas include improving data management practices, tracking and reporting on the data for Measurable Skills Gains (MSG), and Credential Attainment, Pre-ETS(Pre-Employment Transition Services), and other OVR performance parameters.

Responsibilities:

1.Data Solutions Development:

Collaborate closely with the OVR team to assess the current state of data management and reporting in CWDS.

Develop a comprehensive plan to address identified issues and enhance data management practices.

Propose solutions to streamline processes and improve accuracy.

2.Reporting and Analysis:

Create standard and ad hoc reports based on OVR’s reporting needs.

Design report templates and generate reports as required.

Aggregate and analyze the data as per the requirements.

Investigate and address flaws in the current CWDS tracker system.

3.Deliverables:

Comprehensive plan for improving OVR's data management in CWDS

Standard Ad-Hoc reports as needed by OVR

A revised system and reports for tracking of Measurable Skills Gains, Credential Attainment, Pre-ETS(Pre-Employment Transition Services), and OVR performance data.

Aggregate and analyze the data as per the requirements.

A plan for integrating the Pre-ETS and Vocational Rehabilitation Systems.

The incumbent should have advanced data analytical skills, leadership abilities and lead responsibility for the following activities within the assigned project.

• Design and create Ad-hoc reports in Business Object Enterprise (BOE) business intelligence reporting system from CWDS database based of the data need.

• Engage as Liaison between business partner agency and information technology (IT) staff including Project Manager and internal/vendor development staff. Possess the ability to interact with various staff levels including senior executive managers.

• Involved in planning and coordinate overall testing efforts to include test plan, creation, and execution of test scenarios for system integration testing (SIT) and User Acceptance Testing (UAT).

• Orchestra coordination and execution of Training Plan including development of training materials, quick reference guides, and standard operating procedures manuals.

• Ensure compliance with all applicable Commonwealth information technology policies and EBR-DC guidelines, security, and related standards.

• Analyze legislation or other business documentation to determine any necessary IT system or business process changes that are required.

• Ensures proper escalation to appropriate management of issues and potential project risks including compliance risks or limitations of available information technology services risks impacting development completion or impacts to schedules

•& Execute systematic problem-solving activities by ensuring that issues are reviewed and evaluated based on relevant criteria impacting decision and outcomes.

• Ability to manage multiple projects and tasks at the same time while ensuring focus on completing quality activities and meeting timelines for each.

• As business partner ‘Business Owner’ define and classify problems, evaluating possible outcomes, and recommending proposed solutions.

• Exhibit effective oral and written communication skills ensuring that proper levels of details are relayed depending on the audience as interaction with peers, managers, and executive management will be required.

• Exhibit ability to work both independently and develop relationships with cross-functional team of resources.

• Plan, coordinate and facilitate internal business partner session reviews of existing system functionality and potential new system enhancements and/or system requirements.

• Interact and provide as needed updates/presentations/reports for OVR/WF Executive, Administrative and management staff.

• Manage interpersonal and Team Building efforts for OVR business partner staff.

Skill Matrix:



Skill

Required / Desired

Amount

Bachelor’s degree in Business Administration, Information Systems, or a related field.

Required

Experience in aggregating and analyzing data using Business Objects Enterprise (BOE) Crystal reports.

Required

Experience in in writing SQL and MDX queries for data analysis

Required

Experience with SSRS, SSIS and ETL tools

Required

Data Visualization tools such as Lumira and power BI

Required

Experience working with Python. Soap UI

Required

Experience with Compliance and digital accessibility controls

Highly desired

Experience with PM methodologies and/or managing tracking a project against a project plan

Highly desired

Experience with assisting testing efforts to include reviewing test scenarios for UAT and organizing users to Facilitate effective tests

Required

Experience working to facilitate collaboration across the full range of executive, business, and technical resources