RICEFW Technologies
OVR - Data Analyst - Fully Onsite
RICEFW Technologies, Dauphin, Pennsylvania, United States, 17018
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 CWDSStandard Ad-Hoc reports as needed by OVRA 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.
Required/Desired SkillsSkill Required /Desired Amount Consultant Experience Bachelor's degree in Business Administration, Information Systems, or a related field. Required 4 Experience in aggregating and analyzing data using Business Objects Enterprise (BOE) Crystal reports. Required 7 Experience in in writing SQL and MDX queries for data analysis Required 7 Experience with SSRS, SSIS and ETL tools Required 7 Data Visualization tools such as Lumira and power BI Required 7 Experience working with Python. Soap UI Required 7 Experience with Compliance and digital accessibility controls Highly desired 0 Experience with PM methodologies and/or managing & tracking a project against a project plan Highly desired 0 Experience with assisting testing efforts to include reviewing test scenarios for UAT and organizing users to Facilitate effective tests Required 7 Experience working to facilitate collaboration across the full range of executive, business, and technical resources Required 7
QuestionsNo. Question Consultant Answer Question2 This position requires candidate to be onsite 5 days a week (M-F) at Department of Labor and Industry building in Harrisburg, PA . Can the candidate comply? Question3 Please provide your candidates current physical residence. (City,State) Question4 This position is scheduled for a 40 hour work week (8 am - 5 pm with a 1 hour lunch break). Does the candidate agree with this schedule? Question5 Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor, and make them ineligible for rehire in the program.
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 CWDSStandard Ad-Hoc reports as needed by OVRA 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.
Required/Desired SkillsSkill Required /Desired Amount Consultant Experience Bachelor's degree in Business Administration, Information Systems, or a related field. Required 4 Experience in aggregating and analyzing data using Business Objects Enterprise (BOE) Crystal reports. Required 7 Experience in in writing SQL and MDX queries for data analysis Required 7 Experience with SSRS, SSIS and ETL tools Required 7 Data Visualization tools such as Lumira and power BI Required 7 Experience working with Python. Soap UI Required 7 Experience with Compliance and digital accessibility controls Highly desired 0 Experience with PM methodologies and/or managing & tracking a project against a project plan Highly desired 0 Experience with assisting testing efforts to include reviewing test scenarios for UAT and organizing users to Facilitate effective tests Required 7 Experience working to facilitate collaboration across the full range of executive, business, and technical resources Required 7
QuestionsNo. Question Consultant Answer Question2 This position requires candidate to be onsite 5 days a week (M-F) at Department of Labor and Industry building in Harrisburg, PA . Can the candidate comply? Question3 Please provide your candidates current physical residence. (City,State) Question4 This position is scheduled for a 40 hour work week (8 am - 5 pm with a 1 hour lunch break). Does the candidate agree with this schedule? Question5 Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor, and make them ineligible for rehire in the program.