Database Consultant

Job Title: Database Consultant Duration: 04+ Months Start Date: ASAP Location: Austin, Texas 78751 (Hybrid) Position Type: Contract $70 - 80/hr on W2 or 1099 Description: Works under the general supervision of the Regulatory LTC Application Manager or their designee. This position is responsible for leading complex technical database activities for the information systems supporting the HHSC Division of regulatory Services. Provides support in the development and maintenance of data warehouse and reporting systems. Develops, tests, debugs and documents highly complex program code to implement functional and design requirements for reporting systems in the agency. Participates in code walk-throughs. Assists in the development and maintenance of system documentation. Works with other members of the development team and end-users. Develops and maintains expertise in a variety of programming and database management tools. Develops technical and user documentation and supports training as required. Required Skills: • Evaluates users' requests for new data elements and systems and incorporates into the existing shared data. Required 7 Years • Install and use Data Modeling tools like Tableau, Azure Data Factory (ADF), Informatica and etc. Required 7 Years • Develop logical and physical Data Models and Entity Relationship Diagrams. Required 7 Years • Implement database objects in an Oracle cloud RDBMS, Salesforce CRM. Required 7 Years • Advanced data modeler with experience in Design, creation, and maintenance data models representing production databases. Required 7 Years • Generate scripts to be in the database using data modeler tools. Required 7 Years • Incorporating changes to data model design. Required 7 Years • Write source to target mapping instructions as needed to support ETL development. Required 7 Years • Develop stored procedures, database triggers and complex PL/SQL packages where needed. Required 7 Years • Perform requirement analysis and provide data mapping guidance to application and development teams. Required 7 Years • Coordination and Collaboration: Work with various teams, including IT support, development, and operations, to gather information and expertise. Preferred 5 Years • Relies on limited experience and judgment to plan and accomplish goals. Preferred 5 Years • A certain degree of creativity, out of the box thinking, and latitude is required. Preferred 5 Years • Works under limited supervision with considerable latitude for the use of initiative and independent judgment. Preferred 5 Years • Communication: Keep stakeholders informed about the status of problems and solutions. Preferred 4 Years • Familiar with standard concepts, practices, and procedures within a particular field. Preferred 4 Years • Strong understanding of ETL (Extract, Transform, Load) to extract, transform, and load data, enabling businesses to use data for analysis and decision-making, extracting data from various sources, such as databases, files, and cloud services. Preferred 2 Years • Certification in Azure Data Factory (ADF), Informatica preferred. Preferred 2 Years • Experience understanding PERL scripts is a plus. Preferred 2 Years • Experience creating Tableau dashboard. Preferred 2 Years