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 $.66 and $.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 automation
Ability 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.