IT System Analyst V – Data Admin – 100 % remote TX

3 weeks ago

Austin, United States Texas Department of Aging & Disability Services Full time
Job Description:
The Texas Department of Family and Protective Services (DFPS) is currently seeking an Oracle Developer for a full-time position within the IT Data Management team. The Developer reports to the Data Management Manager within Information Technology Services (ITS). Works under limited supervision, with considerable latitude for the use of initiative and independent judgment. This position performs advanced (senior-level) data systems analysis; data development; and on-going support of applications used by DFPS staff. Some work involves extraction, transformation and loading (ETL) of data into the agency data warehouse; data warehouse development; data administration; and coordinating the planning and analysis of user requirements, procedures, and problems to automate processing or improve existing systems.

As a member on the Data Management Team, the position requires strong knowledge of data warehouse development, ETL, Oracle, PL/SQL and SQL. Preferrable, the candidate should have knowledge of Informatica PowerCenter as well as business intelligence visualization tools such as Tableau.

The position requires an ability to communicate effectively, both verbally and in writing, and the ability to manage projects against established timelines with minimal supervision. This position also requires the ability to learn and apply new technology, work independently or in a team environment, and collaborate with all levels of staff within DFPS to satisfy business needs.

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. Essential Job Functions:
• Performs analysis and research of application functionality and interprets requirements in order to support Application Development teams' development.
• Practices current development methods/techniques and establishes development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of code.
• Reviews database change request to ensure they meet standards and are consistent with the structural parameters within the existing database environment and are tracked electronically
• Supports application development team needs for new database structures and/or modifications to existing structures.
• Designs, codes, and modifies extract, transform, and load (ETL) logic to populate Agency data warehouse and data marts in order to support Agency reporting.
• Performs advanced data warehouse architect work which includes data warehouse design, data modeling, and metadata design.
• Reviews all application database change requests to determine any (downstream) effect on warehouse ETLs.
• Provides Database Administrator (DBA) support by verifying database structure changes have been applied correctly.
• Communicates and/or collaborates with other department teams to coordinate development efforts.
• Assists in the development and maintenance of documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience.
• Ensures project schedules are met, and/or re-negotiated, and approved by customer and Team Manager prior to target dates.
• Communicates progress and issues affecting work assignments to the Team Manager and/or Project Manager as soon as possible.
• Manages work activities for short and long range performance assignments, communicating with management and other team members in a timely and effective manner.
• Follows established Data Management Team code migration processes.
• Mentors junior level staff in the development, testing, and deployment.
• Consults the Data Dictionary for any dependencies and additional information that the data administration request may require.
• Review explain plans for new or modified queries for performance and suggest alternative ways to resolve any performance issues.
• Provides on-call support on a rotating schedule.
• Develops and conducts presentations, and communicates technical information to all areas of the agency management, including customers, and technical and/or non-technical staff.
• Reviews and analyzes legislative bills related to the application/system and when applicable, provides a cost estimate and potential impact analysis.
• Stays current on the latest technology updates and development techniques for the applicable area(s) of responsibility. (May be accomplished via books, periodicals, Internet, conferences, and training.)
• Adheres to all Texas Department of Family and Protective Services HR policies, performs related work as assigned and attends work on a regular and predictable schedule in accordance with agency leave policies and to maintain unit operations.

This position is a full-time position that includes other State of Texas benefits as described in this SAO site:

