Systems Analyst Iii - Etl Developer - Tx Remote

Performs complex (journey-level) computer systems analysis work. Work involves analyzing
and identifying system requirements, procedures, and problems to automate processing or to
improve existing systems, and implementing designs using software-programming languages.
May provide guidance to others. Works under general supervision, with moderate latitude for
the use of initiative and independent judgment.
The mission of DFPS is to protect children, the elderly, and people with disabilities from abuse, neglect, and exploitation by involving clients, families, and communities. We are looking to grow our teams with people who share our energy and enthusiasm to get behind our mission of protecting those among us who are most in need.
This position is classified as a full-time position (40 hours a week). Remote work options are available for workers living in Texas. Work outside of regular hours may be required; some weekend on-call duty may be required. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.

Essential Job Functions:

As an ETL Developer on the Data Management Team, the position requires knowledge of data warehouse, ETL, Oracle, PL/SQL and SQL.

Learns and Practices current development methods/techniques and development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of ETL's and Program Data Architecture.

Develops and maintains documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience.

Develops and maintains applicable policies, guidelines, and procedures for area of expertise.

Monitors automated processes, troubleshoots process issues, and works with users and team members to resolution.

Conducts studies and prepares reports that include study findings, recommendations, and instructions for proposed system implementations; formulates logical descriptions of problems
and devises optimum solutions.

Performs system function test activities before executing in production.

Ensures that new templates are peer reviewed before executing in production.

Designs, modifies, and implements new or revised systems to serve new purposes or improve
workflow.

Follows established code migration processes.

Supports system development with new structures and modifications to existing structures.

Reviews change requests to ensure they meet standards and are consistent with the parameters within existing environments.

Ensures all change requests are tracked electronically according to their release.

Reviews and analyzes system outputs, reports, and performance indicators to locate code
problems; and corrects errors by modifying or correcting code.

Processes system fix/change requests in a timely manner.

Follows system fix policies and procedures to ensure consistency and reduce any potential for errors.

Analyzes user needs, defines the system’s scope, documents requirements, and translates the user needs and requirements into functional specifications for the design of business systems.

Communicates progress and issues affecting work assignments to the Team Manager and Project Manager timely.

Assists with defining the goals of the system, devises flow charts, and diagrams logical operational steps of the programs.

Documents steps taken to complete system changes and updates status of change requests, as required.

Reviews explain-plans for new or modified changes and queries for performance and recommends alternatives to resolve performance issues.

May write and update computer and mainframe application programs.

Coordinates with ITS Project Managers to determine requirements needed for projects.

Designs, codes, and modifies application programs.

May provide technical support as a high-level resource available for problem resolution or new
feature creation.

Provides technical support by verifying changes have been applied correctly.

Consults processes for any dependencies and additional information that the change request may require.

Monitors data/code progress and provides status updates on a regular basis.

May provide guidance to others.

May provide on-call support on a monthly rotation schedule.

Maintains technical and functional proficiency in assigned division information systems and stays current on the latest technology updates and development techniques for the applicable area(s) of responsibility.

Performs related work as assigned.

Initial Selection Criteria:
Graduation from an accredited four-year college or university; or graduation from an accredited two-year college; or graduation from an accredited technical college or program. Relevant work experience may be substituted for education on a year-for-year basis. Consideration given for DFPS agency program experience.
One (1) year of experience programming, systems analysis, system design using Oracle, SQL, PL-SQL, or similar systems and technology experience.

Additional Information:
Note: Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to: 25B, IT, 275. All active duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position