Dept of Family & Protectve Svc
Systems Analyst V
Dept of Family & Protectve Svc, Austin, Texas, us, 78716
Job Description:DIT - Data Infrastructure and Technology Division Tech Team - Systems Analyst III - V
The person in this position functions as a technical team reporting analyst in the ODSI-Data Infrastructure and Technology Division. This position may be filled as a Systems Analyst III, IV, or V. Salary range is between $5797.66 and $9508.25 (monthly) depending on the level at which the position is filled in accordance with agency policies.
The ODSI-DIT Division is responsible for ensuring data is available in the Data warehouse in a timely manner. The division also is responsible for development of data warehouse online reports on the Safety Net and the supporting specialized tables and/or elements on the Data Warehouse. The division is responsible for conducting quality assurance review of any data to be released outside the agency to ensure validity and consistency of reported data.
Work involves gathering and analyzing requirements, report design and implementation, and on-going maintenance of existing reports and processes. Analyst will work with other ODSI staff as well as other DFPS staff to develop back-end tables and logic to drive reporting (ad-hoc, .ASP automation, Tableau extracts, etc.). Current processes are implemented using Unix Shell scripting, SQL and/or PL/SQL in Toad, ASP and VBScript/HTML. The analyst creates original programming logic and evaluates and/or modifies existing programs of any level of complexity to take into account changes in requirements. The analyst may prepare diagrams and logic flowcharts for detailed coding and for the documentation of programming work. The analyst may be required to review work products developed by other analysts and to interact with agency Program staff, division managers, regional staff, and/or other analysts to ensure requirements are met and that all work products are appropriately reviewed and validated. The analyst may interact with staff from other agencies and outside entities as required to facilitate data collaboration, obtain required work products, or for consultation. The analyst participates in system design meetings for new agency initiatives to ensure the agency's ability to report applicable data. The analyst may serve as a lead analyst on assigned projects of any level of complexity and may act as a mentor and on-the-job trainer for new or junior analysts.
Essential Job Functions:Develops programming logic and report layout to ensure user requests are properly translated into useful reports.Extracts data from IMPACT, CLASS, PEIRS, CAPPS(HR), or other agency databases.Documents, designs, validates, and implements reporting methodologies for multiple areas of specialization using selected DFPS methodology and tools.Performs quality assurance tasks to ensure accuracy of distributed reports.Documents processes and procedures for technical and non-technical users.Ability to mentor and trains junior staff.Provides technical expertise to aid in decision making and problem resolution.Participates in database design sessions for new initiatives and for enhancements to ensure reporting requirements are met.Performs other duties as assigned and required to maintain unit operations.Promotes and demonstrates appropriate respect for cultural diversity among coworkers and all work-related contacts.Attends work regularly in accordance with agency leave policy.
Knowledge Skills Abilities:Knowledge of relational databases and database development best practices.Knowledge of data processing practices and theory.Knowledge of group dynamics.Skill in using software such as SQL, SQL*Plus, PL/SQL, Excel, TOAD, Oracle, SQL Developer, Business Intelligence tools.Skill in researching and troubleshooting data issues and solving complex problems.Skill in writing and revising program code.Skill in analysis, problem solving, data comprehension, reporting methodologies, math, and designing statistical reports and charts/graphs.Skill in report development and automationAbility to analyze, consolidate, and interpret complex data, procedures, and systems and write or revise program code as required.Ability to analyze systems, procedures, and problems and develop solutions.Ability to perform detailed work accurately.Ability to learn and apply new technology.Ability to work under stressful conditions and manage multiple projects and tight deadlines.Ability to adapt and modify behavior in response to changes in situations or priorities.Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.Ability to work hours as needed to meet defined deadlines and support the agency's mission critical reporting requirements.
Registration or Licensure Requirements:
Initial Selection Criteria:•Experience in writing SQL is required•Experience in writing PL/SQL code is preferred.•Experience in using MS Word and Excel is preferred•Experience in using any one of these software tools such as Oracle or Sql Plus or Sql Developer or Toad is required for database development.•Experience in the software tools such as Tableau is preferred.•Experience in data extraction, transition, and load (ETL) is preferred.•Experience in database design concepts and implementation is preferred.•Experience in Report layout/design/implementation is preferred.•DFPS experience preferred.
Additional Information:Requisition Number 615937
Work outside of regular hours, including occasional weekends, may be required. Occasional overnight travel to other work locations may be required. Applicants selected for interview will be required to complete a written exercise to demonstrate knowledge, skills, and abilities. This position may be filled as a Systems Analyst III, IV, or V. Salary range is between $3,763 and $8,060 depending on the level at which the position is filled an in accordance with agency policies. In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.
MOS Code:Note: Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include: 25B, IT, 275, 0171, 3D0X2. For more information see the Texas State Auditor's Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.
As a state agency, DFPS is required Texas Administrative Code (TAC 206 and 213) to ensure all Electronic Information Resources (EIR) follow accessibility standards. The staff must be familiar with the WCAG 2.1 AA and Section 508 to create accessible content including but not limited to; Microsoft Office documents, Adobe PDFs, webpages, software, training guides, video, and audio files.
HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.
I-9 Form - Click here to download the I-9 form.
In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.
The person in this position functions as a technical team reporting analyst in the ODSI-Data Infrastructure and Technology Division. This position may be filled as a Systems Analyst III, IV, or V. Salary range is between $5797.66 and $9508.25 (monthly) depending on the level at which the position is filled in accordance with agency policies.
The ODSI-DIT Division is responsible for ensuring data is available in the Data warehouse in a timely manner. The division also is responsible for development of data warehouse online reports on the Safety Net and the supporting specialized tables and/or elements on the Data Warehouse. The division is responsible for conducting quality assurance review of any data to be released outside the agency to ensure validity and consistency of reported data.
Work involves gathering and analyzing requirements, report design and implementation, and on-going maintenance of existing reports and processes. Analyst will work with other ODSI staff as well as other DFPS staff to develop back-end tables and logic to drive reporting (ad-hoc, .ASP automation, Tableau extracts, etc.). Current processes are implemented using Unix Shell scripting, SQL and/or PL/SQL in Toad, ASP and VBScript/HTML. The analyst creates original programming logic and evaluates and/or modifies existing programs of any level of complexity to take into account changes in requirements. The analyst may prepare diagrams and logic flowcharts for detailed coding and for the documentation of programming work. The analyst may be required to review work products developed by other analysts and to interact with agency Program staff, division managers, regional staff, and/or other analysts to ensure requirements are met and that all work products are appropriately reviewed and validated. The analyst may interact with staff from other agencies and outside entities as required to facilitate data collaboration, obtain required work products, or for consultation. The analyst participates in system design meetings for new agency initiatives to ensure the agency's ability to report applicable data. The analyst may serve as a lead analyst on assigned projects of any level of complexity and may act as a mentor and on-the-job trainer for new or junior analysts.
Essential Job Functions:Develops programming logic and report layout to ensure user requests are properly translated into useful reports.Extracts data from IMPACT, CLASS, PEIRS, CAPPS(HR), or other agency databases.Documents, designs, validates, and implements reporting methodologies for multiple areas of specialization using selected DFPS methodology and tools.Performs quality assurance tasks to ensure accuracy of distributed reports.Documents processes and procedures for technical and non-technical users.Ability to mentor and trains junior staff.Provides technical expertise to aid in decision making and problem resolution.Participates in database design sessions for new initiatives and for enhancements to ensure reporting requirements are met.Performs other duties as assigned and required to maintain unit operations.Promotes and demonstrates appropriate respect for cultural diversity among coworkers and all work-related contacts.Attends work regularly in accordance with agency leave policy.
Knowledge Skills Abilities:Knowledge of relational databases and database development best practices.Knowledge of data processing practices and theory.Knowledge of group dynamics.Skill in using software such as SQL, SQL*Plus, PL/SQL, Excel, TOAD, Oracle, SQL Developer, Business Intelligence tools.Skill in researching and troubleshooting data issues and solving complex problems.Skill in writing and revising program code.Skill in analysis, problem solving, data comprehension, reporting methodologies, math, and designing statistical reports and charts/graphs.Skill in report development and automationAbility to analyze, consolidate, and interpret complex data, procedures, and systems and write or revise program code as required.Ability to analyze systems, procedures, and problems and develop solutions.Ability to perform detailed work accurately.Ability to learn and apply new technology.Ability to work under stressful conditions and manage multiple projects and tight deadlines.Ability to adapt and modify behavior in response to changes in situations or priorities.Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.Ability to work hours as needed to meet defined deadlines and support the agency's mission critical reporting requirements.
Registration or Licensure Requirements:
Initial Selection Criteria:•Experience in writing SQL is required•Experience in writing PL/SQL code is preferred.•Experience in using MS Word and Excel is preferred•Experience in using any one of these software tools such as Oracle or Sql Plus or Sql Developer or Toad is required for database development.•Experience in the software tools such as Tableau is preferred.•Experience in data extraction, transition, and load (ETL) is preferred.•Experience in database design concepts and implementation is preferred.•Experience in Report layout/design/implementation is preferred.•DFPS experience preferred.
Additional Information:Requisition Number 615937
Work outside of regular hours, including occasional weekends, may be required. Occasional overnight travel to other work locations may be required. Applicants selected for interview will be required to complete a written exercise to demonstrate knowledge, skills, and abilities. This position may be filled as a Systems Analyst III, IV, or V. Salary range is between $3,763 and $8,060 depending on the level at which the position is filled an in accordance with agency policies. In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.
MOS Code:Note: Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include: 25B, IT, 275, 0171, 3D0X2. For more information see the Texas State Auditor's Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.
As a state agency, DFPS is required Texas Administrative Code (TAC 206 and 213) to ensure all Electronic Information Resources (EIR) follow accessibility standards. The staff must be familiar with the WCAG 2.1 AA and Section 508 to create accessible content including but not limited to; Microsoft Office documents, Adobe PDFs, webpages, software, training guides, video, and audio files.
HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.
I-9 Form - Click here to download the I-9 form.
In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.