SQL Developer/Analyst

4 weeks ago

Austin, United States Texas Department of Aging & Disability Services Full time
Job Description:
The SQL Developer/Analyst (Systems Analyst V) performs senior-level advanced functional and technical computer analysis work. Work is performed with minimal supervision and considerable latitude for the use of initiative and independent judgment and some delegated authority in carrying out the job functions and the mission of HHSC to improve existing systems. The Analyst performs highly technical duties involving the development of information systems and technology solutions.

Duties include: Analysis of user requirements, planning, and development of automated processes. Participates in complex information systems projects. Provides technical guidance to business areas. Extracts data from Oracle databases using a combination of SQL and ETL (Extract, Transfer, and Load) technologies. Uses Microsoft Office or other tools to create reports for end users. Creates and/or modifies complex stored procedures using PL SQL. Creates system documentation and status reports. Keeps professional skills updated and consistent with information technology trends. Coordinates activities with customers and other internal and external Information Technology (IT) functional areas. Provides 24/7 on call support in response to job failures and other technical issues on a rotating basis and may be called as needed for SME (subject matter expert) issues. The Analyst works as required with all IT Technical Teams, customers, other IT functional areas, and other state agencies and federal oversight entities.

This position is for U.S. Citizens or residents only. Essential Job Functions:
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Monitors, maintains, and provides support for Financials Data Warehouse (FDW) processes, systems and interfaces - including but not limited to Admin Apps Provider Payment Systems, CAPPS Financial imports and interfaces, custom Financial and HR tables and views. Supports MIMS (Materials and Inventory Management System) interfaces and provides backup support for Lawson application. Assists in setting up and monitoring batch schedules for aforementioned processes, systems and interfaces. Writes, debugs, and maintains highly complex PL SQL Stored Procedures and shell scripts. Creates, debugs, and maintains Informatica Powermart ETL’s (Extract, Transform, Load). (40%)

Produces technical analysis and solutions for FDW systems that ensure consistency with HHSC IT standards, State of Texas ERP standards, and existing HHSC strategies and projects in accordance with established standards, policies and procedures. Participates in application design sessions. Develops technical analyses and produces expected deliverables by established due dates. Coordinates technical solutions that meet immediate needs and provide for HHSC agency’s long-term goals. (20%)

Produces documentation that ensures consistency with HHSC IT standards and State of Texas ERP standards. Develops work plans and coordinates with Health and Human Services (HHSC) enterprise organization to produce technical solutions and work products in accordance with state statutes and legislative mandates. Develops technical documentation for internal IT staff or external customers. Coordinates development and/or review of functional documentation for customers as it relates to a technical solution developed. (20%)

Undertakes knowledge transfer to colleagues of Financials Data Warehouse technical analysis/ development skills. Performs mentoring and produces documentation that results in knowledge transfer to other technical analysts within the FDW team to aid in the development of their technical skills. (10%)

