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 PreETS(PreEmployment 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 OVRs data management in CWDS
- Standard AdHoc reports as needed by OVR
- A revised system and reports for tracking of Measurable Skills Gains Credential Attainment PreETS(PreEmployment Transition Services) and OVR performance data.
- Aggregate and analyze the data as per the requirements.
- A plan for integrating the PreETS 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 Adhoc 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 EBRDC 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 problemsolving 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 crossfunctional 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
data,soap ui,data visualization tools,mdx queries,ssis,python,management,business objects enterprise (boe) crystal reports,pm methodologies,compliance,etl tools,testing efforts coordination,sql,data management,ssrs
Data Analyst
