SQL Developer/Analyst

4 months 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

    4 weeks ago

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

    Job Title: Senior SQL Developer/AnalystAt the Texas Department of Aging & Disability Services, we are seeking a highly skilled Senior SQL Developer/Analyst to join our team. As a key member of our IT department, you will be responsible for performing advanced functional and technical computer analysis work. Your expertise in SQL development, database...

  • Backend Developer SQL

    4 weeks ago

    Austin, Texas, United States Mindteck Full time

    Job Title: Backend Developer SQLWe are seeking a highly skilled Backend Developer with expertise in SQL to join our team at Mindteck. As a Backend Developer, you will be responsible for designing, developing, and deploying scalable and efficient backend systems using Java and SQL.Key Responsibilities:Design and develop backend systems using Java and...

  • Data Analyst with Advanced SQL and Python Expertise

    4 weeks ago

    Austin, Texas, United States Eateam Full time

    Job SummaryEateam is seeking a highly skilled Data Scientist with expertise in Python and SQL to contribute to the development of multiple work streams and projects. The ideal candidate will have a solid understanding of data management concepts, including data processing, analytics, machine learning, and visualization.Key ResponsibilitiesDevelop data...

  • Software Developer

    4 months ago

    Austin, United States University of Texas at Austin Full time

    Develop, maintain, and enhance current custom legacy software systems, Python / Django, Oracle, and SQL systems used by UHD staff and customers. Develop new applications on modern platforms based on business needs with a focus on customer requests. Develop, maintain, and enhance systems integrations between current and future UHD systems. Systems include but...

  • Oracle PL/SQL Developer

    2 weeks ago

    Austin, United States Apexon Full time

    Role Title: Oracle PL/SQL DeveloperLocation: Austin, TX (Day-1 Onsite)Required Skills:3 – 5 Years of Strong knowledge of Oracle database conceptsExcellent design and technical skills with Oracle PLSQL and SQL Development (including stored procedures, packages, functions, triggers, cursors, views, materialized views for processing data, enforcing...

  • Systems Analyst V

    2 months ago

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

    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)...

  • Oralce PL/SQL Developer

    3 weeks ago

    Austin, United States Apexon Full time

    Job DescriptionRole Title: Oracle PL/SQL DeveloperLocation: Austin, TX (Day-1 Onsite)Required Skills:3 – 5 Years of Strong knowledge of Oracle database conceptsExcellent design and technical skills with Oracle PLSQL and SQL Development (including stored procedures, packages, functions, triggers, cursors, views, materialized views for processing data,...

  • Business Systems Analyst

    4 weeks ago

    Austin, Texas, United States RxCloud Full time

    About the RoleAbout the job Business AnalystJob descriptionA 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.Key ResponsibilitiesUse statistical methods to analyze data and generate useful business...

  • Senior Java Developer with Advanced SQL Expertise

    4 weeks ago

    Austin, Texas, United States Tekfortune Inc Full time

    Job Title: Senior Java Developer with Advanced SQL ExpertiseAt Tekfortune Inc, we are seeking a highly skilled Senior Java Developer with advanced SQL expertise to join our team.Key Responsibilities:- Develop solid server-side applications with Java- Utilize strong OOP skills to analyze requirements and prepare design- Collaborate with the team to create...

  • Data Analyst

    4 weeks ago

    Austin, Texas, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job Title: Data AnalystJob Summary:Futran Tech Solutions Pvt. Ltd. is seeking a skilled Data Analyst to join our team. The ideal candidate will have strong SQL skills and experience with data analysis and visualization using Tableau.Key Responsibilities:• Develop reports and dashboards in Tableau• Conduct data analysis and visualization• Collaborate...

  • Oracle PL/SQL Developer

    4 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,...

  • Data Analyst

    4 weeks ago

    Austin, Texas, United States Microsoft Corporation Full time

    Job DescriptionJob Title: Data AnalystJob Summary:We are seeking a highly skilled Data Analyst to join our team at Microsoft Corporation. As a Data Analyst, you will be responsible for developing reports, dashboards, and analytical insights to drive business success.Key Responsibilities:Develop reports, dashboards, and tabular models to analyze data and...

  • Data Analyst III

    4 weeks ago

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

    Job Title: Data Analyst III - VJob Summary: We are seeking a highly skilled Data Analyst III - V to join our team at the Texas Department of Aging & Disability Services. As a Data Analyst III - V, you will be responsible for gathering and analyzing requirements, report design and implementation, and on-going maintenance of existing reports and processes. You...

  • Data Analyst

    4 weeks ago

    Austin, Texas, United States Microsoft Corporation Full time

    Job Title: Data AnalystJob Summary:We are seeking a highly skilled Data Analyst to join our team at Microsoft Corporation. As a Data Analyst, you will be responsible for producing business intelligence (BI) information by querying data repositories and generating periodic reports.Key Responsibilities:Design and build BI solutions that improve Microsoft...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Austin, Texas, United States Omni Inclusive Full time

    Key Responsibilities:As a Senior Business Intelligence Analyst at Omni Inclusive, you will be responsible for delivering Data Warehousing/Business Intelligence solutions that meet customer needs. This involves gathering customer requirements, analyzing data, and producing solution requirements. Advanced SQL skills are highly desirable, and experience in...

  • Hormel Application Development Analyst Intern

    1 month ago

    Austin, Minnesota, United States Hormel Full time

    Job SummaryJoin our team as an Application Development Analyst Intern at Hormel Foods Corporation. As an intern, you will gain real-world application development experience and exposure to the technology aspects of a manufacturing industry.ResponsibilitiesDevelop, configure, and support a mission-critical applicationParticipate in web development and...

  • Business Analyst

    1 month ago

    Austin, United States Premier Global Links Full time

    Location: Remote (Must be located in Texas) Job Summary: We are seeking a highly skilled Business Analyst to join the Administrative Applications Production Data Services team as a contractor. This role focuses on supporting the development and implementation of enhancements and modifications to the Financial Data Warehouse. Requirements: Minimum Experience:...

  • Business Analyst

    4 weeks ago

    Austin, United States Premier Global Links Full time

    Location: Remote (Must be located in Texas) Job Summary: We are seeking a highly skilled Business Analyst to join the Administrative Applications Production Data Services team as a contractor. This role focuses on supporting the development and implementation of enhancements and modifications to the Financial Data Warehouse. Requirements: Minimum Experience:...

  • Principal Data Analyst

    2 days ago

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

    Job Title: Technical Reporting AnalystJob Summary:We are seeking a skilled Technical Reporting Analyst to join our team at the Texas Department of Aging & Disability Services. As a Technical Reporting Analyst, you will be responsible for designing, developing, and implementing reporting methodologies for multiple areas of specialization. You will work...

  • Data Analyst

    4 weeks ago

    Austin, Texas, United States Nomi Health Full time

    Data Analyst Job DescriptionWe are seeking a skilled Data Analyst to contribute to our team in Austin, Texas. The ideal candidate will have a strong academic background in data analysis, statistics, and computer programming.Key Responsibilities: Use best practices to transform and prepare data for analysis, ensuring data quality and reliability. Create and...