Develops and provides routine status reports to Product Support Data Services Manager in accordance with established standards, policies and procedures. (10%) Knowledge Skills Abilities:
Knowledge of information technology standards, practices, and project lifecycle.
Knowledge of information technology equipment and computer systems.
Knowledge of Agile software development processes.
Skilled in writing complex SQL.
Skilled in query design, development, testing, and tuning.
Skilled in oral and written communications that convey technical analysis and data results in common business terms that management, executive, and non-technical customers can understand.
Skilled in use of Microsoft Office or equivalent tools.
Ability to troubleshoot and problem solve advanced technical issues in a complex system environment.
Ability to effectively train and mentor other team members.
Ability to provide excellent customer service.
Ability to develop technical reports, develop work plans, track progress, and provide oral and written status reports.
Ability to be flexible and handle multiple priorities.

  • Senior SQL Developer/Analyst

    17 hours ago

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

    Job Summary:The Texas Department of Aging & Disability Services seeks a highly skilled Senior SQL Developer/Analyst to join our team. As a key member of our IT department, you will be responsible for designing, developing, and implementing advanced database solutions to support our business operations.Key Responsibilities:Design and develop complex database...

  • Advanced SQL Analyst

    4 days ago

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

    Job Overview: The Senior SQL Developer/Analyst is responsible for executing advanced functional and technical analysis in computer systems. This role operates with a high degree of autonomy, requiring initiative and independent judgment while aligning with the mission of the Texas Department of Aging & Disability Services to enhance existing systems. The...

  • SQL Server Developer

    3 weeks ago

    Austin, United States Vlink Full time

    Job Title:SQL Server Developer Location:Austin, TX Duration:Long TermAbout VLink: Started in 2006 and headquartered in Connecticut, VLink is one of the fastest growing digital technology services and consulting companies. Since its inception, our innovative team members have been solving the most complex business, and IT challenges of our global clients. Job...

  • SQL/ETL Developer

    1 month ago

    Austin, Texas, United States CLA (CliftonLarsonAllen) Full time

    CLA is a leading national professional services firm dedicated to creating opportunities for clients, employees, and communities. We offer wealth advisory, digital, audit, tax, consulting, and outsourcing services. Our culture values diverse perspectives and collaboration.Job Title: SQL/ETL Developer - LeadAbout the Role:Design, implement, and maintain...

  • PL/SQL Developer

    3 weeks ago

    Austin, United States VMC Soft Technologies, Inc Full time

    W2 CONTRACTNO C2CTitle: Oracle PL/SQL DeveloperLocation: Austin, TX (Onsite)Responsibilities:Hands on experience in working with pl/sql procedures, functions, packages, triggers, indexes, cursors, records, exception management, date and time functions, aggregate functions, analytical functions, joins, hierarchical queries, other data structures or components...

  • Java Developer with Strong SQL

    1 week ago

    Austin, United States Tekfortune Inc Full time

    Java Developer with Strong SQL - 06 positionsSan Jose, CA, Austin, TX & Chicago, IL Can be placed at any one of locations and Hybrid 3 days a weekInterview Process: 2 Rounds of InterviewJob Description: solid server-side development with Java. Strong OOP skills, ability to analyze requirements and prepare design. Passion for developing robust, scalable...

  • Java Backend Developer with SQL

    4 weeks ago

    Austin, United States Zortech Solutions Full time

    Job DescriptionJob DescriptionRole: Java Backend Developer with SQLLocation: San Jose CA or Austin TX or Chicago IL (Hybrid)Duration: 6+ MonthsJob Description: 8 to 10 years of Java backend development experience Strong SQL queries experience needed

  • Developer/Programmer Analyst III

    3 months ago

    Austin, United States Optimized Technical Solutions Full time

    Job DescriptionJob DescriptionI. DESCRIPTION OF SERVICESThe Developer/Programmer Analyst performs advanced analysis and programming work involving all technical aspects of designing, creating and maintain software applications.This position will work with the Texas Student Data System (TSDS) development team to provide the following Software Development...

  • Oracle PL/SQL Developer

    1 week ago

    Austin, United States Syntricate Technologies Full time

    Required Skills: Relevant Experience - 5-8 yrs. Candidate Must have knowledge in the following areas - Oracle database architecture Oracle SQL, PL/SQL, Metadata queries Oracle query performance tuning Oracle JSON processing Unix shell scripting Git - source version control Good to have Oracle wallet usage and management NoSQL databases,...

  • Oracle PL/SQL Developer

    2 months ago

    Austin, United States Syntricate Technologies Full time

    Required Skills: Relevant Experience - 5-8 yrs. Candidate Must have knowledge in the following areas - Oracle database architecture Oracle SQL, PL/SQL, Metadata queries Oracle query performance tuning Oracle JSON processing Unix shell scripting Git - source version control Good to have Oracle wallet usage and management NoSQL databases,...

  • Business Analyst

    4 months ago

    Austin, United States RxCloud Full time

    About the job Business Analyst Job description A business analyst must have the analytical capabilities to work with data. They must first be able to extract data from a database. Business analysts use SQL reports to track and analyze key performance metrics. Skills : Integrations, SQL, Business Analysis Responsibilities: Use statistical methods to analyze...

  • Technical Systems Analyst

    17 hours ago

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

    Job Description:The Systems Analyst IV plays a critical role in the development and support of applications used by staff at the Texas Department of Aging & Disability Services. This position involves performing computer systems analysis and development work, coordinating with stakeholders to automate processing and improve existing systems.Key...

  • Business Analyst-QA/Agile/SQL

    5 months ago

    Austin, United States Terbium Technologies Full time

    Required Experiences Experience developing QA test plans/test Cases hands-on QA testing from Integration through UAT for enterprise systems SQL Experience Experience administrating and coordinating large-scale QA Considerable experience in process business or systems analysis and work on complex cloud infrastructure systems required. Automated testing...

  • Business Analyst-QA/Agile/SQL

    5 months ago

    Austin, Texas, United States Terbium Technologies Full time

    Required Experiences Experience developing QA test plans/test Cases hands-on QA testing from Integration through UAT for enterprise systems SQL Experience Experience administrating and coordinating large-scale QA Considerable experience in process business or systems analysis and work on complex cloud infrastructure systems required. Automated testing...

  • Fraud Analyst

    2 hours ago

    Austin, United States Flexton Inc. Full time

    Role - Data Analyst OR Business Data Analyst OR Sr Fraud BI Analyst [Tableau,SQL,Python]Data Analyst – will be Responsible for creating reports and dashboards for the Fraud/AML/KYC teams using Tableau, SQL, and PythonExpertise in Tableau for data visualization and create interactive and insightful dashboards.Will be writing high quality SQL to retrieve and...

  • Developer/Programmer Analyst III

    3 months ago

    Austin, United States Optimized Technical Solutions Full time

    Job DescriptionJob DescriptionI. DESCRIPTION OF SERVICESThe Developer/Programmer Analyst performs advanced analysis and programming work involving all technical aspects of designing, creating and maintain software applications.This position will work with the Texas Student Data System (TSDS) development team to provide the following Software Development...

  • IRM Developer Sys Analyst IV

    4 weeks ago

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

    Job Description: The Systems Analyst IV functions as developer/analyst on the Batch Interfaces team for on-going support of applications used by Texas Department of Family and Protective Services (DFPS) staff. The position performs computer systems analysis or development work. Work involves coordinating, planning and analysis of user requirements,...

  • Database Administrator

    1 month ago

    Austin, United States Script Care LTD Full time

    Job DescriptionJob DescriptionPURPOSE OF THE ROLEThe DBA/Analyst plays a crucial role in the design and administration of databases across SQL Server, PostgreSQL, and Snowflake platforms. This position also involves configuring and monitoring automated ETL and BI tools, including Qlik and Looker, to ensure efficient data movement between repositories. In...

  • Lead Cogito Business Intelligence Developer

    3 months ago

    Austin, United States Central Health Full time

    Overview Residing on the Reporting, Analytics, and Business Intelligence Team, the Lead Cogito BI Developer leads and provides technical expertise in the design, development, testing, documentation, maintenance of Epic reporting and analytic solutions including Caboodle/Clarity databases and Healthy Planet, Radar, SlicerDicer, and Reporting Workbench...

  • IT Data Analyst

    6 days ago

    Austin, United States Script Care LTD Full time

    Job DescriptionJob DescriptionPURPOSE OF THE ROLEThe Information Technology Data Analyst is responsible for the manipulation of data, as well as designing and creating new ad hoc, standard and automated reports from various databases and reporting systems. This position will assist in the development of new reporting processes and update existing processes...