Knowledge Skills Abilities:
• Expert knowledge of Oracle databases with some of that experience being Exadata is preferred.
• Knowledge and experience with the Software Development Life Cycle (SDLC) and project planning
• Knowledge of UNIX and shell scripting is preferred.
• Knowledge of Oracle SQL and/or PL-SQL.
• Knowledge of Informatica PowerCenter is preferred
• Knowledge of database object migration/validation tools is preferred
• Knowledge of Informatica or similar tool is preferred
• Knowledge and understanding of ETL development, monitoring, batch or data processing in an automated scheduled environment is preferred.
• Skill in understanding and implementing database change requests.
• Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint.
• Ability to document issues, risks, and defects.
• Ability to communicate effectively in a technical environment, including on-the-job training with coworkers, project team members, and IT management
• Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various level personnel in governmental entities.
• Ability to lead and work cooperatively in a team environment.

  • Admin Assistant at Austin, TX

    4 weeks ago

    Austin, United States Austin, TX Full time

    Job DescriptionJob DescriptionKeystone Restorations & Builders, Inc. in Austin, TX is looking for one admin assistant to join our team. Our ideal candidate is attentive, ambitious, and engaged.ResponsibilitiesField telephone callsReceive and direct visitorsMaintain and coordinate schedules, appointments, and calendarsCreate spreadsheets, presentations, and...

  • Data Analyst V

    3 days ago

    Austin, United States Health & Human Services Comm Full time

    Data Analyst V (DA V) position performs work for the Provider Finance Department under supervision of the Manager of Fees, Data, and Research. The DA V serves as team lead for the Acute Care Data and Research team. This position performs highly complex (senior-level) data collection, reporting, and analysis to monitor, evaluate, and increase efficiencies for...

  • Data Analyst V

    2 days ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Data Analyst V (DA V) position performs work for the Provider Finance Department under supervision of the Manager of Fees, Data, and Research. The DA V serves as team lead for the Acute Care Data and Research team. This position performs highly complex (senior-level) data collection, reporting, and analysis to monitor, evaluate, and...

  • Data Analyst

    5 days ago

    Austin, United States COGENT DATA SOLUTIONS LLC Full time

    Hello Professionals,Cogent Data Solutions LLC is hiring for a Data Analyst/Report Writer position with one of our direct clients.Check out the details listed below. I look forward to hearing back from you. Have a great day!Client Name: Texas Department of Public SafetyJob Location: Austin, TX.(Remote)Job Title: Data Analyst/Report WriterJob ID: 24R0017146Job...

  • Data Analyst

    4 days ago

    Austin, United States COGENT DATA SOLUTIONS LLC Full time

    Hello Professionals,Cogent Data Solutions LLC is hiring for a Data Analyst/Report Writer position with one of our direct clients.Check out the details listed below. I look forward to hearing back from you. Have a great day!Client Name: Texas Department of Public SafetyJob Location: Austin, TX.(Remote)Job Title: Data Analyst/Report WriterJob ID: 24R0017146Job...

  • Systems Analyst V

    2 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Systems Analyst V Under the supervision of the Performance Monitoring and Analytics Manager or designee, the System Analyst V performs highly complex (senior-level) systems analyses related to data collection, reporting, data quality and database management activities to monitor, evaluate and support efforts to increase efficiencies for...

  • Data Analyst V

    4 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Data Analyst V The Data Analyst V position plays a pivotal role by contributing and applying relevant knowledge and analytical skills to support HHSC in its mission to provide essential health and human services to eligible vulnerable Texans in the most effective manner. It is selected by and reports to the Manager of the Demography-GIS...

  • Data Analyst V

    2 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Data Analyst V performs highly complex (senior level) data analysis, data research, database management, and application development assignments for the Data Management Unit within Information and Data Management Division, Office of Data, Analytics, and Performance (ODAP). Detects data trends and anomalies and provides HHSC programs...

  • Microsoft Power Platform Developer-Austin, TX

    1 week ago

    Austin, United States Georgia IT Inc Full time

    Microsoft Power Platform Developer Location: Austin, TX (Rempte) Duration: 06 Months plus Rate: DOE US Citizens and Green cards Preferred. Notes: ***Agency System : Legislative Tracking System (LTS) 2.0 ***Position will be remote. Program will allow candidates who are within the state (Any location within the State of Texas). ***Please do not submit...

  • Splunk Admin/developer

    4 weeks ago

    Austin, United States COMTEC INFORMATION SYSTEMS Full time

    **LOOKING FOR US CITIZENS AND GREEN CARD HOLDERS ONLY..** **Title**: Splunk Admin/Developer **Location**: Austin, TX (Hybrid) ComTec has an immediate need for a Splunk Developer who can be part of our growing Splunk team. This role is responsible for developing reports and dashboards in Splunk and administering the Splunk...

  • Data Platform Engineer/ Greenplum Platforms

    1 week ago

    Austin, United States Georgia IT Inc Full time

    Data Platform Engineer/ Greenplum Platforms - Remote Location - Austin, TX Duration: 12 Months plus Salary: DOE Job Summary Hand-on experience with Greenplum Platforms and in-depth knowledge of Greenplum internal tools. Must have knowledge of Greenplum on PowerFlex, VMWare ESX, Networking, Interconnect, and Linux OS experience. Experience in Greenplum...

  • PeopleSoft Financial System Analyst

    4 weeks ago

    Austin, United States Vaachi Systems Inc. Full time

    Job DescriptionJob DescriptionJob Title: PeopleSoft FSCM System AnalystClient: Texas Health & Human Services CommissionLocation: Austin, TX (701 W 51st St, Austin, Texas 78751)Work Type: W2 (No Benefits)Work Location: Texas only (100% Remote)Work Hours: Monday Friday 8:00 AM 5:00 PM CentralApplication Closing Date: 04/26/2024The PeopleSoft Financials...

  • Data Analyst

    2 days ago

    Austin, United States ADVANTAGE BUSINESS CONSULTING LTD Full time

    **Responsibilities**: - Develop and implement databases, data collection systems, data analytics, and other strategies that optimise statistical efficiency and quality. - Acquire data from primary or secondary data sources and maintain databases/data systems. - Interpret data, analyse results using statistical techniques, and provide ongoing reports. -...

  • Business Analyst- Austin TX

    1 week ago

    Austin, United States Georgia IT Inc Full time

    Job: Business Analyst Location: Austin TX Duration: Contract Rate: DOE Job Description / Minimum Requirements: The Business Analyst (BA) position at the agency works on multiple projects that support the mission of the agency of improving outcomes for Texas students. This position performs advanced, senior-level business analysis work. The position...

  • Technical Support Analyst

    3 weeks ago

    Austin, United States GCS Technologies Full time

    Job DescriptionJob DescriptionJob SummaryTechnical Support Analysts at GCS are expected to have and maintain a high level of technical competence over a very large range of products. They will be expected to learn new products and technologies quickly and constantly. In addition, they are expected to have top notch communication skills. This is not your...

  • PeopleSoft Financial System Analyst

    4 weeks ago

    Austin, Texas, United States Vaachi Systems Inc. Full time

    Job Title: PeopleSoft FSCM System Analyst Client: Texas Health & Human Services Commission Location: Austin, TX (701 W 51st St, Austin, Texas 78751) Work Type: W2 (No Benefits) Work Location: Texas only (100% Remote) Work Hours: Monday Friday 8:00 AM 5:00 PM Central Application Closing Date: 04/26/2024 The PeopleSoft Financials Business Analyst role...

  • Systems Analyst V

    4 weeks ago

    Austin, United States Health & Human Services Comm Full time

    **Essential Job Functions**: - EJF2. May participate in the development and/or review of training materials to be provided to end users. Leads the assessment and analysis of training needs by identifying trends and/or soliciting input from program staff to ensure training materials and information are appropriate for both internal and external customers,...

  • System Analyst

    2 days ago

    Austin, United States HIREBLAZER LLC Full time

    Job Description Job Description Systems Analyst This is a remote role from anywhere within Texas. Experience as a systems analyst or a bachelor's degree, preferably in a technical or analytical field and three years of experience as a systems analyst Experience with a low code platform that includes hands-on experience in design, implementation, and...

  • System Analyst

    7 hours ago

    Austin, United States Diligent Tec, Inc Full time

    Title: System Analyst (Min 10 years required)Location: Austin, TX (Remote but local to the State of Texas)Must have minimum 1 year experience with anu State Client or Federal ClientDescription: We are seeking actively seeking a skilled System Analyst to join our team. In this role, you will play a crucial part in maintaining operational efficiency within our...

  • System Analyst

    58 minutes ago

    Austin, United States Diligent Tec, Inc Full time

    Title: System Analyst (Min 10 years required)Location: Austin, TX (Remote but local to the State of Texas)Must have minimum 1 year experience with anu State Client or Federal ClientDescription: We are seeking actively seeking a skilled System Analyst to join our team. In this role, you will play a crucial part in maintaining operational efficiency within our...